Encountered a major bug. Still trying to figure out the logic but here is what i have observed so maybe you can figure it out...
When i watch an episode of a TV Show, i have a service that checks if i have watched the previous episode or if it even exists in my database.
After using 0.0.9k MySQL with Strict enabled, i started getting warnings on multiple shows that previous episode was missing entirely from the database.
Upon investigating, they were indeed missing from the database but were present in my file storage. Furthermore, the episode count displayed by Kodi was accurate but upon entering the season, the amount of episodes listed was different.
The image above shows that Season 10 has 12 Episodes, with 2 of them Unwatched.
Here you can see the 2nd to last episode is episode 8
And here you see Episodes 9 through 11 are missing. The total number of episodes is 9 with only 1 unwatched.
The history inside Sonarr tells me that Sonarr downloaded all episodes one by one from newsgroups and on April 17th, i replaced episodes 1 through 8 with a version i manually downloaded straight from Prime Video with StreamFab.
Some time between April 20th and April 26th, i ran KSC and it hosed a shit ton of TV Shows. April 27th, new episode was added by Sonaar without issue. I can't tell you exactly how many of my 1937 TV Shows with ~90,000 episodes it has broken but i have found that every TV Show that has had a new episode added after the cleanup was affected (the ones i watch as the episodes air)
IMO, it has to do with Kodi keeping the original filename in the database even if you delete that file and replace it with a differently named one.
I replace the "scene" episodes with the one from StreamFab because StreamFab lets me download them in H265 when most of the scene ones are in H264 or in HEVC that has an unnecessarily high bitrate. So it has to do with the file naming i am assuming because episodes 1-8 were in H264 and i do put the name of the codec in my naming template and i replaced them with H265 versions. Of course this is an assumption but that is what i have observed from all the corrupt shows. The ones that had episodes replaced are still here while the ones that only had 1 version of the file disappeared.
Updating the library or right-click a specific show and scanning for new content does nothing. The ONLY way i was able to get the missing episodes back into the library was by using the Refresh function after pressing i to bring up the TV Show information and then scanning for new content again.
Needless to say i am not going to do that for 1937 TV Shows. So i setup a portable Kodi with a named (not default) MySQL database and rescanned the entire ~90,000 episodes and ~9000 Movies. It's time consuming so i didn't want be without a database for the stuff i still watch but never replaced files. That's the reason for not refreshing the whole current library.
P.S., after backing up the database once at the beginning of this addon's 1st release, i never did again... Lesson learned: Don't be lazy
