Plex: Fix stuck items in the “Recently Added” Dashboards.

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!