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!

Cameron Joyce is a full stack engineer, having experience with all aspects of on premise datacenter, virtualization, disaster recovery, cybersecurity, and Cloud based *aaS technologies. Cameron Joyce has spent more than a decade working in managed services, and brings that experience to his role as a Sr Presales Engineer. Cameron Joyce now shares solutions to problems and new technology overviews through his blog and youtube channels.

%d bloggers like this: