Jump to content

Missing Seasons In Some TV Shows


richwphillips@yahoo.com

Recommended Posts

ewer0012

Can you show us the complete folder contents? Thanks.

For the Season?

 

I'm in the process of removing all Metadata and redownloading it to see if there was something weird there.

post-82314-0-96814200-1583377087_thumb.png

Edited by ewer0012
Link to comment
Share on other sites

Sorry, somehow ended up posting before I attached the other ones.

 

Hmm, that's strange. Looks good from here. Can you try refreshing the metadata on that series and see if that helps?

Link to comment
Share on other sites

ewer0012

Yeah, it only started happening after one of the recent patches that came out. Super strange, since it's not with all of the shows I have, just a smattering. It seems to be growing in scale, though. A week or so ago it was only reported to me that one series was doing it. Now it's at least a dozen.

 

I deleted all metadata from the folders last night and then kicked off a refresh before going to bed. Still missing seasons for several shows.

 

I've had things set up to be auto-named with new folder structures created as new shows/seasons come out (through Sonarr) and everything has worked well for years... Pretty much flawlessly. 

Link to comment
Share on other sites

chstoll

I managed to fix the issue in my case. As I speculated, there where obviously some broken Database-Entrys. Here is what I did (SQL-Knowledge is needed):

 

For example, Ray Donovan Season 7 would not be regonized by emby (tried everything, DB-Scan, delete complete series and added it again and so on)

 

So I took the DB Browser for SQL-Lite, and opened the library-db-file.

 

1. Although Season 7 wouldn't be recognized, there where a few entrys referencing the path in the table MediaItems (select * from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%';)

2 I tried to delete those entrys, but first all entrys in other tables with forein key-constraints (tables AncestorsID2, Chapters3, ItemLinks, ItemPeople, MediaStreams2) had to be deleted (like "delete from ItemPeople where ItemPeople.ItemId in (select ItemID from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%')")

3. Then I finally could delete the entrys in MediaItems (delete from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%';)

4. Restarted Emby, did a library scan and BAZINGA, Season 7 appeared correctly in Emby.

 

And I also managed to fix the annoying "auto-organize-plugin showing the same season multiple times" issue just by doing the similar thing as above, only with the query "select ItemId from MediaItems where parentid is NULL and type = 6" and then "delete from MediaItems where parentid is NULL and type = 6"

 

Maybe the Emby-Team can implement a better cleanup/repair-task, where all paths are verified and broken db-entrys are fixed automatically. The question for sure is, why those entrys appear in the first place.

Edited by chstoll
  • Like 1
Link to comment
Share on other sites

Happy2Play

They majority of these issues usually come back to a database issue.  So it is a matter of figuring out why as it does not affect everyone.

Link to comment
Share on other sites

I managed to fix the issue in my case. As I speculated, there where obviously some broken Database-Entrys. Here is what I did (SQL-Knowledge is needed):

 

For example, Ray Donovan Season 7 would not be regonized by emby (tried everything, DB-Scan, delete complete series and added it again and so on)

 

So I took the DB Browser for SQL-Lite, and opened the library-db-file.

 

1. Although Season 7 wouldn't be recognized, there where a few entrys referencing the path in the table MediaItems (select * from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%';)

2 I tried to delete those entrys, but first all entrys in other tables with forein key-constraints (tables AncestorsID2, Chapters3, ItemLinks, ItemPeople, MediaStreams2) had to be deleted (like "delete from ItemPeople where ItemPeople.ItemId in (select ItemID from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%')")

3. Then I finally could delete the entrys in MediaItems (delete from MediaItems WHERE Path like '%Ray Donovan (2013)\Season 7%';)

4. Restarted Emby, did a library scan and BAZINGA, Season 7 appeared correctly in Emby.

 

And I also managed to fix the annoying "auto-organize-plugin showing the same season multiple times" issue just by doing the similar thing as above, only with the query "select ItemId from MediaItems where parentid is NULL and type = 6" and then "delete from MediaItems where parentid is NULL and type = 6"

 

Maybe the Emby-Team can implement a better cleanup/repair-task, where all paths are verified and broken db-entrys are fixed automatically. The question for sure is, why those entrys appear in the first place.

 

Hi, you don't by any chance have a copy of the database from before you did that, do you?

Link to comment
Share on other sites

chstoll

Hi, you don't by any chance have a copy of the database from before you did that, do you?

 

I did a backup from the database before fiddeling around, of course B) 

I send you a link per pm with the db before and after the cleanup having successfully added Season 7.

Link to comment
Share on other sites

I did a backup from the database before fiddeling around, of course B)

I send you a link per pm with the db before and after the cleanup having successfully added Season 7.

 

Thanks !

 

Curious, when this happened, was the episode available in global areas such as searching for it by name, or the episodes tab under the tv library?

Link to comment
Share on other sites

chstoll

The folder Season 7 contained 3 episodes, but the whole season 7 (non of episodes) was not available, neither in MetaData-Manager, nor in TV-Series.

 

Plugins:

Auto Box Sets

Auto Oranize

Blueray Folder Support

Cinema Intros

DLNA

DVD Folder Support

Fanart.tv

IMVDb

Kodi Companion

MovieDB

MusicBrainz

Nfo Metadata

OMDb

Open Subtitles

Port Mapper

Studio Images

Telegram Notifications

TheAudoDB

TheTVDB

Webhooks

 

I did not realize I had so many Plugins, most of them where added automatically I think.

Link to comment
Share on other sites

So you don't remember if you could locate the episodes by searching for them?

Link to comment
Share on other sites

chstoll

I did not use the search. But through TV-Series - Ray Donovan it was not available. If it helps I could load the old DB once again and test the search.

Link to comment
Share on other sites

ewer0012

Tried the portable version and things showed up fine. In the process of reimporting my whole TV shows folder (Named differently in the Emby library) after removing it from my Library and running a full scan to clear out the entries. With how much I have in that directory, it'll probably be a day or more before it finishes the import.

Link to comment
Share on other sites

ewer0012

Thanks for the feedback.

 

Anytime. If there's something else that you'd like me to try, just let me know and I'll do my best.

 

Preliminary results are that removing the library entry in Emby, performing a full scan, then re-adding the library under a different name (eg: TV -> Television) is showing all seasons. With any luck this will be the quick-ish and easy solution. :)

 

Thank you for all the hard work you put into making Emby great!

Link to comment
Share on other sites

ewer0012

Preliminary results are that removing the library entry in Emby, performing a full scan, then re-adding the library under a different name (eg: TV -> Television) is showing all seasons. With any luck this will be the quick-ish and easy solution. :)

 

 

Just wanted to report that this fixed the issue. Just had to add the path under a different library name.

 

As an experiment I tried re-adding the path under the same library name as before and ran into the same issue... I haven't gotten a chance to look into the database file to see what it could be, but it seems like removing the original library and doing a full scan didn't get rid of the entries for that library name.

Link to comment
Share on other sites

  • 10 months later...

Hi,

I just wanted to let you know, that this issue is not fixed in the latest release. In many of my TV shows Seasons are not shown on my qnap nas.

This is a really big bug, because of missing seasons I cant even load episodes and there are many episodes missing although they are on the HD perfectly named.

This happened after I installed the second latest update. Everything worked flawlessly before.

It takes days (6 days the last time) rescanning all my files. Scanning and rescanning them again and again wont work for me. Is there another fix? I would higly appreceate it.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...