Reading Repair a Corrupt Database | Plex Support the first step after copying that database is sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort’” which fails with Error: no such index: index_title_sort_naturalsort
Are there updated instructions somewhere? (Plex appears to be working fine, but is reporting the database is corrupted.)
No, as the command I am using is the first command in the “run a repair” section on that page (after the copy command).
Run a Repair
Even if the integrity check doesn’t return errors, it can still sometimes help to try and repair the database. In order to try and “repair” the database, you can perform a dump followed by a restore to get it back to normal. Run the following commands in the Command Prompt in order.
You can no long use the standalone sqlite3 for this step and with regard to database repair it is a bit redundant since the .dump and restore does that step anyway.
Do the tools exist on Synology? From my research, if you downloaded plex from the package manager it should be: "/volume1/@appstore/Plex Media Server/Plex Media Server"
But what I am trying to find: Is if you use the plex docker image to run it as a container (on Synology) do the tools exist? Is the ‘Plex Media Server’ executable and other tools downloaded to the config mapped path for the container? Or are these tools not available to the docker container/image?