Everything was working good until today. I’m the main account and I have two managed users who have restrictions on shows and movies (they are my kids). Now when they log into Plex the home screen has no content. They can browse to the folders and see all the shows and movies but when they go HOME there is no content. No settings or library changes have taken place on my end. Any ideas? I’m using Version 1.11.1.4730
This is for my home server only, if they change the server to Plex Cloud then the content shows on the HOME screen
There appears to be a problem with loading the dashboard when there are restrictions. This is being raised with the development team and if you can provide logs with debug logging for the time of the error - I will add it to the issue that is being raised
I too discovered the same issue for my kids (Managed Users) and rolled back to previous PMS Version 1.11.0.4666. I have now skipped the latest version PlexMediaServer_1.11.1.4730-6967ec0b1_x86_64.qpkg
@ian78 said:
Ok as soon as I get home I’ll look into getting the logs
attached
Thank you - we now have all the information that is needed to look into this
By the way, editing a forum post does not raise a notification. I was not aware you added the logs until I got the notification from the following post
Pretty sure this is related to a query portion that’s missing, which causes broken SQL:
Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - QueryParser: Invalid field 'onlyTransient' found, ignoring. Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - SQLITE3:0x10, 1, near ")": syntax error Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - Soci Exception handled: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id as 'id', parents.id as 'parent_id', grandparents.id as 'grandparent_id', metadata_items.added_at as 'added_at', metadata_items.library_section_id as 'library_section_id', grandparents.extra_data as 'extra_data' from metadata_items join metadata_items as parents on metadata_items.parent_id = parents.id join metadata_items as grandparents on parents.parent_id = grandparents.id where metadata_items.library_section_id in (2) and ((metadata_items.metadata_type=4 or metadata_items.metadata_type=10) and ) order by metadata_items.added_at desc limit 400
If you note just before the ORDER BY clause, the last member of the WHERE clause is missing, which generates a SQL exceptino.
@imajes said:
Pretty sure this is related to a query portion that’s missing, which causes broken SQL:
Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - QueryParser: Invalid field 'onlyTransient' found, ignoring. Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - SQLITE3:0x10, 1, near ")": syntax error Jan 28, 2018 12:16:56.061 [0x7f276fbff700] ERROR - Soci Exception handled: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id as 'id', parents.id as 'parent_id', grandparents.id as 'grandparent_id', metadata_items.added_at as 'added_at', metadata_items.library_section_id as 'library_section_id', grandparents.extra_data as 'extra_data' from metadata_items join metadata_items as parents on metadata_items.parent_id = parents.id join metadata_items as grandparents on parents.parent_id = grandparents.id where metadata_items.library_section_id in (2) and ((metadata_items.metadata_type=4 or metadata_items.metadata_type=10) and ) order by metadata_items.added_at desc limit 400
If you note just before the ORDER BY clause, the last member of the WHERE clause is missing, which generates a SQL exceptino.
yes there is a null / missing condition - the issue has been referred to the development team to fix
Also noticed with this is that my Plex iOS app will no longer play videos without freezing. Plex works fine on Android and Xbox but not on iOS and only noticed this after the update which is causing the managed user problem as well.
I’m hesitant to rolling it back as I don’t want to lose any settings , watched status and database covers etc
@ian78 said:
Also noticed with this is that my Plex iOS app will no longer play videos without freezing. Plex works fine on Android and Xbox but not on iOS and only noticed this after the update which is causing the managed user problem as well.
I’m hesitant to rolling it back as I don’t want to lose any settings , watched status and database covers etc
Please could you raise a separate forum topic with logs from the server and the iOS app and indication as to when the freeze arose
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
@HappyPig0 said:
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
I am afraid the fix missed the cut-off time for this release. I would expect it to be in the following release
@HappyPig0 said:
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
Agreed
Do you have info or lead me in the correct direction as to how I can roll back without losing my metadata and managed user watched inprogress status etc
@HappyPig0 said:
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
Do you have info or lead me in the correct direction as to how I can roll back without losing my metadata and managed user watched inprogress status etc
You may find you have previous versions in the local appdata updates folder
Default location C:\Users\xxxxxxxxxx\AppData\Local\Plex Media Server\Updates
On windows to downgrade, must first go through Uninstall through Add/Remove programs
@HappyPig0 said:
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
I am afraid the fix missed the cut-off time for this release. I would expect it to be in the following release
I am sorry but some more urgent fixes jumped the queue - should get the fix out soon
@HappyPig0 said:
I don’t get why Plex releases a new version (1.11.1.4753) but without a fix for the Managed user issues reported here, or at least confirmation the issue remains unresolved.
I just made the update only to find I have to roll back again to Version 1.11.0.4666 (released 29th Dec 2017). Total waste of time! Not good guys!
CC. @chrisallen
I am afraid the fix missed the cut-off time for this release. I would expect it to be in the following release
I am sorry but some more urgent fixes jumped the queue - should get the fix out soon
Can’t come soon enough, thought I was losing my mind, glad I checked here before wasting a lot of time trying to troubleshoot it.
