Cannot upgrade past PlexMediaServer-1.30.0.6486

Plex Media Server Desktops & Laptops
1

Server Version#:PlexMediaServer-1.30.0.6486

This is the last version I can successfully use. Any upgrade beyond this installs and then immediately crashes after upgrading the library.

These are the final errors it throw after update:
Plex Media Server.1.log (14.5 KB)

Jun 03, 2023 16:24:33.350 [1816] ERROR - SQLITE3:0x7f681838, 1, no such table: metadata_agent_providers in “update metadata_agent_providers set online = 0”

Jun 03, 2023 16:24:33.350 [1816] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: metadata_agent_providers for SQL: update metadata_agent_providers set online = 0 (class soci::soci_error)

2

Try repairing your database before attempting the next update.
Here is a batch file which can do this for you: GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

On Windows 10 it is recommended to switch to the 64bit version.
Do it manually:

  • Stop/quit/end Plex Server with the tray icon
  • deinstall Plex Server with the regular ‘Apps’ control panel of Windows
    (do not use 3rd party ‘Uninstaller’ software like Revo etc.
    do not use “Registry Cleaner/optimizer” software like CCleaner et al)
  • for safety, reboot Windows
  • download the installation exe of the newer version and install it
3

I will switch it to the 64 bit edition. I downloaded the batch file for windows and cannot get it to run properly. Where does the file need to be placed for Windows? It does not specify on the github page.

4

It doesn’t really matter. Easiest is to place it directly in the same folder as the database file.

6

Same issue - see attached.

I previously have run the manual db repair. This time i ran the auto script. Uninstalled PMS, rebooted, installed x64 latest version, rebooted again. Logs attached.
Plex Media Server.log (9.6 KB)

7

That doesn’t look good.
Are you running the server as a system service?
How much free space is left on drive C: ?

One last attempt to confirm that your database is not salvageable:
Shut down the server
Rename the folder C:\Users\plopd\AppData\Local\Plex Media Server to e.g.
C:\Users\plopd\AppData\Local\Plex Media Server_old

Start the server again.
It should now behave like it never had been running before. Can you successfully create libraries and such?

10

I don’t believe I am running it as a service. C: has 20gb available I renamed the appdata folder, launched it and created a new library. Manually updated and everything works fine including the new library I just created. Uninstalled x86 version after that and installed x64. Still works perfectly.

I can assume that my DB cannot be upgraded beyond the current version?

11

Judging by the error messages, it is beyond repairability, I’m afraid.

12

Ok bummer. I was afraid of that. Thank you for looking into with me. I appreciate it.

13

Then you might as well delete the old, renamed Plex data folder. To free up space on C:

It is very important that there is always a few GB free on C: Otherwise your Plex DB can get damaged again.
If your media collection is very big and you want to use all the Plex features regarding media analysis, I recommend adding a dedicated SSD just for the Plex data folder.

14

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