12 Invalid TheTVDB IDs

Plex Media Server Metadata & Adding Files
1

I used TheTVDB API to validate my collection and compared it to the Plex database. There were 12 episodes in Plex that had the wrong TheTVDB ID associated with them. Not bad considering the size of my collection. Can somebody fix the Plex central database?

Thanks

Episode Plex
TheTVDB ID		 Actual
TheTVDB ID
Cosmos (2014)/Season 01/s01e09 - The Lost Worlds of Planet Earth 4816591 4816592 Verified
Mike & Molly (2010)/Season 04/s04e20 - Sex, Lies and Helicopters 4843344 4843345 Verified
Mom (2013)/Season 01/s01e11 - Cotton Candy and Blended Fish 4712276 4716254 Verified
New Girl (2011)/Season 03/s03e11 - Clavado En Un Bar 4721158 4721159 Verified
Parks and Recreation (2009)/Season 06/s06e05 - Gin It Up! 4664171 4664172 Verified
The Big Bang Theory (2007)/Season 08/s08e07 - The Misinterpretation Agitation 5002091 5021431 Verified
The Goldbergs (2013)/Season 01/s01e04 - Why’re You Hitting Yourself 4672468 4676343 Verified
The Goldbergs (2013)/Season 04/s04e04 - Crazy Calls 5719844 5720976 Verified
The King of Queens (1998)/Season 08/s08e11 - Baker’s Doesn’t 303173 303174 Verified
The King of Queens (1998)/Season 08/s08e12 - Fresh Brood 303174 303175 Verified
The King of Queens (1998)/Season 08/s08e13 - Gambling N’Diction 303175 305430 Verified
Two and a Half Men (2003)/Season 11/s11e08 - Mr. Walden, He Die. I Clean Room 4705873 4716253 Verified
2

Could they be coming from external ids on the episodes within tmdb ?

I’m away from my PC atm but can check later if needed.

3

Yes, appears so. I’m fixing what I can.

4

I ran into issues unsetting the tvdb ids on the New Girl episodes and stopped there. Maybe you can have better luck than me.

5

Thanks. I forgot that you guys use TMDB to look up the ID for the TVDB. I logged in to TMDB and fixed the Two and a Half Men episode. I’ll take care of the rest.

6

Out of curiosity, how did you gather both lists of episode ids so you could compare ?

7

I wrote code that retrieves all season and episode data from TheTVDB using their API. I use that tool to keep my collection (personal database) current with updates. I also built a tool that pulls in all the data from the Plex SQLite DB. The tool matches the two datasets on the TVDB ID and then compares file path, sizes, etc. for any inaccuracies. It’s all automated. I did this a few years ago when I noticed some shows were out of order in Plex.

1 Like
8

It also catches the handful of movies that are matched incorrectly by the Plex Media Scanner. The Plex scanner is awesome and much quicker now but still incorrectly matches a small percentage of movies.

9

Thanks. This is most likely for another topic but I’m coming at it from a different angle.

This Plex Episodes changing from played to unplayed due to online metadata source change is a real annoyance for me and happens at least a couple of times a year. I’d love to have some automated way to check for it rather than just noticing the watched status for an episode (or group of episodes) has changed. The export compare you done got me thinking …

Anyhow, I’ll not go on as this topic looks to be sorted, or at least on the way to being sorted :slight_smile:

10

Thanks. Same here. I fixed all the other ones without any issues. The New Girl one is not saving. It shows in the history that you tried to save the wrong number to both episodes (e.g. 47211581 instead of 4721158). It also doesn’t show that you first cleared out one episode id before swapping them (like it does on the other ones that were fixed). Also, you fixed Cosmos correctly, but both Mike & Molly and Mom had either the preceding or next episodes’s TVDB ID blank. I fixed them.

11

I also tried to edit them but it failed. Unfortunately, this has come up before on tmdb, see TVDB IDs will not save for various S05 episodes! - Discuss Regular Show — The Movie Database (TMDB) as an example which I was involved in.

The solution at the time and I quote from that thread …

The only solution we moderators came up so far is “brutal” replace & deletion. So far it works - but we loose all episode ratings.

So, best to leave those episodes alone and let the problem report that @drzoidberg33 filed get processed by the moderators in their own time.

12

Sounds good. I just noticed that it was you in the change log on TMDB and not drzoidberg33. I don’t even see his attempt in the log. I guess Plex employees have a back door in. I’ll definitely just let it play out and move on. Thanks for helping out and sorry for the hassle.

13

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