firsny, I've tried out your solution, and got a few errors back. Here they are incase this might be a bug.
I have a fresh install of MySql 5.1.45 Community Server set up and an xbmc-music schema set up with the xbmc user set to have full permissions.
I'm using xbmc-r28256 (01-Mar-2010).
Most things work, however i noticed some errors in the debug log related to a view and a trigger when trying to update the music library for the first time. Here's a peek:
Code:
10:47:28 T:8024 M:4294967295 ERROR: SQL: Undefined MySQL error: Code (1142)
Query: CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo; END
10:47:28 T:8024 M:4294967295 ERROR: CMusicDatabase::CreateTables unable to create tables:0
10:47:28 T:8024 M:4294967295 DEBUG: Mysql rollback transaction
10:47:28 T:8024 M:4294967295 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
10:47:28 T:8024 M:4294967295 ERROR: CMusicDatabase::GetSongsCount() failed
And here's the whole log, with errors starting around line 417
http://pastebin.com/7X8edjhZ
The errors are only related to a music db update. I've had success with the video library and mysql.
It seems to me like it's trying to select data from a view that it never created.
Let me know if I can be of any other assistance and thanks for your hard work. This will be a great solution for keeping my 6 XBMC instances synchronized.
Thanks!
EDIT: I see from firsny's page that he hasn't been posting in the forums in about a month an a half, so if anyone else has an idea or has this working for themselves, let me know. I'm not sure when/if firsny will be back