Unable to repair database

Plex Media Server Desktops & Laptops
1

Otto

I have read through the various posts about repairing a corrupt database as well as looking at the instructions here: “P:\Plex Media Server\Plex” -sqlite com.plexapp.plugins.library.db “PRAGMA integrity_check”

I am running Windows Server with Plex 1.23.4.4712

I am unable to use the -sqlite or --sqlite on the command line. Since Plex no longer has SQLite3 installed and seems to be using it in a different manner, how can I run this repair of my database?

I am getting the following error: Plex Media Server unable to open its media database

Thanks so much.

Larry

3

Please read again: Repair a Corrupted Database | Plex Support

The command line is
"C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe" com.plexapp.plugins.library.db "PRAGMA integrity_check"

4

Thanks I had tried that, I realized where the issue is. My database/plex install is on a separate drive and a slightly different directory. Once I accounted for that it is now running. Thanks for your help and support as always.

Larry

5

Otto

I followed the steps to repair the database and am still getting the same error. What are my next steps to get this working again?

Thanks

Larry

6

Try to repair one of the backup copies instead Restore a Database Backed Up via 'Scheduled Tasks' | Plex Support

If these fail as well, you will unfortunately have to start over and throw all Plex data over board.

7

I got past that error, now I am getting No content available, check your network connection and verify that any media servers are online.

My server is online and I have internet access.

8

Which error?

Where do you see the new error message?
In a Plex client or on the command line?

9

“Plex Media Server unable to open its media database”

After sitting for a minute eventually it showed the media image on the Home screen but then all libraries went grey with the Yellow ! meaning they are not available.

10

Otto

If the database restore doesn’t work then what are my next steps to get this working again?

Thanks.

Larry

11

Otto

I have tried everything I can think of to get this database working, it just appears to be beyond repair. How can i get a new database to get created? I tried deleting the blob.db and .db files from the repair steps and restarting Plex. That appeared to create an empty database but I was unable to even add a library. What could be going on?

Thanks

Larry

12

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.