Creating a playlist from “Sort - Album Rating” fails while it is possible to do the same with “Sort - Track Rating”. Error message displayed : There was a problem adding to the playlist. Playlist then gets created empty. Tested using Safari on macOS and Plex Media Player, same issue.
Relevant logs :
Mar 28, 2017 13:42:34.635 [0x7f1c6abff700] DEBUG - Request: [172.17.0.4:35480 (WAN)] POST /playlists?type=audio&title=Music&smart=1&uri=library%3A%2F%2F1c01a462-7cd4-479b-bf50-bbe767a71160%2Fdirectory%2F%252Flibrary%252Fsections%252F6%252Fall%253Falbum.userRating%253D8%2526type%253D9 (5 live) GZIP Signed-in Token (XXXXXXX)
Mar 28, 2017 13:42:34.637 [0x7f1c6abff700] DEBUG - Added new metadata item (Music) with ID 50077
Mar 28, 2017 13:42:34.639 [0x7f1c6abff700] ERROR - SQLITE3:0x10, 1, no such column: parents_settings.rating
Mar 28, 2017 13:42:34.639 [0x7f1c6abff700] ERROR - Soci Exception handled: sqlite3_statement_backend::prepare: no such column: parents_settings.rating for SQL: select sum(round(duration/1000, 0)) from (select max(media_items.duration) as duration from metadata_items left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id join media_items on media_items.metadata_item_id=metadata_items.id join media_parts on media_parts.media_item_id=media_items.id where metadata_items.library_section_id=6 and (parents_settings.rating=8 and metadata_items.metadata_type=10) group by metadata_items.id )
Mar 28, 2017 13:42:34.640 [0x7f1c807fe700] DEBUG - Completed: [172.17.0.4:35480] 500 POST /playlists?type=audio&title=Music&smart=1&uri=library%3A%2F%2F1c01a462-7cd4-479b-bf50-bbe767a71160%2Fdirectory%2F%252Flibrary%252Fsections%252F6%252Fall%253Falbum.userRating%253D8%2526type%253D9 (4 live) GZIP 4ms 449 bytes
Please recreate this one more time and then capture the log files (settings - server - help - download logs) and attach them here. I will see if/how we can reproduce.
If unable to reproduce, they might wish to ask for your DB in PM.
Fix “is” operator with title and other string custom filters
But the issue is still present, with the “is” or the other operators. I guess the fix on those operators for our case will be coming in the 3.2.2 update then?
I’m getting the same error that seems to have started for me with 1.18.0.1944
Trying to shuffle play a filtered album view that uses a filter of Album Rating is not Empty.
Oct 27, 2019 19:49:42.656 [0x7fa1f7fff700] ERROR - SQLITE3:(nil), 1, no such column: parents_settings.rating in "select parents.id,metadata_items.id,metadata_item_settings.rating,metadata_item_settings.last_viewed_at,metadata_items.rating_count,metadata_items.guid from metadata
Oct 27, 2019 19:49:42.656 [0x7fa1f7fff700] ERROR - LPE: exception generating query for invalid path ‘library://x/directory/%2Flibrary%2Fsections%2F6%2Fall%3Ftype%3D9%26album%2EuserRating!%3D-1’: sqlite3_statement_backend::prepare: no such column: parents_settings.rating for SQL: select parents.id,metadata_items.id,metadata_item_settings.rating,metadata_item_settings.last_viewed_at,metadata_items.rating_count,metadata_items.guid from metadata_items join metadata_items as parents on parents.id=metadata_items.parent_id join metadata_items as grandparents on grandparents.id=parents.parent_id left join metadata_item_settings on metadata_item_settings.guid=metadata_items.guid and metadata_item_settings.account_id=? where metadata_items.library_section_id in (6) and ((parents_settings.rating is not null) and metadata_items.metadata_type=10) order by parents.parent_id,parents.id,metadata_items.rating_count desc
