Update dates in (Metadata_items) in Plex Sqlite on Windows

Plex Media Server Metadata & Adding Files
1

hello all :slight_smile: especially SQLite gurus!

im trying to edit the database with plex sqlite. im having a little trouble with how to write the cmd. in (metadata_items)

i want it to take the dates from the (originally_available_at) to (added_at) if (originally_available_at) is (not null)

then i want to copy the dates from (added_at) to (originally_available_at) if (originally_available_at) is ( null)

its crazy i know but it makes the dates all correct. :slight_smile:

“C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe” “C:\Users\user\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db” " UPDATE metadata_items SET originally_available_at = added_at WHERE library_section_id = 24;"

2

got it!

“C:\Program Files (x86)\Plex\Plex Media Server\Plex SQLite.exe” “C:\Users\user\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db” " UPDATE metadata_items SET added_at = originally_available_at WHERE library_section_id = 24 AND originally_available_at NOT NULL;"

1 Like
3

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