XBMC MySQL Library

(2012-05-09 03:26)jmarshall Wrote:  @djbarney: that issue has already been fixed - wait for the next nightly.

Hi jmarshall,

Would that be the 09 may version that is currently available? I installed the currently newest http://mirrors.xbmc.org/nightlies/win32/...master.exe nightly, which still results in similar errors and an empty library here. I've included the newest log for you at : http://xbmclogs.com/show.php?id=2388

1050 is "Table already exists". You have a half-screwed up database somewhere along the line (v63 perhaps).

Kill it using mysql.

Alright jmarshall, thanks for the info installed the latest version and deleted the messed up v63 database (still had 61 in mysql anyways) and that fixed it. Thanks! This is exactly why i love XBMC and the ppl behind it, keep being awesome!

(2012-05-10 23:17)djbarney Wrote:  Alright jmarshall, thanks for the info installed the latest version and deleted the messed up v63 database (still had 61 in mysql anyways) and that fixed it. Thanks! This is exactly why i love XBMC and the ppl behind it, keep being awesome!

Hi,

Is your pathsubstitution still working under the latest nightly build?
I've first exported my original MySQL video database (MyVideos60), deleted it afterwards, booted XBMC nightly -> creating MyVideos63.
Within PHPMyAdmin I've deleted all views and succesfully imported the MyVideos60. Booting XBMC bring all movies and TV-series back, but no thumbs/Fanart any more.
I didn't changed the pathsubstitution which was working under Eden (Stable).

Let XBMC update the DB to v63 don't mess around with it by yourself.

(2012-05-11 09:46)speedway Wrote:  ... Booting XBMC bring all movies and TV-series back, but no thumbs/Fanart any more.
...

Noticed that too with a nightly from the nathan renniewaldock xbmc nightly PPA. Tried that to try and solve a problem (not being able to play ISO's and VIDEO_TS folders properly). Actually XBMC started downloading new thumbs and fanart. Annoying when you have spent quite some time customizing them . I reverted to Eden even though the original problem had been solved. Any thoughts?

(2012-05-11 10:06)Memphiz Wrote:  Let XBMC update the DB to v63 don't mess around with it by yourself.

This is what I did in the first please, but something went wrong when updating from MyVideos60 to MyVideos63 (cfr.log
http://xbmclogs.com/show.php?id=2362&hash=36497117 (psswd = debug).

(2012-05-11 17:59)speedway Wrote:  

(2012-05-11 10:06)Memphiz Wrote:  Let XBMC update the DB to v63 don't mess around with it by yourself.

This is what I did in the first please, but something went wrong when updating from MyVideos60 to MyVideos63 (cfr.log
http://xbmclogs.com/show.php?id=2362&hash=36497117 (psswd = debug).

Just repeated my actions but with Eden and everything goes well. Afterwards I tried via XBMC nightly build to update MyVideos60 to MyVideo63 and again troubles (no movies/series/fanart/thumbs).

18:53:21 T:6600 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'MyVideos63')
18:53:21 T:6600 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'MyVideos62')
18:53:21 T:6600 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'MyVideos61')
18:53:21 T:6600 NOTICE: Old database found - updating from version 60 to 63
18:53:22 T:692 ERROR: CRemoteControl::Connect - failed to connect
18:53:31 T:6600 NOTICE: Attempting to update the database MyVideos63 from version 60 to 63
18:53:32 T:6600 ERROR: SQL: The table does not exist
Query: INSERT INTO seasons (idShow,season) SELECT DISTINCT idShow,c12 FROM episodeview WHERE idShow=1
18:53:32 T:6600 ERROR: Error attempting to update the database version!
18:53:32 T:6600 ERROR: Can't update the database MyVideos63 from version 60 to 63

I think something is wrong with the update mechanisme ... hopefuly I will be fixed
Only solution is to go back again to Eden, restore, export within xbmc my liberary.
Do a complete new install with nightly build, let it create MyVideos63 and import my liberary via XBMC .... .

I'm using the latest Aeon MQ3 skin in conjunction with the may 10th build (didnt have much time to update today) but my fanart, thumbnails etc. are still working as they should on all my connected devices using the pathsubstitution.

There were a number of small faults in the nightlies (the one above is one such example). As art is stored in the db now, this is why that will screw up with a db update gone bad.

I believe it should be all good now, but ofcourse if you have a db update go bad, then you may need to get rid of one or two db's in the meantime. There's nothing in v61->v63 that is critical (other than any changes you've made to watched status and the like) so you can drop them one by one starting with 64 going back until you get things going again.

Cheers,
Jonathan