Plex media server not showing on Authorized Devices and not showing in Plex

Plex Media Server
1

Server Version#:1.31.1.6716
Player Version#:1.64.2.3546
Windows 10

I have tried everything that I could find on the forum already and can get nothing to work.
It started as plex media server randomly disappearing. I am not having that problem anymore. Now the server will not show up in plex at all. Please help. Hopefully I have attached the correct log files as I had to do it manually as the option is not available in my account.

2

The Plex database is corrupted.

From Plex Media Server.log:
Feb 17, 2023 14:07:40.376 [12700] ERROR - SQLITE3:0x7ff68f5292c0, 11, database corruption at line 83189 of [1b256d97b5]

Download and run the PlexDBRepair utility.

  1. Download
  2. Unzip
  3. Stop Plex Media Server
  4. Run from command line
    c:\DBRepair-WinDev.bat

Sample Output:

c:\Temp>DBRepair-WinDev.bat
13:50:03.44 --  ====== Session begins. (Fri 02/17/2023) ======
13:50:03.68 --  Exporting Main DB
13:50:18.92 --  Exporting Blobs DB
13:50:18.98 --  Exporting Complete.
13:50:18.98 --  Creating Main DB
13:50:22.34 --  Verifying Main DB
13:50:23.42 --  Main DB verification check is: ok
13:50:23.42 --  Main DB verification successful.
13:50:23.43 --  Creating Blobs DB
13:50:23.49 --  Verifying Blobs DB
13:50:23.63 --  Blobs DB verification check is: ok
13:50:23.64 --  Blobs DB verification successful.
13:50:23.64 --  Import and verification complete.
13:50:23.65 --  Reindexing Main DB
13:50:24.76 --  Reindexing Blobs DB
13:50:24.81 --  Reindexing complete.
13:50:24.81 --  Moving current DBs to DBTMP and making new databases active
        1 file(s) moved.
        1 file(s) moved.
        1 file(s) moved.
        1 file(s) moved.
13:50:24.82 --  Database repair/rebuild/reindex completed.
13:50:24.82 --  ====== Session completed. ======
3

It says the “The system cannot find the path specified”

4

Are you running it as user “Ryzen 3600”?

The Plex Data Folder, where the application stores the database, etc is C:\Users\Ryzen 3600\AppData\Local\Plex Media Server.

It is looking for the databases in C:\Users\Ryzen 3600\AppData\Local\Plex Media Server\Plug-in Support\Databases.

5

Yes as far as I know. It fully says this:
C:>DBRepair-WinDev.bat
15:14:12.11 – ====== Session begins. (Fri 02/17/2023) ======
15:14:12.41 – Exporting Main DB
The system cannot find the path specified.

6

Think I found it.

Plex Media Server is installed in C:\Program Files\Plex\PMS\.

The Utility is looking for it in C:\Program Files\Plex\Plex Media Server\.

Can you edit the bat file and change one line? Use any text editor, or right click on it and choose edit.

Current:
set "PlexSQL=%PROGRAMFILES%\Plex\Plex Media Server\Plex SQLite"
Change to:
set "PlexSQL=%PROGRAMFILES%\Plex\PMS\Plex SQLite"

That should let the utility run.

7

when the repair fails it is in the path that you listed and this is the directory listiing of what is there:
C:\Users\Ryzen 3600\AppData\Local\Plex Media Server\Plug-in Support\Databases>dir
Volume in drive C has no label.
Volume Serial Number is 9C32-0E4A

Directory of C:\Users\Ryzen 3600\AppData\Local\Plex Media Server\Plug-in Support\Databases

02/17/2023 02:53 PM .
02/17/2023 02:53 PM …
02/17/2023 01:26 AM 525,281,280 com.plexapp.plugins.library.blobs.db
01/02/2023 02:01 AM 517,043,200 com.plexapp.plugins.library.blobs.db-2023-01-02
01/05/2023 02:01 AM 518,515,712 com.plexapp.plugins.library.blobs.db-2023-01-05
01/11/2023 04:04 AM 521,380,864 com.plexapp.plugins.library.blobs.db-2023-01-11
01/20/2023 02:04 AM 524,605,440 com.plexapp.plugins.library.blobs.db-2023-01-20
02/17/2023 02:51 PM 214,713,344 com.plexapp.plugins.library.db
07/18/2022 01:00 AM 144,647,168 com.plexapp.plugins.library.db-2022-07-18
07/21/2022 01:00 AM 144,647,168 com.plexapp.plugins.library.db-2022-07-21
07/24/2022 01:00 AM 143,124,480 com.plexapp.plugins.library.db-2022-07-24
07/27/2022 01:00 AM 143,386,624 com.plexapp.plugins.library.db-2022-07-27
02/17/2023 03:09 PM dbtmp
02/17/2023 03:14 PM 404 PlexDBRepair.log
11 File(s) 3,397,345,684 bytes
3 Dir(s) 218,753,081,344 bytes free

8

This version has the edited line mentioned in above post. It should run OK.

DBRepair-WinDev-1.zip (1.6 KB)

9

Running… hopefully that will fix it. Thank you so much for your help… I am working away from home and really miss having access to plex while I am away for months at a time.

10

I edited the first one. It is done. Then I just start the media server?

11

Yes. Start Plex Media Server. It should start right up.

12

You are a life saver!!! I have spent so many hours trying to search the forums and online. It started right up and I was able to claim the server, which I had deleted trying to fix it…

13

Sweet! Glad it is working. Reply back if you run into any other issues w/ PMS.

14

Is it safe for me to leave the log files in the message above or should I delete them (if that is possible)

15

Noticed you already removed them.

For future reference, log files have the following:

  • server owner’s Plex username and e-mail address
  • Plex username of anyone that logs into the server (friends, etc you’ve granted access)
  • public IP address of the server
  • path to the Plex Data Folder, which, on Windows, has the user name used to run Plex Media Server (c:\users\user_name\appdata.…).
16

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