[notrui]

Hi.
I don't know why, but since I installed Kodi 18.4 the series no longer works.
I see the series but Kodi doesn't let me into the episodes. It's definitely due to the DB because when I use Kodi default (local) everything is fine.

My advancedsettings:
<advancedsettings>
    <videodatabase>
      <type>mysql</type>
      <host>192.168.2.110</host>
      <name>kodi_video</name>
      <user>kodi</user>
      <pass>kodi</pass>
    </videodatabase>

<musicdatabase>
 <type>mysql</type>
  <host>192.168.2.110</host>
  <name>kodi_music</name>
      <user>kodi</user>
      <pass>kodi</pass>
</musicdatabase>

    <pathsubstitution>
    <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://192.168.2.110/KODI/Thumbnails/</to>
    </substitute>
    </pathsubstitution>
</advancedsettings>


I tried deleting (drop) and rebuilding the DB on my nas but nothing.
The movie work fine!

Hello.
I use mysql with a NAS (DS418) with NFS ethernet gigabit.
I had problems in the beginning to setup everything and understand.


Check this:

https://kodi.wiki/view/MySQL/Setting_up_...ttings.xml

In your advancedsettings.xml it misses this: 
<port>3306</port>

My problem was in the mariadb port, i had to change port to 3307

Now is working very well  

I also use MariaDB, how do you know the port you use?

With the 3306 nothing changes (I see the series but not the episodes), with the 3307 I see nothing.

You have to go to the nas web configuration:
Go to mariadb configuration and try to see the port that mariadb uses . I use maria db 10 (i think).