Plex Library empty but collections/recommended work fine (plays movies too)

Plex Media Server
, ,
1

Server Version#: 1.24.5.5173-8dcc73a59_amd64.deb
Player Version#: Version 4.69.1 (???) on web, Android plex app (updated)

The library tab shows an error “Something went wrong” and unexpected error occurs. I turned on debug logging and the only error I was able to find was a “500 error” when trying get to the library.

Movies showing in the recommended/recent and other areas all play and work fine. I’ve refreshed metadata 3-4 times with no luck.

Other media like TV shows, shows the library tab fine as well. Very strange it’s just movies and that one tab.

2

First, try Cannot see Playlists, Smart Playlists in Plex Web - #2 by OttoKerner

If that doesn’t change anything:

  1. activate debug logging (not ‘verbose’!)
  2. quit Plex Server
  3. wait 1 minute
  4. start Plex Server
  5. wait 5 minutes
  6. fetch log files and attach them here

Or inspect them yourself. Take a look at the Plex Media Server.log file and seek for messages about database corrupt or malformed.
If you find these, you may have to repair your database.

3

I did find some corrupt errors in the logs when I looked at them manually. I tried running the tool and got this:
sudo ./‘Plex SQLite’ /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/ “PRAGMA integrity_check”
Error: near “Support”: syntax error

So I am assuming I need to run a repair?

4

Is it easier to remove the movies from PLEX and then re-add it?

5

Your path to the executable looks wrong.
And you failed to “escape” the space characters in your path names.

If you didn’t do any manual metadata corrections and you don’t care for your “played/unplayed” data, it might be.

6

/usr/lib/plexmediaserver$ sudo ./‘Plex SQLite’ ‘/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/’ “PRAGMA integrity_check”
Error: unable to open database “/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/”: unable to open database file

I am in the same dir as Plex SQLite. (I escaped the logs dir). Here is a screenshot of my logs location (I don’t see anything that looks like a db?).

nologs.PNG
nologs.PNG743×584 126 KB
The location is per Where is the Plex Media Server data directory located? | Plex Support

7

Ok I figured out where the database is. This link probably needs to be updated Where is the Plex Media Server data directory located? | Plex Support

try1.PNG
try1.PNG895×194 70.4 KB

The check came back ok. I then tried the repair option per Repair a Corrupted Database | Plex Support

All permissions look right and I still am getting an error when trying to load the library.

try2.PNG
try2.PNG846×465 72.8 KB

8

Ok, it looks like the best option is to remove and then re-add the library. Nothing else seems to work.

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.