Sample Database queries for Movies and TV Shows

These should be one and the same.

Plex will often not clear the trash if the database is damaged.

If the DB file is healthy, a regular reason that the trash is retained is that not all the paths listed on the “Add Folders” tab of a library are:

  • existent
  • accessible to Plex server
  • not completely empty

There is a third reason cropping up lately, but only specifically if your server is running on a Mac and uses a Synology NAS as media storage: Plex Files Unavailable but they’re not missing - #525 by scuzzbono