MusicLibrary2 does not work

[r3d]

That would be great! It will help newbies like me from stumbling at the same point

[monkey.eat(banana)]

hi

today i installed gbpvr.v1.0.16 and ran the ML2.v6.5 installer. i ran setup and got an error looking for the musiclibrary2.mdb. i got it from the wiki, copied to the gbpvr directory and ran setup again. ok, this time it loads... tried to go into settings for ML2 and got "DatabaseProviderFactory does not match DatabaseConnectionString Database type (filename), Verify your database settings on the general tab"
in the general tab i saw it pointing to the db correctly, so i pressed ok and went back in. no error now... in the collections/path tab, i deleted c: and added a directory with few mp3s, then i created a collection "all" with the system path. pressed ok and went back in again. at this point i'm making sure that all settings in each step are being saved correctly. i go back to the collections tab and the stuff i added is gone, c: is back. i exit settings and config, both with ok. start config again and get the same error as when i first started config after insalling ML2 and copying the db.
i then opened the db in access and i see that there is only one table called playlistdata.
so ovbiously something isn't being written properly and the other tables are erased.
what's going on? what the heck am i doing wrong? very confusing...

i'll double-post so i can include the errors from the config error log with in-line code...

[monkey.eat(banana)]

any and all help is much appreciated

Code:

