2011-06-26, 20:49
This is the same exact thing I've been experiencing. After hours of testing and checking I discovered that the problem is the '\' character which is the windows File separator. For some reason MySql is not handling it very well and is not able to locate fields that have this field. Here is what I did that solved it for me:
All my media is on a shared disk. I removed the drive mapping I had to that share so it won't exist. Instead I replaced in my exported xml of the library (step 1) all my path which was 'M:\' to 'smb://[server_name_or_ip]/. I dropped the tables (xbmc_video and xbmc_music) and recreated them. Restarted xbmc, which populated these databases again and then imported the file. From that point and on everything works fine.
Be aware though that since you change the path to the files the fanart and thumbs don't match anymore. You will have to localize the thumbnail dir in one machine and you have to refresh your library (sometimes file by file) to get the images back. Afterwhich you can move the new thumbs dir to your share and recreate the links.
All my media is on a shared disk. I removed the drive mapping I had to that share so it won't exist. Instead I replaced in my exported xml of the library (step 1) all my path which was 'M:\' to 'smb://[server_name_or_ip]/. I dropped the tables (xbmc_video and xbmc_music) and recreated them. Restarted xbmc, which populated these databases again and then imported the file. From that point and on everything works fine.
Be aware though that since you change the path to the files the fanart and thumbs don't match anymore. You will have to localize the thumbnail dir in one machine and you have to refresh your library (sometimes file by file) to get the images back. Afterwhich you can move the new thumbs dir to your share and recreate the links.