[rap777]

Hi!

I just reloaded XBMC from scratch to my new HCPC.
I tried to set up mysql database which I used previously on my pld Media PC (which now is a Laptop/server) but even after lots of unistalls and reinstall I can not get the Library to build or update.
I reinstalled mysql several times but no go.

Here is part of the error log which I tried to fix by manually deleting and reinstalling both xbmc and mysql (on Windows7 64 bit)


22:23:04 T:816 NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)
22:23:04 T:816 NOTICE: Loaded settings file from special://profile/advancedsettings.xml
22:23:04 T:816 NOTICE: Contents of special://profile/advancedsettings.xml are...
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.61</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.61</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>\\MEDIAROOM/XBMCThumbnails</to>
</substitute>
</pathsubstitution>
</advancedsettings>
22:23:04 T:816 WARNING: VIDEO database configuration is experimental.
22:23:04 T:816 NOTICE: Getting hardware information now...
22:23:04 T:816 NOTICE: Checking resolution 12
22:23:04 T:816 NOTICE: Default DVD Player: dvdplayer
22:23:04 T:816 NOTICE: Default Video Player: dvdplayer
22:23:04 T:816 NOTICE: Default Audio Player: paplayer
22:23:04 T:816 NOTICE: Disabled debug logging due to GUI setting. Level 0.
22:23:04 T:816 NOTICE: Log level changed to 0
22:23:04 T:816 NOTICE: Loading media sources from special://masterprofile/sources.xml
22:23:04 T:816 NOTICE: initializing playlistplayer
22:23:04 T:816 NOTICE: DONE initializing playlistplayer
22:23:04 T:816 ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')
22:23:04 T:816 ERROR: Unable to open database: xbmc_video57 [1049](Unknown database 'xbmc_video57')
22:23:04 T:816 ERROR: Unable to open database: xbmc_video56 [1049](Unknown database 'xbmc_video56')

and so on..............

.'xbmc_video2')
22:23:04 T:816 ERROR: Unable to open database: xbmc_video1 [1049](Unknown database 'xbmc_video1')
22:23:04 T:816 NOTICE: Old database found - updating from version 0 to 58
22:23:04 T:816 ERROR: SQL: The source database was unexpectedly empty.
22:23:04 T:816 ERROR: Unable to copy old database xbmc_video to new version

22:15:54 T:2924 NOTICE: Storing total System Uptime
22:15:54 T:2924 NOTICE: Saving settings
22:15:54 T:2924 NOTICE: stop all
22:15:54 T:2924 NOTICE: ES: Stopping event server
22:15:54 T:2924 NOTICE: stopping zeroconf publishing
22:15:54 T:312 NOTICE: ES: UDP Event server stopped
22:15:54 T:2924 NOTICE: stop sap announcement listener
22:15:54 T:2924 NOTICE: clean cached files!
22:15:54 T:2924 NOTICE: unload skin
22:15:54 T:2924 NOTICE: stop python
22:15:55 T:2924 NOTICE: stopped
22:15:55 T:2924 NOTICE: destroy
22:15:55 T:2924 NOTICE: closing down remote control service
22:15:55 T:2924 NOTICE: unload sections
22:15:55 T:2924 NOTICE: destroy
22:15:55 T:2924 WARNING: Attempted to remove window 10013 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10014 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10015 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10016 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10017 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10018 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10019 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10107 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10115 from the window manager when it didn't exist
22:15:55 T:2924 WARNING: Attempted to remove window 10104 from the window manager when it didn't exist
22:15:55 T:2924 NOTICE: closing down remote control service
22:15:55 T:2924 NOTICE: unload sections
22:15:55 T:2924 NOTICE: application stopped...



There is something messed up in the mysql database. I would like to get rid of all that and just start again, BUT HOW?

Thanks and God bless

Alfred

[cruzannavy]

I removed the <name>xbmc_video</name> and let xbmc set the name for the database and it worked fine after that.

[rap777]

I removed the <name>xbmc_video</name> and let xbmc set the name for the database and it worked fine after that.

Thanks for your tip. How do you share with network if you do not have a name though?

Does it work if I remove the name tag on all clients "advanced settings" xml file?

Thanks and Regards

Alfred

[cruzannavy]

ill elaborate, you still need the name in your advanced setting file BUT! after you xbmc create it first. so this is what i did.
1. export library to single file.
2. edit my advance setting to use mysql ( without a name for the db file)
3. launch xbmc and let it create a db file in mysql. then exited xbmc ( cant remember if i went into videos/movies to see if it would force xbmc to recreate the db in mysql - pretty sure if xbmc doesnt see a dbb file it just auto creates it)
4. used command line for mysql to see what db name was created , set the read/write all permission (grant)
5. edited the advanced settings using the name xbmc created in mysql for my advanced settings
6. launched xbmc and imported my library back in to xbmc
7 edited other xbmc installs advances setting to use the right mysql db name

[Ned Scott]

That should not be necessary, and sounds like either a bug or something misconfigured. There should be no need to remove the <name> tag at any point in this.

[cruzannavy]

I agree Ned, but after trial and error and other threads I read, I figured, why not give it a try, so I removed the name and it worked. BUT, what I can’t say is what version of nightly I was on when I did this. And I also did not try to recreate the db after the latest nightly, so this maybe a moot issue. Also I believe it may have coincided with other mysql issues that were ongoing at the same time. But hey, with the disclaimer of ( these are nightlies and you may run into bugs) that removal of the name in the advanced settings did the trick for me, I’ll see when I get home if I recreate it with the latest nightly if it still gives me the same issues..

[rap777]

I agree Ned, but after trial and error and other threads I read, I figured, why not give it a try, so I removed the name and it worked. BUT, what I can’t say is what version of nightly I was on when I did this. And I also did not try to recreate the db after the latest nightly, so this maybe a moot issue. Also I believe it may have coincided with other mysql issues that were ongoing at the same time. But hey, with the disclaimer of ( these are nightlies and you may run into bugs) that removal of the name in the advanced settings did the trick for me, I’ll see when I get home if I recreate it with the latest nightly if it still gives me the same issues..

Thank you guys for all your help!
I decided to stick with MB for the time being. I just finished my Cinema-room and I like the idea to be able to load PowerDVD 11 as an external player when needed.I love XBMC though and will get back to it after the release of EDEN!

Thanks again and God bless

Alfred

[papampi]

I removed the <name>xbmc_video</name> and let xbmc set the name for the database and it worked fine after that.

hehheh
nice trick !
I was strugling with it for a month and now it solved my problem with all my xbmc's on Atv1, xbox original, iPad, Atv2 and Ubuntu .

thanks for the heads up !!!!