I get an error in libraries and I get a warning to update

First sorry for my english, for days I have an error where I get a red light and some libraries stop working. I got a recommendation to update the agent faster…etc. The thing is that since then I’m like this. I attach images for a better understanding.





Restarting the server stops it but it is only temporary because it always comes back.
I hope you can help me.
Greetings and thanks!

To prevent that minor damage in your server’s database is coming to haunt you during the upgrade, I’d preventively repair the database. You can use the .bat file to do this relatively painless: PlexDBRepair/Windows at master · ChuckPa/PlexDBRepair · GitHub

Then continue with the library upgrade:

https://support.plex.tv/articles/migrating-a-tv-library-to-use-the-new-plex-tv-series-agent-scanner/

https://support.plex.tv/articles/upgrading-a-movie-library-to-the-use-the-new-plex-movie-agent/

Thank you for your response. I have used .bat from Bdrepair but after that the error still comes up. I try to run Sqlite.exe but I can’t get my database repaired. Any other help please?

If this script cannot repair the database, then the damage has probably grown too large already.

You can try to repair one of the backups, but after such a long time it is likely that they too are damaged https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

The last resort would be a recreation of the library, with the new default agent.
But this will naturally mean an almost complete loss of metadata.

I have tried to create a new library and when this error comes back it also does it for that new folder. Should I delete the whole database and create it from scratch or uninstall Plex completely? Is there any way to keep the users and playback history? Thanks

Did you select a different agent than what was set as default?
If you did not, it may be indeed the database file corrupt beyond repair and the best way forward is the “nuclear option”.

Is your drive C: almost completely filled up?

I am using plex movie and plex series to create the new libraries. I have approximately 17 gigabytes available in C:. Which is the nuclear option?

Then I’m afraid complete data loss it is.

[Optional:] Edit each of your libraries in Plex, go to the “Add Folders” tab and note down which media locations were added to which library.

Shut down Plex server (using the Plex task tray icon),
find the plex data folder
and empty it out completely.
Then start Plex server again.

All this or only databases??

on a windows system I would take the folder %LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases and rename it to Databases.old that should move any database corruption out of the way and allow you to recreate the server.

I would have also removed the Media and Metadata folders to remove the cruft of the old library.

Thank you very much. Is there any way not to lose the users and their history of reproductions?

The only way would be to enable the syncing of their watched status to plex.tv.
https://support.plex.tv/articles/sync-watch-state-and-ratings/
(And keep the server up and unchanged for a few days, to ensure complete synchronization.)
But that in turn would only work if you existing libraries would already use the modern metadata agents – which they do not.
But that is a feature which is under the control of each individual user. Some may disable it over data privacy concerns.

Once you set up your new libraries, you still have to edit each single one of these shared users and give them access to the newly created libraries. There is no way to transfer that over from the existing libraries

So unfortunately this is part of what I meant with

Then I’m afraid complete data loss it is.

1 Like

Thanks for your help. Last question, when I scan a movie that has an article in it, it does not have an article in the title. How can I configure it so that I don’t have to put it manually? For example, in The Batman, it only says Batman and not the “The”.

Where does it show the title without article?
Normally, it should look like this when you edit the movie in Plex:
“Title” has the article,
while “Sort Title” doesn’t.

Find out first if the movie has been matched. If you see “Unmatch” as a menu item, it has been indeed matched.
Then you need to find out where the title in plex has been coming from.
It could have come from an embedded “Title” meta tag in the file itself (only if it’s in mp4 format).
Whether Plex will use that meta tag depends on the status of the checkbox “Use local metatags”. You should keep that off, if you’re not keeping tight control over your embedded metatags.

Or, it could come from Plex’s metadata database. See if you can find your movie on https://watch.plex.tv/
See which title is used on there.
It also helps to look up your movie on IMDb.com, then open the Alternative Titles category and see if there is a version of the title without the article (which sometimes happens in non-English release countries).
Now see which metadata language you have selected for your library. See if IMDb is listing a title without article for that country/language.

sorry I meant to say in short title

I assume you meant “Sort title”. There is no “short title” in Plex.

Import this .reg file, prior to creating the libraries:
full_sort_titles.zip (334 Bytes)

1 Like

In wich route please?

I’m not sure what you mean by “route”.

Just double-click the unzipped .reg file.
Stop Plex server beforehand, using its task tray icon.

P.S.: if you mean “which registry branch”: the reg file inserts itself into the USER branch of the currently logged-in Windows user.
Which is the right thing for a default installation. You only need to care about that if you’re running Plex server as a System service under an own, dedicated user account.

Hi again. I have the same error after delete the folders Media, Metadata and Databases :(.
What else can i do?