2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: DB Error loading collections : The Microsoft Jet database engine cannot find the input table or query 'collectionData'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: You do not have any music paths set up 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Connecting to database 2007-10-18 22:24:21.062 INFO [1] MusicLibrary2: Using Access type database connection 2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: You have the wrong database table as it is missing fields. Download from the wiki 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Dropping Table collectionPaths 2007-10-18 22:24:21.062 ERROR [1] Db Error: Table 'collectionPaths' does not exist. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Dropping Table collectionData 2007-10-18 22:24:21.062 ERROR [1] Db Error: Table 'collectionData' does not exist. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Dropping Table MusicLibrary 2007-10-18 22:24:21.062 ERROR [1] Db Error: Table 'musiclibrary' does not exist. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Dropping Table playlists 2007-10-18 22:24:21.062 ERROR [1] Db Error: Table 'playlists' does not exist. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Dropping Table playlistdata 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating Table playlistdata 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating SQL-Lite Tables 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating Table Musiclibrary 2007-10-18 22:24:21.062 ERROR [1] Db Error: Syntax error in field definition. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating Table collectionData 2007-10-18 22:24:21.062 ERROR [1] Db Error: Syntax error in field definition. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating Table collectionPaths 2007-10-18 22:24:21.062 ERROR [1] Db Error: Syntax error in CREATE TABLE statement. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Creating Table playlists 2007-10-18 22:24:21.062 ERROR [1] Db Error: Syntax error in CREATE TABLE statement. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Saving Collection system 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Saving paths for Collection: system 2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: DB Error while saving collection paths: The Microsoft Jet database engine cannot find the input table or query 'CollectionPaths'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: DB error Saving : The Microsoft Jet database engine cannot find the input table or query 'collectionData'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:24:21.062 ERROR [1] MusicLibrary2: Error deleting unmatched paths: The Microsoft Jet database engine cannot find the input table or query 'CollectionPaths'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Exiting Timer initialisation, not needed. 2007-10-18 22:24:21.062 VERBOSE [1] Setting returned is False from: /settings/PluginSettings/MusicLibrary2/Audioscrobbler 2007-10-18 22:24:21.062 VERBOSE [1] Setting returned is False from: /settings/PluginSettings/MusicLibrary2/NoAllAll 2007-10-18 22:24:21.062 VERBOSE [1] Setting returned is False from: /settings/PluginSettings/MusicLibrary2/VerboseX2Logging 2007-10-18 22:24:21.062 VERBOSE [1] MusicLibrary2: Normal debug log level activated. 2007-10-18 22:24:21.062 VERBOSE [1] Setting returned is False from: /settings/PluginSettings/MusicLibrary2/MLLogging 2007-10-18 22:24:21.062 VERBOSE [1] Setting selected DB Connection type: System.Data.OleDb.OleDbFactory 2007-10-18 22:24:21.062 VERBOSE [1] Setting database type selected to MSAccess 2007-10-18 22:24:21.062 ERROR [1] DatabaseProviderFactory does not match DatabaseConnectionString Database type (filename) 2007-10-18 22:24:21.062 VERBOSE [1] Setting returned is .MP3~.WMA~.OGG~.M4A from: /settings/PluginSettings/MusicLibrary2/EXT 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Connecting to database 2007-10-18 22:25:21.718 INFO [1] MusicLibrary2: Using Access type database connection 2007-10-18 22:25:21.718 ERROR [1] MusicLibrary2: You have the wrong database table as it is missing fields. Download from the wiki 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Dropping Table collectionPaths 2007-10-18 22:25:21.718 ERROR [1] Db Error: Table 'collectionPaths' does not exist. 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Dropping Table collectionData 2007-10-18 22:25:21.718 ERROR [1] Db Error: Table 'collectionData' does not exist. 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Dropping Table MusicLibrary 2007-10-18 22:25:21.718 ERROR [1] Db Error: Table 'musiclibrary' does not exist. 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Dropping Table playlists 2007-10-18 22:25:21.718 ERROR [1] Db Error: Table 'playlists' does not exist. 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Dropping Table playlistdata 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Creating Table playlistdata 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Creating SQL-Lite Tables 2007-10-18 22:25:21.718 VERBOSE [1] MusicLibrary2: Creating Table Musiclibrary 2007-10-18 22:25:21.734 ERROR [1] Db Error: Syntax error in field definition. 2007-10-18 22:25:21.734 VERBOSE [1] MusicLibrary2: Creating Table collectionData 2007-10-18 22:25:21.734 ERROR [1] Db Error: Syntax error in field definition. 2007-10-18 22:25:21.734 VERBOSE [1] MusicLibrary2: Creating Table collectionPaths 2007-10-18 22:25:21.734 ERROR [1] Db Error: Syntax error in CREATE TABLE statement. 2007-10-18 22:25:21.734 VERBOSE [1] MusicLibrary2: Creating Table playlists 2007-10-18 22:25:21.734 ERROR [1] Db Error: Syntax error in CREATE TABLE statement. 2007-10-18 22:25:21.750 VERBOSE [1] MusicLibrary2: Saving Collection system 2007-10-18 22:25:21.750 VERBOSE [1] MusicLibrary2: Saving paths for Collection: system 2007-10-18 22:25:21.750 ERROR [1] MusicLibrary2: DB Error while saving collection paths: The Microsoft Jet database engine cannot find the input table or query 'CollectionPaths'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:25:21.750 ERROR [1] MusicLibrary2: DB error Saving : The Microsoft Jet database engine cannot find the input table or query 'collectionData'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:25:21.750 ERROR [1] MusicLibrary2: Error deleting unmatched paths: The Microsoft Jet database engine cannot find the input table or query 'CollectionPaths'. Make sure it exists and that its name is spelled correctly. 2007-10-18 22:25:23.171 INFO [1] Config is saving settings 2007-10-18 22:25:23.187 VERBOSE [1] getValue() loading new key/value into cache: /settings/PreferAlternatingCaptureSources 2007-10-18 22:25:23.187 VERBOSE [1] getValue: /settings/PreferAlternatingCaptureSources : false 2007-10-18 22:25:23.187 VERBOSE [1] About to connect to remote recording service 2007-10-18 22:25:23.187 VERBOSE [1] getValue() loading new key/value into cache:

[psycik]

hmm, for kicks, can you try the db3 instead of MGB database. I have not verified the use of the MDB database for a long time, and it wouldn't surprise me if I busted it.

Also your collections, if you've only got one for "All" then you don't need to create that one as by default ML2 creates a System collection which is the same as your all.

Also, config is only saved when you exit from the config app completely. Basically we update the XML file, and then with you exit the config application the xml file gets saved.

[monkey.eat(banana)]

right, so what you're telling me is that i could have saved myself the time it took to duplicate and write about the access problem by just using the db3 option? great :eek:

so, time to fix the mdb, or drop it completely

thanks for your time, and the great app!

[psycik]

If it works, and unless I hear otherwise I will probably look at dropping it - although I have a sneaking suspicion that someone may still be using it.