Comment 7 for bug 112984

duh, i meant SQLite, not mysql ....

just deleted the .kde/share/apps/amarok/collection* files too and am rescanning to see if it works. (reticking which folders have the files i want...)
I confirm the changing of db engine to force a rescan didn't fix it, the original file must have remained...

will tell you if this is a lasting fix