Today, I noticed, that both House of Cards (2013), formerly House of Cards (US), and The Americans (2013) don’t seem to have any episodes anymore.
I manually looked them up on thetvdb and all the episodes are listed there, but Nzbdrone thinks, both shows consist of 0 episodes. I already manually updated the shows and also deleted and re-added them. Can anyone confirm this problem?
v2 uses Trakt for the series/episode data, but the data looks fine there and in drone as well.
I just added The American’s and everything is showing up, refreshed House of Cards and its all there too.
This is what I get, when I refresh House of Cards:
TaskExtensions Task Error: constraint failed
column TvDbEpisodeId is not unique 2:13 AM
RefreshEpisodeService Starting episode info refresh for: [262980][House of Cards (2013)] 2:13 AM
RefreshSeriesService Updating Info for House of Cards (2013)
Same thing goes for The Americans:
TaskExtensions Task Error: constraint failed
column TvDbEpisodeId is not unique 2:15 AM
RefreshEpisodeService Starting episode info refresh for: [261690][The Americans (2013)] 2:15 AM
RefreshSeriesService Updating Info for The Americans (2013)
I could understand, if the problems were only in House of Cards, it was recently renamed from House of Cards (US) to House of Cards (2013) and the thetvdb listing is weird.
House of Cards English 79861
House of Cards (2013)
House of Cards (2013) English 262980
House English 73255
If the TvDbEpsidoeId is not unique, as the error states, shouldn’t everybody be affected? What can I do now to fix it?
House of Cards (2013) English 262980 <- That’s the one I am using and I have no problems with it. I even removed a few episodes and re-downloaded them just for testing and all went well.
It might some how be an duplicated with another series you have that another doesn’t. Would you be able to send me your DB from C:\ProgramData\zbDrone ? You can PM me a link - I’d like to use it for tracking this down.
Thank you guys.
What I meant by weird concerning the tvdb listing is this:
http://imageshack.us/photo/my-images/855/9n2f.png/
The title is there twice for a single link to a single show, as if they just recently consolidated a duplicate entry for the show into the existing one, or if they put together House of Cards (US) with House of Cards (2013), but then still renamed the other one (2013) as well. It is strange and I don’t exactly know, what it means, but it stuck out to me as looking weird, when all the other shows just have one entry with one title.
Also, I’m PMing you with the link.
Thats a TVDB alias, which we don’t ever use, likely its because the original name was House of Cards (US) with an alias of House of Card (2013), they just didn’t change/remove the alias.
Okay, found the source of the issue - this exact scenario is unique to your DB, but others could have similar issues. When you deleted the show(s) drone was unable to properly clean the episodes, for one reason or another, which means when the show is re-added it can’t add the episodes because they already exist, but point to a non-existent series. This is an issue for a number of reasons, but we have a plan to fix it.
I’ll be tackling this ASAP and will advise once its resolved on the develop branch.
This should be fixed in the latest develop build. The process that runs to clean this up will run once a day to keep things clean.
Thanks for providing your database it proved to be a great help in resolving this.
Thanks, so, what should I do now to get the shows working again? I moved the episodes to another location and deleted the shows from ND and waited for 2 days, added the shows back and they still don’t show any episodes.
The changes are only available on the develop build right now, you can either switch to that or wait for the release to master.
@MirandaU This fix was just released to everyone, build 2.0.0.605 - please advise if you still have issues.
Nope, everything is working now, thank you for the quick solution.