XBMC 10.0 and MySql on Debian 6.0

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
trmentry Offline
Junior Member
Posts: 18
Joined: Mar 2011
Reputation: 0
Post: #1
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:00

The 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
(This post was last modified: 2011-03-04 04:01 by trmentry.)
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 26,228
Joined: Oct 2003
Reputation: 177
Post: #2
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.

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
find quote
trmentry Offline
Junior Member
Posts: 18
Joined: Mar 2011
Reputation: 0
Post: #3
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.
find quote