Recently Added changed to File Create/Modified date

Plex Media Server Desktops & Laptops
5

I was able to figure it out for any of those who are interested in updating your plex database for Date Added based on the file’s creation date, not when it was loaded into your plex DB using a Windows (7-10) based system;

  1. Download SQLITE3.exe (http://www.sqlite.org/download.html)
  2. Place the .exe in your Plex Server database location; Typically: “C:\Users\NAME\AppData\Local\Plex Media Server\Plug-in Support\Databases”
  3. Run SQLITE3 as Admin
  4. type: “.open com.plexapp.plugins.library.db”
  5. type: “update metadata_items set added_at=(select media_items.updated_at from media_items where media_items.metadata_item_id=metadata_items.id);”
  6. type: “.quit”
  7. Close out of Plex Media Server (tray icon and all)
  8. Relaunch Plex Media Server
  9. Enjoy re-sorted titles
5 Likes