My tv library has 270 show, many of which were messed up by a partial hard drive failure months ago. I’ve been fixing things ever since, and I suspect there are fewer than a dozen shows with problems.
As I replace missing episodes, I notice that it doesn’t always recognize that I’ve replaced these. Undoubtedly Handbrake has created a near-replica that doesn’t match a hash… or even in some cases, thetvdb.com has me renaming episodes slightly differently than months ago (the first episode of Preacher seems to have changed from “The Pilot” to just “Pilot”, for instance).
It would help immensely if I could “empty the trash” on that show so that it stops displaying the trashcan icon and I could focus on the rest. If I empty the trash for the entire library, I’ll never be able to tell what is still missing. However, I don’t think I can wait for a new feature to be implemented, so…
I found the correct database row in media_parts and deleted that as a test. However, Plex still says there are two copies of it, and when I do a “get info” on the episode, now it shows two filepath boxes, but one is empty. I then found the correct row (media_item_count) in metadata_items… and updated that to 1 (original value 2). This also failed to have the desired results.
Is there a way to accomplish this manually?
