Server Version#: 1.41.0.8930 I posted on the /plex reddit but I think this may be a better place to go to for support. I’m trying to edit the database to update the “added_at” dates to what I have for “originally_available_at”. I’ve looked at a few guides and through some trial and error learned t…

Judging by your screenshot I think you are trying to do this with one command. Its multiple commands, so basically something like this … [plex]-[dokuro]:~/Downloads$ "/usr/lib/plexmediaserver/Plex Media Server" --sqlite /home/plex/Downloads/com.plexapp.plugins.library.db SQLite version 3.39.4 2022…

When I use --sqlite I get a message like below: [Screenshot 2024-09-03 at 10.39.41 AM] What am I doing wrong?

I’m in root. Am I supposed to be in the plex container? Does plex need to be running? I see you have [plex]-[dokuro]:~/Downloads$ so that is confusing me. Also, you mentioned you copied the db to ~/Downloads beforehand. What does that command look like?

Mmmm, strange. What does "/usr/lib/plexmediaserver/Plex Media Server" --sqlite return (update for your path information). If the same error does "/usr/lib/plexmediaserver/Plex SQLite" open a sql prompt ? There is nothing complex here [plex]-[dokuro]:~/Downloads$ This is user (plex), hostname (dok…

I’m making some progress. I ended up copying the database to another folder as well as the Plex SQLite. Once I did that I just changed the directories in my command and it at least got me into SQLite. [Screenshot 2024-09-03 at 11.20.13 AM] Now I get an error that I can’t open the database file. A…

Looks like an access problem on the file. What permissions does it have.

Can you tell me what the ...> means? [Screenshot 2024-09-03 at 11.44.48 AM]

...> is SQLite’s way of showing that you’re continuing the query from the previous line(s). Since your query is missing a semicolon at the end, SQLite thinks you want to continue your query on a new line, so is waiting for you to enter more data. Typing ; and pressing enter should execute the query. …

Thanks. That makes sense now. Thought it meant it was loading and got excited. Seems like I am stuck here. I rebooted the server and still no luck.

Thanks @DTR I was away from my PC :slight_smile: Yeap @dcuellar44 your missing the ending ; from your sql statement. Once its completed then .quit to exit (remember the dot in front of quit).

Help with editing Database

Plex Media Server

dcuellar44 September 3, 2024, 3:25pm 8

Topic		Replies	Views
Update dates in (Metadata_items) in Plex Sqlite on Windows Metadata & Adding Files server-windows	1	118	February 19, 2022
Trying to adjust the date added metadata field in the Database Plex Media Server server-linux	4	174	September 8, 2024
Issues when editing library databse Plex Media Server server-windows , library-management	2	137	October 27, 2021
Can no longer update library database with sqlite3 Metadata & Adding Files server-linux , library-management	149	13208	April 21, 2022
Using Plex SQLite binary to update added_at field Plex Media Server server-linux	15	388	August 22, 2025

Help with editing Database

Related topics