Page 1 of 3
Incomplete In-Progress TV using Kodi DB
Posted: 05 Jul 2020, 17:34
by feardamhan
Hi All
Has anyone else seen the issue where MrMC using a pre-existing Kodi 18 database is only showing a random subset of the TV shows that are actually in-progress?
I Have maybe 10-15 in progress shows visible in Kodi, but only 3 or so of those showing in MrMC and they are random ie. not the most current or the least current, just random
Movies seem to be correct, but TV Shows not so
Appreciate any insights. I just bought the paid version purely for the
mysql integration - assuming the limited numbers showing was due to the limits of the free version, so this is disappointing!
--Ken
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 04:26
by amet
Let’s see the Kodi advanced setting and MrMC
debuglog please.
Are you sure you have connected to a correct database ?
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 09:04
by feardamhan
Advanced setting:
Code: Select all
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.15.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
<name>main_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.15.30</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
<name>main_music</name>
</musicdatabase>
<videolibrary>
<hideallitems>true</hideallitems>
</videolibrary>
<musiclibrary>
<hideallitems>true</hideallitems>
</musiclibrary>
<cleanonupdate>true</cleanonupdate>
<pathsubstitution>
<substitute>
<from>special://profile/Thumbnails/</from>
<to>smb://WD-4TB-A/Infrastructure/kodi_thumbnails/</to>
</substitute>
</pathsubstitution>
</advancedsettings>
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 09:05
by feardamhan
100% sure that I'm connected to the correct
mySQL DB. Some of the watched status is correct. Its just missing items. Also, if I start watching a TV series on the Apple TV, it shows up correctly on the Kodi clients, proving its the same DB.
Will need to get the debug log. Not done that before. Will report back when I have it.
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 09:14
by feardamhan
I7NAC.log
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 09:21
by feardamhan
Not 100% sure what one will see in the log. It’s not like I can click a button to force the issue. Let me know if there is anything I can do the nudge the system so the log is meaningful
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 09:45
by amet
Thanks ... I’ll have a look,
debuglog might show some errors in database connection.
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 10:14
by amet
Code: Select all
10:09:49.570 T:6163116032 ERROR: Database is not present, does the user has CREATE DATABASE permission
10:09:49.570 T:6163116032 ERROR: Unable to open database: main_video116 [2006](MySQL server has gone away)
10:09:49.570 T:6163116032 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
that's the only error I see relating to Video database
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 10:27
by feardamhan
Despite that error - its clearly actually connecting as otherwise I wouldn’t be seeing all the content. And I am. It’s just the listing of in-progress tv that’s incomplete.
I’ve fully closed MrMC and restarted it. New debug log 0LB77. Maybe that will show more detail as it would have started a new session to the DB?
Re: Incomplete In-Progress TV using Kodi DB
Posted: 06 Jul 2020, 11:03
by feardamhan
Can confirm that main_video116 exists on the server btw.