You are supposed to download a command line tool for SQLite databases. And then perform a set of steps on the command line.
not really sure what I am doing with this? I downloaded what I think was correct one from that site. I extracted it. put the .exe into the folder I creates with copies of the databases-instructions said to move it to where databases located? I actually created a folder within that folder that has a single db file with the date removed. I ran the sqlite and then type exactly as seen on that page I referenced. nothing happened?
Don’t download SQLite itself, but the sqlite-tools
Don’t run the SQLite.exe directly
Instead, open a command line window cmd.exe
Navigate to the folder with the database and the SQLite executable and paste the commands from the article into there, line by line
yes, sqlite tools is what I downloaded. I did run the sqlite.exe directly and it opened a cmd window so I thought that was where I was to put the commands-as shown in the photo I attched to reply. So I open cmd window, go to folder, and paste the commands WHERE? If pasting into cmd window don’t understand why navigate to folder? That is where I was confused. or if pasting into the folder, how? Can’t just put text in folder. in a text document?
No, that is not how a command line interface works.
if you start cmd.exe, you get a window and a command prompt.
The command prompt informs you that you are currently in your personal folder, which is by default under C:\Users\[username]
You now have to change that to the drive letter and folder where you have unzipped the sqlite tools and where the .db file is situated.
cd "%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases" + Enter
will take you into the default location of the Plex database, in case you have extracted the sqlite tools directly into there.
I did that. put sqlite3.exe in database folder. opened a cmd. and typed in the path to database folder-cd %LOCALAPPDATAPATH%…typed first command under the check for corruption section and got reply “copied”. when typed 2nd command got “sqlite3 not recognized as internal or external command, operable program or batch file”
The way they made the zip file, it is possible that the sqlite3.exe file was not unzipped directly into the same folder, but was put into another sub-folder named sqlite-tools-win32-x86-3310100
Take them out of there, so they are in the same folder as the .db files
that is where I got sqlite3.exe from. I only took the sqlite3.exe file, not the other 2 that were in the folder
that nesting had me screwed up and put in the nested one. I now have it in the right folder. on first command it asked overwrite com.plexapp.plugins.library.db.original? (Yes/No?All)
That’s normal, because you have already executed this step before, so that you already have a file by that name in the folder. It doesn’t really matter in this case what you answer here. It is just a safety backup of the unrepaired database.
Also expected, because you already performed this step before.
Yes, this usually means that no errors could be found.
It can’t hurt to continue with the procedure though.
so is that just going to check or repair the file named ```
com.plexapp.plugins.library.db.original ? emphasis on original
should I delete that file and take one of my backup files and rename it this name then run repair?
No, it is going to repair and replace com.plexapp.plugins.library.db
com.plexapp.plugins.library.db.original will remain for the case that the repair attempt is unsuccessful and destroys more than it repairs.
That way you can them manually delete the “repaired” com.plexapp.plugins.library.db and rename the com.plexapp.plugins.library.db.original back.
Repairing one of the backups instead of the most recent DB is a viable strategy.
tried using the earliest backup I had. renamed it to just db at end-no date. removed the .orginal and dump files created before. repaired it. removed the shm and wal files. I also removed that nested plex media server and removed that registry key. started up server- crashed wouldn’t start. added key back into registry and when started it created that nested plex media server again but started-no library. I guess it is unrepairable? and since it won’t run without creating that nested plex media server folder, should I just do uninstall and re-install? that nesting I would think has potential for problems in future
Afraid so, unless you haven’t tried to reset the access permissions yet, as discussed above.
Just wanted to thank you Otto, for all your help. I was unable to get it working. Even after uninstall and reinstall it still did not work. So I had to uninstall, delete registry keys, deleted the Plex Media Server folder in app data/local. Then reinstall. I created new libraries and back in business. Surprised though no option in the uninstall for removing everything?
oh, I should add that after I got it running but before adding libraries, I tried putting one of my old db files that I had run a repair on and had saved back into the correct folder. When started plex it crashed again so something in the file was bad and not repairable.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
