Server Version#: 1.22.0.4163
Player Version#: All
The TVDB is correct. However, Plex is skipping the third episode (Don’t Get Mad, Get Cooley) so all other episodes in the season are off.
How do you report small bugs like this to Plex?
I found another issue with Coach. Plex has the wrong TheTVDB ID for Coach Season 1 Episode 1. They have 219907. It’s actually 4337902. It was changed at least 5 months ago since that was when I used TheTVDB API calls to pull in the metadata for my collection. The 219907 page doesn’t load (404 error).
The issue appears to be the Plex TheTVDB API calls appear to be outdated. The Coach Season 4 Episode 3 was also updated in TheTVDB months ago. It was missing originally but was added at least 5 months ago.
If Plex are going to have their own scanner/agent than they need to rescan TheTVDB and TheMovieDB periodically for episode changes and update their database. They are living sites and you can’t just pull it in once and forget.
Exactly like this, thanks! I’ve opened an issue for this and we’ll take a look at what’s going on.
Weird. It shows as 76905 for me,
and that is also what the record in TMDB is pointing at.
TheTVDB and TMDB disagree on the order of eps 1 and 2 of season 1.
You are looking at the Coach series TVDB ID. I’m referring to the episode TVDB ID for season 1 episode 1.
Thanks for looking into it though and trying to help. I appreciate it.
The episode TVDB IDs are stored in the Plex tags. This is nice since I’m able to use them to confirm these mistakes against my database. I have 8000+ episodes and Plex only has what looks like a dozen mistakes. I just reported the two errors with Coach (1989) for now. I’ll finish going through the discrepancies after work and replay to this post with all of them.
Here is the SQL statement to retrieve the IDs from the Plex episodes…
SELECT
metadata_items_show.title AS ‘Show Title’,
metadata_items_show.year AS ‘Show Year’,
substr(TVDB.tag, 8, 1000) AS ‘TheTVDB ID’,
metadata_items_season.[index] AS ‘Season’,
metadata_items.[index] AS ‘Episode’,
metadata_items.title AS ‘Episode Title’,
media_parts.file AS ‘Path’
FROM media_items
INNER JOIN media_parts ON media_parts.media_item_id = media_items.id
INNER JOIN metadata_items ON metadata_items.id = media_items.metadata_item_id
INNER JOIN metadata_items AS metadata_items_season ON metadata_items_season.id = metadata_items.parent_id
INNER JOIN metadata_items AS metadata_items_show ON metadata_items_show.id = metadata_items_season.parent_id
INNER JOIN library_sections ON library_sections.id = media_items.library_section_id
LEFT JOIN (SELECT taggings.metadata_item_id, MIN(tags.tag) AS Tag FROM tags LEFT JOIN taggings on tags.id=taggings.tag_id WHERE tags.tag_type=314 AND tags.tag LIKE ‘tvdb://%’ GROUP BY taggings.metadata_item_id) AS TVDB ON TVDB.metadata_item_id = metadata_items.id
WHERE library_sections.name = ‘Shows’
ORDER BY metadata_items_show.title, metadata_items_season.[index], metadata_items.[index]
1 Like
Thanks. The new Plex scanner & agent are amazing and fast.
I have 8244 episodes and only 6 errors. They are all related to changes made to The TVDB site. So the Plex scanner just needs to update itself with TheTVDB and TheMovieDB periodically to pick up these changes.
| Title | Year | File Name | ID | |
|---|---|---|---|---|
| Pilot | 1989 | Coach (1989)/Season 01/s01e01 - Pilot.mp4 | 219907 | Plex is using an old TVDB ID (219907) that has since been deleted/changed (4337902). |
| A Real Guy’s Guy | 1989 | Coach (1989)/Season 04/s04e03 - Don’t Get Mad, Get Cooley.mp4 | 219963 | Plex is missing Coach Season 4 Episode 3 (TVDB ID: 8068544). Moved from season 7. |
| Don’t Get Mad, Get Cooley | 1989 | Coach (1989)/Season 07/s07e24 - Oh, A Pro Job (1).mp4 | 6334097 | Plex is using an episode (6334097) that was missplaced on The TVDB and moved to season 4. |
| Rash Decisions | 2009 | Modern Family (2009)/Season 06/s06e13 - Rash Decisions.mp4 | 5059742 | Plex is using an old TVDB ID (5059742) that has since been deleted/changed (5069879). |
| The Tale of Three Cities | 2009 | Modern Family (2009)/Season 08/s08e01 - A Tale of Three Cities.mp4 | 5661514 | Plex is using an old TVDB ID (5661514) that has since been deleted/changed (5857673). |
| Jesus Gonna Be Here | 2008 | True Blood (2008)/Season 07/s07e01 - Jesus Gonna Be Here.mp4 | 4655677 | Plex is using an old TVDB ID (4655677) that has since been deleted/changed (4730957). |
2 Likes
Thanks. I noticed all three major issues were fixed a couple of days ago. However, there are still three episode matching errors in Plex. You may not have thought that they were errors since the deleted TVDB pages had the same episode names.
| Episode | Plex TheTVDB ID | Actual TheTVDB ID |
|---|---|---|
| Coach (1989)/Season 01/s01e01 - Pilot | 219907 | 4337902 |
| Modern Family (2009)/Season 06/s06e13 - Rash Decisions | 5059742 | 5069879 |
| Modern Family (2009)/Season 08/s08e01 - A Tale of Three Cities | 5661514 | 5857673 |
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
