Ubuntu 18.04 @ Hetzner
Plex database has bad data for a few files. Specifically, the orginally_available_at field on 3 movies is incorrect, forcing them to always at the front of the “Recently Added”.
To repair the database, I usually stop the plex media server, make a backup copy of the database, then download it to a local machine to run queries to repair, then upload and copy back into place, before restarting the server.
I use sqlite3 to run the queries but this time, the database has a tokenizer error - collating. I think the version of sqlite3 that Plex is using is different in some way that it has been before.
I am aware that plex installs with its own instance of sqlite. I think using the installed version under the plex media server should work BUT …
When you install plex using plexguide, where is the actual plex media server and sqlite? I know where the database is located but I have never needed to learn the path for the media server folder.
Any help would be greatly appreciated!