+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: XBMC 10.0 and MySql on Debian 6.0 (/showthread.php?tid=95879)
[SOLVED] XBMC 10.0 and MySql on Debian 6.0 - trmentry - 2011-03-04 01:41
Hello,
I was running XBMC Live on 2 little boxes both talking back to a MySql server on my Ubuntu server.
Everything was working fine and the updates of shows watched, etc was sync'ing.
I switched to Windows on the boxes so that I could get some Windows specific goodies running. So clean install of Windows 7 Ultimate on each box. (32bit).
In this process I've decom'ed my Ubuntu server and went to a Debian VM pretty much setup the same way.
When I setup the advancedsettings.xml with teh MySql info, it created the tables in the database with no issues.
However when I go to a directory of Movies and Set the Content... it doesn't update any tables. This is what I could find in the log.
Code:
16:18:53 T:2176 M:637906944 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>xx.xx.xx.xx</host>
<name>xbmc_video</name>
<user>root</user>
<pass>nopeeking</pass>
</videodatabase>
</advancedsettings>
16:18:53 T:2176 M:637931520 WARNING: VIDEO database configuration is experimental.
**SNIP**
16:21:06 T:3420 M:602210304 NOTICE: VideoInfoScanner: Starting scan ..
16:21:06 T:3420 M:602406912 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
16:21:24 T:3424 M:615821312 NOTICE: VideoInfoScanner: Starting scan ..
16:21:24 T:3424 M:615821312 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
16:22:08 T:3544 M:645349376 NOTICE: VideoInfoScanner: Starting scan ..
16:22:08 T:3544 M:645345280 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
16:23:59 T:2176 M:712077312 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'N:\\VIDEOS\\MOVIES (HD)\\','','')
16:23:59 T:2176 M:712151040 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'N:\\VIDEOS\\MOVIES (HD)\\','',''))
16:24:00 T:3800 M:712134656 NOTICE: VideoInfoScanner: Starting scan ..
16:24:00 T:3800 M:712134656 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00The Windows XBMC box is connecting to a Windows share for the movies, et.c
When I go back in XBMC it doesn't keep the Content settings.
My guess is something to do with the path name having ( ) in it. However this did work on the Live version without issues. And pointing to a directory with no ( ) in the path, does the same thing.
Any advice?
TIA
- jmarshall - 2011-03-04 03:06
It's because your local paths are win32-styled, and mysql doesn't deal with it (slash character).
Make the paths non-local (eg smb://) and you'll be all good.
- trmentry - 2011-03-04 04:00
jmarshall Wrote:It's because your local paths are win32-styled, and mysql doesn't deal with it (slash character).
Make the paths non-local (eg smb://) and you'll be all good.
Awesome! Worked like a charm.
Thank you very much for the help.