LibraryScanner have problems on load: QSqlError(-1, "Parameter count mismatch", "")

[raskolnikov]

When I start Mixxx (1.8 bzr rev 2573) I get hundreds of messages like this on the command line:
Debug: [LibraryScanner 1]: Updating directory status failed: QSqlError(-1, "Parameter count mismatch", "")

When the UI eventually shows up, I always get some folders re-scanned even though there are no changes in those folders.

[RJ Skerry-Ryan (rryan)]

Hey raskolnikov,

I saw this a couple days ago but I figured I had messed up my library. Albert made some changes in the library scanner recently that must have caused problems for pre-existing libraries. This is definitely a 1.8.0 blocker.

Thanks!
RJ

[RJ Skerry-Ryan (rryan)]

This is actually a super-easy fix. Albert added a new column to a database table but didn't flag the minimum required schema version as 5 so our databases aren't updating.

I just pushed a fix to the 1.8 branch.

[raskolnikov (raskolnikov)]

The error messages stop appearing when removing the old library library (which had been generated by 1.8 beta 2) but files keep being rescanned unneccesarily.

[RJ Skerry-Ryan (rryan)]

Hi raskolnikov,

Removing the old library is not necessary with my latest commits to the 1.8 branch.

How do you know which files are being scanned by Mixxx? Are you referring to the debug output?

You will likely see the scanner dialog going over every directory in your Library directory. This does not mean Mixxx is scanning new files, it is merely checking that nothing has changed in every directory of your Library. This is necessary on every startup of Mixxx to check for new files.

Regards,
RJ Ryan

[raskolnikov (raskolnikov)]

You are right, just checked and everything is working ok. Thanks for the fast fix.

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/5518