Server Version#: 1.30.0.6486
Player Version#: 9.13.1.37459
Hi, I’ve a problem since 2 days now.
I wanted to delete an anime’s files and replace by another version with better bitrate, so I did it and then update base, but it didn’t change the files in my library. Then I tried to rename the folder, noting changed, no detection. I cut and pasted the files in another folder of my external drive and it still didn’t change anything, like if the update didn’t work and it doesn’t understand the files are not there anymore.
I even downloaded the old files and put it the folder to detect them again and try to delete them through plex database and not on my computer directly, and it didn’t even found the files, error msg :
" Il y a eu un problème lors de la suppression de cet élément." ← french
Honestly I don’t know what to do, I can’t update with the new files, I can’t delete the old files, and whatever I do (change folder’s name or move the files in another folder), it doesn’t change anything.
It seems compeltely broken while at the beginning I just wanted to replace some files by other versions for a same anime… seems crazy.
Sounds like there might be an issue with your database.
Your server logs should show some related errors. If it is a database problem, you might need to attempt repairing it.
I think I’ll try to repair the database, do you know where the sqlite is located on nvidia shield (internal storage) I can’t find it.
Here is the folder I think :
\internal\Android\data\com.plexapp.mediaserver.smb\Plex Media Server but after that here is what I’ve in the folder :
Should be in ./Plug-in Support/Databases/ (as per the support article).
It might be worth checking the server logs before blindly tinkering with the database – especially if you need to do that off the SHIELD anyway.
I opened randomly one log file (Plex Media Scanner Analysis.1.log) (I don’t know what to check there is like 50 files .log …) and here is one line for example :
Jan 11, 2023 21:39:03.787 [22529] ERROR - SQLITE3:0x1, 11, database corruption at line 67183 of [1b256d97b5]
What should I check or do you want me to share the files .log here ?
I even tried with the search tab “sqlite” and it doesn’t find anywhere a such file in the \internal\Android\data\com.plexapp.mediaserver.smb\ folder.
It’s crazy, is there a different folder on the nvidia shield pro (internal storage) ? :x
" In many cases, you may also be able to restore a database copy that was backed up via the Scheduled Tasks feature.
The database file will be located at /Plug-in Support/Databases/com.plexapp.plugins.library.db inside the main Plex Media Server data directory. The data directory location can vary by operating system and device; see the article listed below for details. The commands listed below will assume the default server data directory locations.
Note: You can also simply delete the com.plexapp.plugins.library.db database file while the Plex Media Server is not running. Restarting the server will then restore your server to a nearly-fresh install state. (i.e. You will lose your existing libraries and need to recreate them, but you won’t be affecting your content itself.)"
And all is OK now ! Thank you for your help, really, it took me some hours but at least it’s working now
I doubt the tool is bundled with the SHIELD PMS version.
Just install a version of PMS on your Windows machine and use the version of the SQLite app from that installation with the database from the server. Make sure to stop the server while working with the database!
