SQL help please

im still using master profile for all pcs xbmc installs

(2012-03-30 13:42)mwkurt Wrote:  

(2012-02-19 00:36)Monkeypox Wrote:  After playing around I think I found the culprit. Mysql didn't like my Windows share name. Once I changed the shares to their SMB source it worked perfectly.

It might be worth making a note in the wiki to cover that.

So could you please explain what exactly you changed and to what? I am having the same problems with my upgrade to Eden.

Thanks,
Mark

I know this is a bit late, but I missed this change to the thread.

My windows share had space in the name, that the database didn't like. I changed "Windows Server" to "Windows_Server" and all was right with the world.

[SOLVED]

on a machine with complete local copy of eden video60 and music18 databases(found in user dir)

So i used this tool

to delete my dharma format tables. (xbmc_video+xbmc_music)

then open xbmc again, and xbmc will look for the missing tables in your myslq database, when it finds it missing, it will copy the local copy across to the mysql server. This instance of xbmc.log will complain about this is missing etc. but next shutdown and restart, xbmc.log will be sweet again.

i hope this may help others who have had messy log output since migrating to Eden.

Dam0