[BigMong]

hey BigMong I exactly followed your instructions without SQL errors.
Main-database works, but user-database stays empty.
In Kodi log I have the following error:
19:57:56 T:12264 ERROR: CVideoDatabase::GetMoviesByWhere failed

any ideas?

@horstepipe

What's the databases you are pointing to for the users? in your advancedsettings.xml you need this file for each user/profile
EG:
Main

PHP Code:

<videodatabase>
    <type>mysql</type>
    <host>192.168.0.110</host>
    <port>3306</port>
    <user>KODI</user>
    <pass>****</pass>
    <name>Kodi_Matt_Video_</name>
  </videodatabase> 


User

PHP Code:

<videodatabase>
    <type>mysql</type>
    <host>192.168.0.110</host>
    <port>3306</port>
    <user>KODI</user>
    <pass>****</pass>
    <name>Kodi_Mace_Video_</name>
  </videodatabase> 


The other thing It might be is the files table, you should have a "globalfiles" table under you main user this table will have the cols for each user
then you should have a view "files" and this is maped for all users to the main "globalfiles" table and the right col for each user

if you look in your sql the other users in the view "files" you should see the data for the user. This SQL should give you the data too

PHP Code:

SELECT * FROM `Kodi_Mace_Video_93`.`globalfiles` 


Hope this Helps