[zephura]

Hi,

Since several days now, for some tv show (almost all), I got the wrong number of episods.

Example : one TV SHOW has 13 episods,
It is displayed "13 viewed" / "13 not viewed" out of a "total of 26".

Here what can explained :
Once upon a time, I had a good working server, it shared files through samba (CIFS).
One day, everything gone wrong (the bad witch came then) and I should setup a new server.
The new server works now fine, but shared files through NFS.
And it lived as happy as it can. end of the story.


More seriously, Same file, different path (as different source).


what I have tried :
The only thing I could tried is :
- remove the source
- add validate to remove the file in the "Video library"
- readd the source
- update the library.
Result : EXACTLY the same behaviour.

What I have NOT tried : create a new library:
it would be easy
- on any linux client run
- create a new DB (MyOldVideos93)
- move all tables from MyVideos93 to MyOldVideos93
- drop MyVideos93
-update the VideoLibrary.

I think it is a really "harsh" method.

Someone a better idea?

[zephura]

Bad solution done on my OSMC (Kodi 15.2)

I am currently updating my Library.

BTW : it seems the user kodi didn't had ALL the FULL privileges on the Database....
the user 'kodi' couldn't create the views (the 6 required VIEWS) for MyVideo database...

Edit 1:
Update finished

Code:

NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 03:53:35

Bad news, It didn't worked.

Any idea greatly appreciated.


If that could help someone clever.
all the account of episods are : "real_number_of_episode * 2 -1"
example:
one show with 13episodes will display 13*2-1=25
thus number of episods 25 (seen 0 -not seen 25)

BUT, when a show as completly seen, it display all the episods seen / all the episods minus -1 not seen
example:
one show with 13episodes with all episods seen will display 13 / 12
thus number of episods 25 (seen 13 - not seen 12)

Edit2:
2nd bad news, I've tried with OpenElec, same behaviour.

[marantz]

Mariadb 10.1.x? https://mariadb.atlassian.net/projects/M...openissues

[zephura]

OMG !!!!
it is a known MariaDB issue...

I tried the demo sent with your link:

• a specific count
  
• a safeguard count
  
• a direct count

the safeguard is the issue

Code:

# mysql -ukodi -pkodi MyVideos93 -e " select count(episode_view.c00),nullif(count(episode_view.c00),0), count(c00) from episode_view where strFileName like 'SAO.%';"
+-------------------------+-----------------------------------+------------+
| count(episode_view.c00) | nullif(count(episode_view.c00),0) | count(c00) |
+-------------------------+-----------------------------------+------------+
|                      51 |                               101 |         51 |
+-------------------------+-----------------------------------+------------+
# mysql --version
mysql  Ver 15.1 Distrib 10.1.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

You're right marantz, I run MariaDB as SQL server, version 10.1.10 as you can read.

NOT linked to kodi, I change the title