Error: There was an unexpected error loading the dashboard

General Discussions
1

Since couple of versions ago my local users and Friends can’t see the Dashboard in any client: android, roku, iphone, etc.
The error is: “There was an unexpected error loading the dashboard”
The main user (mine) is the one that still works for some reason.
My Plex Server version is: Version 1.11.1.4760
I’ve searched other threads and done optimize db, empty trash, clear bundles, etc … No difference.
Checking the logs I found this error:
Feb 03, 2018 14:27:55.917 [0x7fb39d7ff700] ERROR - SQLITE3:0x10, 1, near ")": syntax error Feb 03, 2018 14:27:55.917 [0x7fb39d7ff700] 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 (6,2) and ((metadata_items.metadata_type=4 or metadata_items.metadata_type=10) and ) order by metadata_items.added_at desc limit 400

So it seems this query involved in the dashboard is having a syntax error??

Please assist.

Thanks.

2

Yes - we have several forum topics on that

A fix will be released soon

The error arises when there are labels / restrictions on a Plex Home Managed User account

3

Thanks for the update.

4

“A fix will be released soon” = maybe a year or more in Plex speak.

5

@Anijake said:
“A fix will be released soon” = maybe a year or more in Plex speak.

Please desist

6

@sa2000 said:

@Anijake said:
“A fix will be released soon” = maybe a year or more in Plex speak.

Please desist

No

7

@sa2000 Is there any “official” link showing any more detail and maybe an ETA? This is really affecting how all the users use Plex.

8

@cesalo said:
@sa2000 Is there any “official” link showing any more detail and maybe an ETA? This is really affecting how all the users use Plex.

There is no more detail. The fix has been written and it is in the pipeline to be released in a forthcoming beta.
The live TV/DVR lockout/hangs bug fixes were more urgent and got pushed out in 1.11.1.4760 ahead of the SQLITE3 error fix for this issue

9

Just installed last Plex Server version (1.11.1.4768) and issue is solved. Thanks a lot.

10

Yes the hot fix beta release has come out

A beta hot fix version of Plex Media Server has just been released - Plex Media Server 1.11.1.4768

See Release Notice

  • (Hubs) Recently Added TV hub failed to load for managed users with content restrictions. (#8123)
11

Can you tell me if there is still a known issue with this? I’ve been getting it for a few weeks on web and my AppleTVs and FireTVs will not load anything into the “home” menu.

12

There isn’t

Please ensure debug logging is enabled and restart the server and capture logs when you get the error. Please attach the logs zip and an indication of the time of error