Server Version#:1.24.4.5081
Player Version#:1:24.4.5081
Hi there:
I’m hoping someone can help me. I’ve got a corrupted database on Windows 10 and have been unable to update since version 1.24.4.5081. If I update none of my files will play including on my computer so I have to do a roll back. I’m not worried about my database, but I do want to transfer my user data and viewing information.
I’ve tried repairing my database with no luck and have followed the directions in the article - Move Viewstate/Ratings from One Install to Another but get an error message. ‘sqlite3’ is not recognized as an internal or external command, operable program or batch file.
I don’t know anything about sqlite3. If anyone has any advice, I would appreciate it.
Check out the instructions from repairing the corrupt database; you’ll need to use the bundled version of Plex SQLite for this job.
Though don’t get your hopes too high… if the database is toast your chances of pulling anything out aren’t necessarily good.
How do you run the Plex SQlite bundled version? I can’t find it anywhere. I’ve tried the windows command prompts in that article before with no luck but don’t know anything about using or finding Plex SQlite.
The file is called Plex SQLite.exe and it’s stored alongside the Plex Media Server executable in your system’s app folder (usually C:\Program Files\Plex\Plex Media Server\, possibly C:\Program Files (x86)\…)
You ran the file first, which you don’t need to do. You just need to open a regular command prompt window. Enter the command there.
Please read the support article carefully. If you randomly start typing command, you risk further damaging your database.
If you are not familiar with SQLite, it may be better to check if you have database backups and just replace the current com.plexapp.plugins.library.db file with a backup.
That is correct. There is no output when running the command. As long as you don’t get an error, it ran and finished. No is no need to do anything else. Just run PMS and see if it’s fixed. If not, then the recovery did not result in a valid file. You will need to use a database backup if you have one or start over.
Thank you. I guess my next question is as I said at the top is I’m less worried about my database, than keeping my user data and viewing information. Does this process do that? Or is there something else I need to do.
Thank you again for your help. I really appreciate it.
The played history is stored in this database. If the repair works, then whatever play history will get saved too. If this doesn’t work and you have a good (not corrupted) backup database, restoring that database will bring back your play history up to the date of that backup.
Unfortunately that didn’t fix my backup so my next question is. Is there a way to create a new uncorrupted database in a different area so that I can then delete the old database and replace it with the new one?
If you’re going to nuke your setup in order to start over, simply delete the content of your Plex Media Server’s data directory (+ some of the registry information). When you start your server it should offer you to setup a new server / libraries / …
This doc also might be of help if you are starting over …
It won’t restore your watch history but will restore your view state history. I’m unaware of anyway keep dashboard watch history but this certainly works for view state as I’ve used the steps myself.
Yes I have read both the articles. I didn’t take the time to look at the article names as I was running out the door and was just saying thanks for the responses.
Thanks again
Might be another dumb question but if I’m attempting to restore from a back up, does the library.db file and library.blobs file have to be the same date? Only reason I’m asking is that in my folder I don’t have two that match dates.
