With Plex Media Server stopped, open the database in Plex SQLite and issue the DELETE from external_metadata_items; command.
- Plex Media Server must be stopped.
- Must run as root (sudo).
- Don’t miss the semicolon at the end of the command.
On my Synology running DSM 7. You should be able to copy/paste the lines.
L0neWo1f@tonkawa:~$ sudo "/var/packages/PlexMediaServer/target/Plex SQLite" "/var/packages/PlexMediaServer/shares/PlexMediaServer/AppData/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"
SQLite version 3.39.4 2022-09-29 15:55:41
Enter ".help" for usage hints.
sqlite> DELETE from external_metadata_items;
sqlite> .quit
L0neWo1f@tonkawa:~$
When finished, run DBRepair.
sudo ./DBRepair.sh stop auto start exit
Then see if Plex Media Server runs OK.
References:
This thread mentions the Null value not allowed... error message and using DELETE.... to try and fix it: Upgrade to 1.40.0.7998 causes error - #28 by ChuckPa
Repair a Corrupt Database provides the location of Plex SQLite.
