[jdoggvt]

I'm running windows vista 32 with mysql database for videos and music. I upgraded to Frodo yesterday and my video library was imported fine but my music library won't scan anything in. I had no issues under eden and while I tried to make a backup of the database pre-upgrade the actual database file is zero bytes; oh well. Does this piece of the log have any useful info as to what to do to fix this? This happens every time I start XBMC

15:39:06 T:3312 DEBUG: CButtonTranslator::Load - no userdata IRSSmap.xml found, skipping
15:39:06 T:3312 INFO: GUI format 1920x1080, Display 1920x1080 @ 60.00 - Full Screen
15:39:06 T:3312 DEBUG: guilib: Fill viewport on change for solving rendering passes
15:39:06 T:3312 DEBUG: SECTION:LoadDLL(special://xbmcbin/system/libcurl.dll)
15:39:06 T:3312 NOTICE: Running database version Addons15
15:39:06 T:3312 DEBUG: CDatabaseManager::Initialize, updating databases...
15:39:06 T:3312 NOTICE: Running database version ViewModes4
15:39:06 T:3312 NOTICE: Running database version Textures13
15:39:06 T:3312 NOTICE: Attempting to update the database MyMusic32 from version 18 to 32
15:39:06 T:3312 DEBUG: Mysql Start transaction
15:39:06 T:3312 DEBUG: Mysql execute: UPDATE song SET strExtraArtists=SUBSTR(strExtraArtists,4), strExtraGenres=SUBSTR(strExtraGenres,4)
15:39:06 T:3312 DEBUG: Mysql execute: UPDATE album SET strExtraArtists=SUBSTR(strExtraArtists,4), strExtraGenres=SUBSTR(strExtraGenres,4)
15:39:06 T:3312 ERROR: SQL: Undefined MySQL error: Code (1054)
Query: UPDATE album SET strExtraArtists=SUBSTR(strExtraArtists,4), strExtraGenres=SUBSTR(strExtraGenres,4)
15:39:06 T:3312 ERROR: Exception updating database MyMusic32 from version 18 to 32
15:39:06 T:3312 ERROR: Error updating database MyMusic32 from version 18 to 32
15:39:06 T:3312 DEBUG: Mysql rollback transaction
15:39:06 T:3312 ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'mymusic31')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'mymusic30')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'mymusic29')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'mymusic28')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'mymusic27')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'mymusic26')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'mymusic25')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'mymusic24')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'mymusic23')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'mymusic22')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'mymusic21')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'mymusic20')
15:39:06 T:3312 ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'mymusic19')
15:39:06 T:3312 NOTICE: Old database found - updating from version 18 to 32
15:39:06 T:3312 ERROR: SQL: Can't create database for copy: 'MyMusic18' (1007)
15:39:06 T:3312 ERROR: Unable to copy old database MyMusic18 to new version MyMusic32

This is what happens whenever I try to scan the music directory into the library

16:17:39 T:2724 DEBUG: MUSIC_INFO::CMusicInfoScanner:oScan Scanning dir 'smb://HTPC-PC/Music/Music/AC_DC/Live/' as not in the database
16:17:39 T:2724 ERROR: CMusicDatabase::GetArtistsBySong(-1) failed
16:17:39 T:2724 ERROR: Previous line repeats 13 times.
16:17:39 T:2724 ERROR: CMusicDatabase::GetArtistsByAlbum(-1) failed
16:17:39 T:2724 ERROR: CMusicDatabase::HasAlbumInfo(2147483647) failed
16:17:39 T:2724 DEBUG: MUSIC_INFO::CMusicInfoScanner:oScan Scanning dir 'smb://HTPC-PC/Music/Music/AC_DC/Live From Atlantic Studios/' as not in the database
16:17:40 T:2724 ERROR: CMusicDatabase::GetArtistsBySong(-1) failed
16:17:40 T:2724 ERROR: Previous line repeats 7 times.
16:17:40 T:2724 ERROR: CMusicDatabase::GetArtistsByAlbum(-1) failed
16:17:40 T:2724 ERROR: CMusicDatabase::HasAlbumInfo(2147483647) failed
16:17:40 T:2724 DEBUG: MUSIC_INFO::CMusicInfoScanner:oScan Scanning dir 'smb://HTPC-PC/Music/Music/AC_DC/Powerage/' as not in the database
16:17:40 T:2724 ERROR: CMusicDatabase::GetArtistsBySong(-1) failed
16:17:40 T:2724 ERROR: Previous line repeats 8 times.
16:17:40 T:2724 ERROR: CMusicDatabase::GetArtistsByAlbum(-1) failed
16:17:40 T:2724 ERROR: CMusicDatabase::HasAlbumInfo(2147483647) failed

and on and on until I cancel the scan. Does anybody have any suggestions?

[rpfrogner]

