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.