2019-09-15, 18:03
Not sure if this will help, but I was having the same issue. In my situation, I'm using MySQL on an unRAID server and connect to the Kodi database (18.4) from 3 systems (nVidia Shield, Windows 10, MacOS). My issue was related to the episode.idShow having a '-1'; resulting in the shows not showing correctly in code.
My fix was to run a SQL update with the following to fix.
update episode set idShow = xxx
where idEpisode in (
select a.idEpisode from episode a, tvshow b where b.idShow = a.idShow and a.idShow = 434
);
From what I was able to tell, this was causing a conflict each time Kodi attempted to scrape the nfo files that I generated with TMM. Once I fixed the issue, all my shows for MASH showed correctly in Kodi.
This may or may not help others.
My fix was to run a SQL update with the following to fix.
update episode set idShow = xxx
where idEpisode in (
select a.idEpisode from episode a, tvshow b where b.idShow = a.idShow and a.idShow = 434
);
From what I was able to tell, this was causing a conflict each time Kodi attempted to scrape the nfo files that I generated with TMM. Once I fixed the issue, all my shows for MASH showed correctly in Kodi.
This may or may not help others.