I'm getting the same thing across two MAC's (OSX 10.6 and 10.) and 3 Windows 7 systems using SMB paths to a remote NAS. If I remove the advancedsettings.xml pointing to the mysql database, everything works (except that I can't sync between systems). As soon as I point the DB back to mysql, I can no longer set the content as the DB will not populate. I've verified the xbmc DB account has the rights it needs, and the MyVideos75 database is created on my MySql server with tables for "bookmark" and "version" but that's it. So far, it's consistent across platforms and after fresh installs.
Here's a subset of the log:

==============================

18:04:41 T:4607197184 NOTICE: VideoInfoScanner: Starting scan ..
18:04:42 T:4607197184 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='smb://supermicro/share/Media/Movies/'
18:04:42 T:4607197184 ERROR: GetPathId unable to getpath (select idPath from path where strPath='smb://supermicro/share/Media/Movies/')
18:04:42 T:4607197184 ERROR: SQL: The table does not exist
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate, path.exclude from path where strPath='smb://supermicro/share/Media/'
18:04:42 T:4607197184 ERROR: GetScraperForPath failed
18:04:42 T:4607197184 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
18:04:42 T:140735238205824 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='sources://video/'
18:04:42 T:140735238205824 ERROR: GetPathId unable to getpath (select idPath from path where strPath='sources://video/')
18:04:42 T:140735238205824 ERROR: SQL: The table does not exist
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate, path.exclude from path where strPath='sources://'
18:04:42 T:140735238205824 ERROR: GetScraperForPath failed
18:04:42 T:4607197184 NOTICE: Thread Background Loader start, auto delete: false
18:04:44 T:140735238205824 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='smb://supermicro/share/Media/Movies/'
18:04:44 T:140735238205824 ERROR: GetPathId unable to getpath (select idPath from path where strPath='smb://supermicro/share/Media/Movies/')
18:04:44 T:140735238205824 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='smb://supermicro/share/Media/Movies/'
18:04:44 T:140735238205824 ERROR: GetPathId unable to getpath (select idPath from path where strPath='smb://supermicro/share/Media/Movies/')
18:04:44 T:140735238205824 ERROR: SQL: The table does not exist
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate, path.exclude from path where strPath='smb://supermicro/share/Media/'
18:04:44 T:140735238205824 ERROR: GetScraperForPath failed
18:04:46 T:140735238205824 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='smb://supermicro/share/Media/Movies/'
18:04:46 T:140735238205824 ERROR: GetPathId unable to getpath (select idPath from path where strPath='smb://supermicro/share/Media/Movies/')
18:04:46 T:140735238205824 ERROR: SQL: The table does not exist
Query: select path.strContent,path.strScraper,path.scanRecursive,path.useFolderNames,path.strSettings,path.noUpdate, path.exclude from path where strPath='smb://supermicro/share/Media/'
18:04:46 T:140735238205824 ERROR: GetScraperForPath failed
18:04:50 T:140735238205824 ERROR: SQL: The table does not exist
Query: select idPath from path where strPath='smb://supermicro/share/Media/Movies/'
18:04:50 T:140735238205824 ERROR: GetPathId unable to getpath (select idPath from path where strPath='smb://supermicro/share/Media/Movies/')


=======================

[jmarshall]

The update is failing as pointed out in the first bit of your log.

Drop the v32 database and try the update again. It's useless trying anything else until you get a correctly function v32 database.

[rpfrogner]

I've dropped it a few times to no avail. It's always recreated, but never fully populated, I only get the two tables for MyVideos75 "bookmark" and "version" - which makes it somewhat more interesting since the database and some tables are created, but that's it. I'll likely try it on another physical mysql server next.

[rpfrogner]

welp - for me it was the mysql server. when I moved the config to point to a different physical (virtual really) box, everything populated. Not sure how, but something got hosed with the overall mysql instance...

[jdoggvt]

The update is failing as pointed out in the first bit of your log.

Drop the v32 database and try the update again. It's useless trying anything else until you get a correctly function v32 database.

I dropped the mymusic32 database (21 rows affected) and this is what I was left with:

(https://www.dropbox.com/s/80mo4rnbik1x68...ases.jpg?m just in case the I screwed that up)

I restarted mysql (just in case I guess) and restarted xbmc, which locked up for about 20 minutes before I quit the process and checked the log:

10:00:42 T:5732 NOTICE: Running database version Textures13
10:00:42 T:5732 ERROR: Unable to open database: MyMusic32 [1049](Unknown database 'mymusic32')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'mymusic31')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'mymusic30')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'mymusic29')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'mymusic28')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'mymusic27')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'mymusic26')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'mymusic25')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'mymusic24')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'mymusic23')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'mymusic22')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'mymusic21')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'mymusic20')
10:00:42 T:5732 ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'mymusic19')
10:00:42 T:5732 NOTICE: Old database found - updating from version 18 to 32
10:00:51 T:5732 NOTICE: Attempting to update the database MyMusic32 from version 18 to 32

looking at the databases again it did recreate mymusic32, should this just take a really really long time? I have about 1200 artists and 2600 albums so if the issue is just 'patience' that would be awesome. Could any of the other music database entries be causing issues?

Update: I suppose it was just a patience issue, I let it run for about 30 minutes and XBMC finally started and asked me to scan in my music images.