Library count mismatch
#1
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?
Reply
#2
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
Reply
#3
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.
Reply



Logout Mark Read Team Forum Stats Members Help
Library count mismatch0
This forum uses Lukasz Tkacz MyBB addons.