Dashboard stopped worki ng after upgrade 1.01.2396

General Discussions
1

Server: plexmediaserver-1.0.1.2396-c094d0d.x86_64 on Centos 7
Client: Web browser Version 51.0.2704.103 (64-bit)

After the upgrade Discover-TV Shows stopped working.

2

Please provide us with plex logs and a screenshot, I am running that version my self no issues with the dashboard.

3

um, where do I get the plex logs?

4

@dsmouse said:
um, where do I get the plex logs?

/var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Logs/

5

'K attaching.

6

@dsmouse said:
'K attaching.

and screenshot?

7


ok here’s the screenshot too

8

Gone…

9

Your database is corrupt.
Jul 17, 2016 11:09:26.240 [0x7f87ab59c840] ERROR - SQLITE3:0x10, 11, database corruption at line 57498 of [8a8ffc862e]
repair it using this procedure:
https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

or with a more recent version of SQLite, the 4 steps are more like:

sqlite3 "$PLEX_HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" "PRAGMA integrity_check"

sqlite3 "$PLEX_HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" .dump > dump.sql

mv "$PLEX_HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" "$PLEX_HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db.original"

sqlite3 "$PLEX_HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" < dump.sql

Only perform with Plex stopped. Execute in-order and abort if an error message comes up.

10

Thanks, that took a while but fixed it

11

Out of curiosity: did you use the commands in the linked knowledge base article
or those I cited above?

12

Just reporting in that I had a similar issue on OS X with the same version of the Media Server. Screenshot looked the same. There were no errors in the log. I used the instructions in the knowledge base, and even though the initial check reported no errors, doing the repair allowed the dashboard to load again.

For some background to when this happened. I just did a new install of PMS today, loaded all my libraries, and the dashboard started failing to load after I went through and marked a bunch of my TV shows/series as watched. I tried restarting PMS and rebooting before coming here, but the DB repair is what it took.