Mysql and Xbmc
#1
I'm having a problem with duplicates when I import the database into xbmc. here is my advancesettings.xml
<advancedsettings>
<useddsfanart>true</useddsfanart>
<videodatabase>
<type>mysql</type>
<host>192.168.1.115</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.115</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<cputempcommand>cputemp</cputempcommand>
<gputempcommand>gputemp</gputempcommand>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
<jsonrpc>
<compactoutput>false</compactoutput>
</jsonrpc>
<pathsubstitution>
<substitute>
<from>/home/xbmc/nas_shares/movies/</from>
<to>SMB://192.168.1.105/movies/</to>
</substitute>
<substitute>
<from>/home/xbmc/nas_shares/movies2/</from>
<to>SMB://192.168.1.105/movies2/</to>
</substitute>
<substitute>
<from>/home/xbmc/tv_shows/</from>
<to>SMB://192.168.1.114/tv_shows</to>
</substitute>
<substitute>
<from>/home/xbmc/music/</from>
<to>SMB://192.168.1.105/music/</to>
</substitute>
<substitute>
<!--<from>special://masterprofile/Video/</from>-->
<from>special://masterprofile/Thumbnails/Video/</from>
<to>SMB://192.168.1.115/xbmc_thumbs/Video/</to>
</substitute>
<substitute>
<!--<from>special://masterprofile/Music/</from>-->
<from>special://masterprofile/Thumbnails/Music/</from>
<to>SMB://192.168.1.115/xbmc_thumbs/Music/</to>
</substitute>
</pathsubstitution>
</advancedsettings>

my log is here http://pastebin.com/Wgi3kK7v


Reply
#2
does the backup of the db contains the same paths as you have defined in your advancedsettings.xml ? Otherwise this would lead to duplicate entries.
Reply
#3
Are you talking about the database backup? I'm not sure how to check that.
Reply
#4
Are you updating the library from more than one XBMC box? If so, make sure that each box has the exact same source file (so it will need to point to the local file location since your path subs convert that to an SMB location).
Reply
#5
^^^^^ what he said. Just having a capital letter in one sources.xml and non capital in another will make XBMC think they are different paths and cause duplicates.

Mike
If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#6
Ahhh ok got it. So I'll copy from the source file and advancesettings from my main box and put it on my other boxes. Thanks for all your help.

Reply
#7
(2012-06-20, 01:52)Ned Scott Wrote: Are you updating the library from more than one XBMC box? If so, make sure that each box has the exact same source file (so it will need to point to the local file location since your path subs convert that to an SMB location).

I must be overlooking something here. Below is my sourcefile

<sources>
<programs>
<default pathversion="1"></default>
</programs>
<video>
<default pathversion="1"></default>
<source>
<name>Movies</name>
<path pathversion="1">smb://192.168.1.105/movies/</path>
<path pathversion="1">smb://192.168.1.105/movies2/</path>
</source>
<source>
<name>TV Shows</name>
<path pathversion="1">smb://192.168.1.114/tv_shows/</path>
</source>
</video>
<music>
<default pathversion="1"></default>
<source>
<name>Music</name>
<path pathversion="1">smb://192.168.1.105/music/</path>
</source>
</music>
<pictures>
<default pathversion="1"></default>
<source>
<name>Pictures</name>
<path pathversion="1">/home/xbmc/Pictures/</path>
</source>
</pictures>
<files>
<default pathversion="1"></default>
</files>
</sources>

I'm doing this on my main box once I got this fixed I will copy the source and advance to my other boxes. The duplicates are on my main box. Is it because the name is capitalized?
Reply
#8
I think I got it. What I did was deleted the databases. I didn't import the export I did from xbmc. I edited advancesettings, rebooted xbmc and all was good. No dups.
Reply

Logout Mark Read Team Forum Stats Members Help
Mysql and Xbmc0