[solved] MySQL - Resume points not being saved

  • 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.

  • 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.

  • 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.

  • 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.