[coalfield]

I have been loving the latest raspbmc 13.2 xbmc on the pi, and have bought a second.

Wanting to run a shared library I have been using the tutorial on the wiki to set up.

All stages have gone well, and with a fresh Raspbmc install and a clean MySQL install I have added an NFS share for my Movies.

Following a scrape, I can see 'MyVideos78' created in SQL, and when I read this table, it is populated 100% correctly with my data.

However after scrape when I goto Movies in XBMC, there is nothing. Not a single file.

Reboot is the same, blank.

If I scrape again, nothing is added (its already in MySQL DB anyway).

I have also tried with an SMB share. Same issue.

Both the files and SQL are on my Drobo5N.

Any ideas? All clean installs so I am stumped?!

EDIT: Looking at my logs, it looks like some tables are missing, which is odd as its all a clean install. Anyone know if this is the problem and if so how to fix?

18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT count(1) FROM tvshowview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT count(1) FROM tvshowview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT count(1) FROM movieview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT count(1) FROM movieview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT count(playCount) FROM movieview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT count(playCount) FROM movieview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT count(1) FROM musicvideoview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT count(1) FROM musicvideoview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT count(playCount) FROM musicvideoview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideoview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT sum(watchedcount) FROM tvshowview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshowview LIMIT 1'
18:38:25 T:3037500192 INFO: Found input device /dev/input/event0
18:38:25 T:3037500192 INFO: opened device 'Chicony USB Keyboard' (file name /dev/input/event0), m_bSkipNonKeyEvents 0
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT sum(totalcount) FROM tvshowview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshowview LIMIT 1'
18:38:25 T:2885678144 ERROR: SQL: The table does not exist
Query: SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1
18:38:25 T:2885678144 ERROR: GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1'

[coalfield]

Good old google....

Spotting this post:
http://forum.kodi.tv/showthread.php?tid=198390

Solution

To make your Drobo5N MySQL database do less enforcement and thereby work with the XBMC SQL, you will want to modify the my.cnf file found in your $HOME/Shares/DroboApps/MySQL/etc directory. Look for the line that starts with SQL_MODE =. This is followed by a whole lot of parameters. The last parameter in mine was the ONLY_FULL_GROUP_BY parameter.

Its seems the problem is specific to the Drobo5N / MySQL 5.6

Bug log with some useful info: http://trac.xbmc.org/ticket/15311

Hopefully of use if anyone else encounters the same issue, a nice easy fix