Library count mismatch - Printable Version

Library count mismatch - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Library count mismatch (/showthread.php?tid=206321)

Library count mismatch - _Andy_ - 2014-10-13

Hello

I have a question about the library stats. For testing purpose i use 2 different skins. The stats in the skins shows 182 tvshows and 12664 episodes.

If i go direct into the MySQL library and execute

Code:
SELECT count(idEpisode) FROM `myvideos89`.`episode`;

i get as result 12577 episodes.

Why the difference?
What i'm missing?

RE: Library count mismatch - k4sh1n - 2014-10-13

Any duplicates:

Code:
select count(field1,field2) 

from table 

where the combination of field1, field2 occurs multiple times

Maybe do a clean library and re-SQL count

RE: Library count mismatch - _Andy_ - 2014-10-14

Hello.

Thx for your help but if duplicates are the problem i would expect more counts in the database than in the skin. The skins show more episodes that i have in the database.

That is what is bugging me.

I have some doubles because some Anime Spiderman shows are not recognized correct but i guess that would result in more counts in the database than in the skins.