[solved] MySQL - Resume points not being saved

uatschitchun · December 5, 2019 at 8:55 AM

Hi there.

I'm running a central MySQL DB with multiple clients. All clients are Kodi 18.5. All clients save the resume points if watching a video:

Laptop (Bionic): (tail -f kodi.log | grep -i mysql)

Code

2019-12-05 09:46:50.895 T:140293067859712   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:46:50.910 T:140293067859712   DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:46:50' where idFile=74502019-12-05 09:46:50.919 T:140293067859712   DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,1809.793130,7001.630000,'','VideoPlayer','', 1)

This is Amlogic Box running Coreelec:

Code

2019-12-05 09:25:00.400 T:3610657664   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=74502019-12-05 09:25:00.422 T:3766551424   DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed='2019-12-05 09:25:00' where idFile=7450
2019-12-05 09:25:00.431 T:3766551424   DEBUG: Mysql execute: insert into bookmark (idBookmark, idFile, timeInSeconds, totalTimeInSeconds, thumbNailImage, player, playerState, type) values(NULL,7450,3055.282872,7001.630000,'','VideoPlayer','', 1)

This is Libreelec (9.2.0) (Rpi3):

Code

2019-12-05 09:51:11.188 T:1793299328   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448

As you can see, all systems (except LE) do execute the insert into the Mysql DB!?

Code

# grep -i mysql .kodi/temp/kodi.log                                                 <type>mysql</type>
                                               <type>mysql</type>
2019-12-05 09:35:16.603 T:1807721344  NOTICE: MYSQL: Connected to version 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:35:26.481 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:Updater]: Database driver: External (mysql)
2019-12-05 09:35:26.481 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Using MySQL connector version 1.1.7
2019-12-05 09:35:26.695 T:1648538496  NOTICE: [plugin.video.mediathekview-0.6.2:StoreMySQL]: Connected to server 192.168.5.13 running 10.4.10-MariaDB-1:10.4.10+maria~bionic-log
2019-12-05 09:38:01.949 T:1249416064   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448
2019-12-05 09:51:11.188 T:1793299328   DEBUG: Mysql execute: DELETE FROM settings WHERE idFile=7448

As you can see, the connection is established, no errors regarding MySQL and even Mediathekview is able to connect to the DB.

Only thing is, there's no bookmark execution running into the DB if a video is played from LE.

I noticed that even playcounts for audio aren't saved into the DB from LE, but I have no logs available atm.

**Klojum** · December 5, 2019 at 12:56 PM Official Post

Very lovely to show us a couple of SQL queries, but it doesn't show us much.

Enable the Database component in Kodi's debugging section (if not already done), restart LibreELEC, do some database stuff, and provide the FULL log file via a pastebin website so we can see a complete picture.

uatschitchun · December 5, 2019 at 4:55 PM

It shows the missing executes, but I'll provide more.

**Da Flex** · December 5, 2019 at 6:41 PM Official Post

What do you do on LE to trigger those MySQL calls?

uatschitchun · December 5, 2019 at 7:02 PM

Play a movie, forward to 30 minutes (for to have it set a resume point) and stop the movie.

All other devices send the "mysql execute" but LE.

**Da Flex** · December 5, 2019 at 7:29 PM Official Post

Where is the movie located, local or server?

How do you play the movie, by using Mediathekview add-on?

Has Mediathekview an installation dependency to the MySQL connector add-on?

Which settings have you made at the Mediathekview add-on?

Which settings have you made at the MySQL connector add-on?

PS: Don't forget to provide a complete log.

**Klojum** · December 5, 2019 at 7:35 PM Official Post

Quote from Da Flex

Where is the movie located, local or server?

Well, if only we had a complete log file...

uatschitchun · December 6, 2019 at 9:54 AM

Starting with a fresh profile solved this issue. Guess something broke by too much playing around with skins for to get my custom home menu entries correct.

I'll keep an eye on it.