I have another issue with mine.... XBMC seems to have duplicated most of the movie files and I can't get it to remove them. I can see from looking at the tables in SQLyog that there are duplicates of most movies, and they have entries as the following;
smb://xbmc:
[email protected]/Movie Archive/50's & earlier Movies/12 Angry Men (1957).mkv
smb://HOMESERVER/Movie Archive/50's & earlier Movies/12 Angry Men (1957).mkv
I have checked all three devices that connect to the SQL server (ATV2, XBMCbuntu and a Windows 7 laptop) and all have the advanced settings path redirection to the same advancedsettings.xml file on the Home Server, which has the "smb://xbmc:
[email protected]/Movie Archive/50's & earlier Movies/" type paths.
I have tried using the XBMC cleanup in the settings, but that's not removed them, and I cannot find any folders in the Video folders that have them. How do I remove the duplicate entries? Is there a tool/add on that will do it? Or can I run any SQL commands to remove them?
Damn thing....and it was all fine until a few days ago....!
They all have the following;
Code:
<advancedsettings>
<videodatabase>
<type>MySQL</type>
<host>192.168.0.4</host>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>MySQL</type>
<host>192.168.0.4</host>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>nfs://192.168.0.4:/XBMCThumbs/</to>
</substitute>
<substitute>
<from>special://masterprofile/sources.xml</from>
<to>smb://HOMESERVER/XBMC-XML-Files/sources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/mediasources.xml</from>
<to>smb://HOMESERVER/XBMC-XML-Files/mediasources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/favourites.xml</from>
<to>smb://HOMESERVER/XBMC-XML-Files/favourites.xml</to>
</substitute>
</pathsubstitution>
</advancedsettings>