I had same issue with 2 episodes stuck in the “recently added” and won’t budge not matter what.
I was able to solve the issue using @MovieFan.Plex post.
I opened the XML and found out the values for those 2 episodes were somewhere in 2038. As much as I have patience, but waiting 22 years is unacceptable. So I took matters into hands and started digging.
Here are the instructions to repair those items manually.
- Find the location of your Plex server sqlite database. On linux it’s something like that: /Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
- Install an Sqlite management tool and open the database file with it. I used sqlite3 on linux.
- Open the XML info of the corrupted item in Plex Web (Open “Info” for the episode and click “View XML”).
- Locate the property “ratingKey”. This will be the id of the record in the metadata_items table.
- Run the following command in Sqlite (replace [ratingKey] with actual value from last step):
UPDATE metadate_items
SET added_at = created_at
WHERE id=[ratingKey]
Done!
I hope this was helpful.
