UPDATE AFTER A BIT MORE TESTING
I have just deleted the new DB's from MySQL, left the XBMC FRODO install on my main XBMC as it was before and then run it. I t creates new DB's on running. From the main menu all thumbnails are blank. Clicking on movies or TV shows asks to update art. After that is done all thumbnails and movies and TV shows are correct. I can update library from both the Movie and TV sections without any issues. However looking at the sources. The DVD source is setup fine with the MovieDB scraper etc. However the TV source is blank, no scraper is configured even though when I update from the TV or Movie sections it says 'scanning tvshows using the TVDB'.
If I add a scaper to the TV Source it then aks to refresh all items in this source. If I say no then on the next update database it then duplicates all episodes. If I leave it alone with no scraper or other options configured it works fine and does not duplicate episodes.
Confused!!!
Thanks for the reply, between this and none of my movies playing I was going a little crazy checking and rechecking. I have this down to a very precise procedure (maybe incorrect but belt and braces)
All my Eden XBMC's use identical XML files for advancedsettings, mediasources and sources and all use the same NAS Shares in exactly the same way. I do not manually edit any sources inside XBMC. They are all loaded from the XML files. Not sure what you mean;
So to troubleshoot, at this point try to update the library on the HPTP, but without adding back any sources to it.
To install a new FRODO RC1 XBMC I remove all previous versions. Install XBMC on Ubuntu (all of our client machines laptops etc. are Ubuntu 12.04) using 'sudo apt-get install xbmc xbmc-bin' from the ppa:team-xbmc/unstable repositories or for Android
http://mirrors.xbmc.org/releases/android...bi-v7a.apk. Open XBMC once to create the directory structure. Shut it down, copy the thumbnails folder and textures db from my main XBMC box (this is the box that was upgraded from Eden following the upgrade FAQ and worked perfectly until I installed the next XBMC!) to the userdata folder (a real pain over wifi as this is over 22,000 files and 1.6GB as opposed to be being centrally stored on the NAS and accessed via path substitution as per Eden!!!!!!!! I now have multiple 1.6GB Thumbnails folders on user devices not ideal!!!!!!). Copy the advancedsettings, mediasources and sources XML from my main XBMC box to the userdata folder. Open XBMC and check the sources are all there, this is where things seem to go a little awry. In the Recorded TV source the scraper is not set. the DVD's source is set correctly.
Going back to the main menu everything looks fine. all thumbnails are showing up and are exactly as the first XBMC box, I can play any item on linux and even the watched status is correct. However if I go into Movies and update database. The TV shows are put in the Movie DB and the DB is now screwed If I leave it running it duplicates all episodes and puts them in the movie DB.
Going back to the first XBMC the DB is now screwed and TV episodes are now in the Movie DB. Unless someone else knows better I have to go back to my Eden DB's delete the new DB's created by FRODO on my MySQL server and start again.
I must be missing something. I have followed the FAQ's perfectly and am not a beginner to XBMC I have been using it since the early days of XBOX!
When following the above procedure on Android everything is as above. However when updating the database within TV Shows or Movies all TV episodes are duplicated either in TV shows or movies and the DB is screwed, movies do not duplicate and are fine but do not play (Full DVD rips DVD9 as per original DVD minus protection). TV Shows play fine.
Any help appreciated, it seems that FRODO is not quite there yet and the distributed Thumbnails are a real pain and defeat the object of having shared media. Having the option of using path substitution for Thumbnails at the expense of a little slower load time is worth it to me.
See below my XML files for info:
advancedsettings.xml
<advancedsettings>
<videoextensions>
<add>.html</add>
</videoextensions>
<videodatabase>
<type>mysql</type>
<host>xxx.xxx.xxx.xxx</host>
<port>3306</port>
<user>YOUR USER</user>
<pass>YOUR PASSWORD</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>xxx.xxx.xxx.xxx</host>
<port>3306</port>
<user>YOUR USER</user>
<pass>YOUR PASSWORD</pass>
</musicdatabase>
<importwatchedstate>true</importwatchedstate>
</advancedsettings>
mediasources.xml
<mediasources>
<network>
<location id="0">smb://username:password@SHARE/TV</location>
<location id="1">smb://username:password@SHARE/DVDS/</location>
<location id="2">smb://username:password@SHARE/Music/</location>
<location id="3">smb://username:password@SHARE/OTHER/</location>
</network>
</mediasources>
sources.xml
<sources>
<programs>
<default pathversion="1"></default>
</programs>
<video>
<default pathversion="1"></default>
<source>
<name>Recorded TV</name>
<path pathversion="1">smb://username:password@SHARE/TV/</path>
</source>
<source>
<name>DVDS</name>
<path pathversion="1">smb://username:password@SHARE/DVDS/</path>
</source>
</video>
<music>
<default pathversion="1"></default>
<source>
<name>Music</name>
<path pathversion="1">smb://username:password@SHARE/Music/</path>
</source>
</music>
<pictures>
<default pathversion="1"></default>
<source>
<name>Photos</name>
<path pathversion="1">smb://username:password@SHARE/Photos/</path>
</source>
</pictures>
<files>
<default pathversion="1"></default>
</files>
</sources>
