[excelsi0r]

I am trying to have several Kodi's to use the same database... as described below.




All Kodi's are at version 18.2
Using the default estuary skin in all
Libreelec is at version 8.90.015
MariaDB version 10.5.4
Raspbian 9.11
Android is 10 QKQ1.190825.002

Everything works great between Libreelec and Raspbian. Watched status and resume points work normally.
However, when using the Android device, the left side icons aren't working (Not watched, Resume, Watched). The resume points work though... Meaning: If a file is marked as "Resume" in Libreelec. In Android is marked as "Not watched" but if I click on it, it says "Resume from XX:XX:XX".

Does anyone know what this might be?

I followed the tutorial: Kodi MySQL thoroughly. 
This is my advancedsettings.xml:

xml:


<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>192.168.1.64</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </videodatabase> 

  <musicdatabase>

    <type>mysql</type>

    <host>192.168.1.64</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </musicdatabase>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

    <importresumepoint>true</importresumepoint>

  </videolibrary>

</advancedsettings>

These are the commands that were used to setup MariaDB.

bash:


docker pull arm64v8/mariadb

docker run --name mariadb -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 --restart unless-stopped arm64v8/mariadb



mysql -u root -p'root' -h 192.168.1.64

CREATE USER 'kodi' IDENTIFIED BY 'kodi';

GRANT ALL ON *.* TO 'kodi';

flush privileges;

One thing I noticed, the database created by the android device is:



Whereas the one created by Raspbian or Libreelec is:



Thanks in advance!

[Klojum]

We could use a full debug log (wiki) from the problematic Android device.

[excelsi0r]

We could use a full debug log (wiki) from the problematic Android device.

kodi.old.log

kodi.log

Here they are.
Also, I forgot to mention. I tried to use Kodi 18.0 and 18.7 in Android. It is the same behavior. The resume points work but the status icon are always as "not watched".

[Klojum]

Here they are.

2020-06-27 02:46:58.788 T:14709 NOTICE: MYSQL: Connected to version 10.5.4-MariaDB-1:10.5.4+maria~focal

The database connection is there, that's a good start.

2020-06-27 02:46:58.039 T:14692 NOTICE: Disabled debug logging due to GUI setting. Level 0.

Unfortunately, debug has not been enabled. Do so, restart Kodi, and reproduce the error(s) again. And then provide the new log file here, please.

[excelsi0r]

We could use a full debug log (wiki) from the problematic Android device.

kodi.old.log

kodi.log

Here they are.
Also, I forgot to mention. I tried to use Kodi 18.0 and 18.7 in Android. It is the same behavior. The resume points work but the status icon are always as "not watched".

My bad.
Here it is with the same behavior. Opening a file, saving its status but the icon is still "Not watched"


kodi.log