Issues when editing library databse

Plex Media Server
,
1

I’ve been having a difficult time editing the “com.plexapp.plugins.library” database file so I could remove items from Recently Added. From time to time I update my movie files when I get better copies but I don’t want them re-added to the Recently Added page so I found form threads that discussed what table within that database file I could edit. The problem is you can only use the “Plex SQLite.exe” to do so and nobody has posted a simple nor compressive guide on how to do that quickly.

Here’s where I am at:

  • I have a copy of my “com.plexapp.plugins.library” file within the same directory as Plex Media Server on Windows.

  • I have to Right-Click run as admin “Plex SQLite.exe” to open the application.

  • I do .open com.plexapp.plugins.library which seems to work because no errors were thrown and a .library file was created with the same name is now in the directory.

This is the command I found and have tried: update metadata_items set added_at=datetime('now','-1 year') where id=225676;

But then it throws the error the database is locked. Any help would be appreciate as I have spent days going through Plex forms and reddit with no luck

2

What you’ve done is correct, but sometimes you can’t edit the database if PMS is doing something. The best option is to exit PMS then try the above.

Alternatively you can run Plex SQLite.exe as a command line tool, just like SQLite.exe.

“Plex SQLite.exe” “com.plexapp.plugins.library” “sqlite command here”

Don’t forget to include paths where needed.

4

Yes. I personally like to open the cmd window in the database folder.

1 Like
5

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