I’ve had an issue with some shows and movies not demoting themselves “down” in the recently added dashboards in my Plex apps. After doing a little research I found that this is because of a metadata issue where the “added” date is in the future.
To determine this I downloaded the sqlite3 tools for windows and went to work checking my database by running this command (NOTE: Shutdown your plex server before modifying the database. It is also not a bad idea to take a backup of the DB).
sqlite3 com.plexapp.plugins.library.db "select * from metadata_items where added_at >= date('now')"
We get a return of all the media that is “stuck” So let’s fix that!
sqlite3 com.plexapp.plugins.library.db "select * from metadata_items where added_at >= date('now'); UPDATE metadata_items SET added_at = created_at WHERE added_at >= date('now');"
Restart your plex instance and you’re good to go!
Like this:
Like Loading...
Get-SysadminBlog 
I’ve had an issue with some shows and movies not demoting themselves “down” in the recently added dashboards in my Plex apps. After doing a little research I found that this is because of a metadata issue where the “added” date is in the future.
To determine this I downloaded the sqlite3 tools for windows and went to work checking my database by running this command (NOTE: Shutdown your plex server before modifying the database. It is also not a bad idea to take a backup of the DB).
sqlite3 com.plexapp.plugins.library.db "select * from metadata_items where added_at >= date('now')"We get a return of all the media that is “stuck” So let’s fix that!
sqlite3 com.plexapp.plugins.library.db "select * from metadata_items where added_at >= date('now'); UPDATE metadata_items SET added_at = created_at WHERE added_at >= date('now');"Restart your plex instance and you’re good to go!
Share this:
Like this: