[npbhdk]

@npbhdk

I attempted to use the 99 instructions, didnt get any errors when using the sql. But kodi seems to fail at inserting data into the views.
i get errors like this when i attempt to scan files

18:19:34 T:944 ERROR: SQL: [Niels_Video_99] Undefined MySQL error: Code (1471) Query: insert into files (idFile, idPath, strFileName) values(NULL, 8, lots-tfoftr.mkv')
18:19:34 T:944 ERROR: CVideoDatabase::AddFile unable to addfile ()

and

18:19:17 T:5900 ERROR: SQL: [Niels_Video_99] Undefined MySQL error: Code (1471) Query: insert into path (idPath, strPath) values (NULL, 'smb://N-HTPC-PC/tv2/')
18:19:17 T:5900 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath) values (NULL, 'smb://N-HTPC-PC/tv2/'))

when attempting to change content type of a source this works when i use the master database in the advancedsettingsfile scanning for content does not

If I understand right, you are using all systems Master and Slaves to scan for media? (I have found its best to use only the one system Master or Slave to import, as when you do a scan on a different user it will redo the whole TV Shows as the Hash changes (Haven't looked too far into why that is))

By the looks of the errors its trying to INSERT into a non insertable view, I would check that you can view data in that view "files" that is linked to "globalfiles" does the Master and Slave connect to the DB with the same Login? Does the login being used have All Privileges to the view?

@RonM

Thank You, Glad you are loving it, OpenELEC on some RPI2 or 3's work awesome around the house, and now a few streets over, over a PTP WiFi network

Ive tried both scanning on the master and the slave, neither works and yes they use same database login, ive tried logging into the database with a gui client and i can insert data into the view with that, and i can see it aswell. Not really sure why it fails with kodi The mysql user has these priviliges (GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' WITH GRANT OPTION) so if got it right(havent used mysql much) it should be able to do everything like root can tried to use root login didnt work either same error.