Update added_at field in metadata_items table

Plex Media Server Metadata & Adding Files
1

Server Version#: 1.41.0.8992
Player Version#: N/A

I am trying to update the added_at field in the metadata_items table for a single movie. I am using DB Visualizer to run the SQL command on a saved copy of my PlexMedia database.

Here is my command and error. The database is not missing as I can run many select queries on it.

image

I was wondering what I am doing wrong.

2

You need to use sqlite which comes with plex itself.

3

Thanks for your quick response. So the fact that DB Visualizer provides a SQLite driver is not adequate then?

4

From what I remember plex uses a custom schema and the version of sqlite that is bundled with plex is required to save that specific data.

5

Good to know and thanks again.