How to correct 'Recently Added' not reporting correctly

Plex Media Server Metadata & Adding Files
,
1

Server Version#: 1.32.3.7192

I have a problem with five movies that continue to appear at the front of the ‘Recently Added’ queue, and even though I know what the problem is, I cannot find a way to fix it. I have viewed the database in DB Browser for SQLite and in the metadata_items table, all five movies have an ‘added_at’ entry of 2147483647 (January 2038, the end of UNIX time), so they are always at the front of recently added - new items appear behind them.

I know that I can only edit the database using Plex SQLite and I have stopped the service, opened the database with the correct user rights, and run the command

“update metadata_items set added_at=1655692716 where added_at>=date(‘now’);”

(just a random date in the past) and it does not return an error. I exit out, restart the service, and… it’s still the same. does anyone have any ideas what I may be doing wrong, or pointers of other things to try?

2

I had a similar issue but only with certain TV shows, so I don’t know if it’s the same problem or not

The only way I could fix it was to turn off “prefer local metadata” for the affected library in the advanced settings. There was no embedded metadata so I’m not sure why that worked

Not sure if that’s something you would be willing to live with but it might be worth a try

It fixed the issue for most shows immediately after a metadata refresh but I do remember one show I had to Plex dance to fix it

3

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