I'm using amarok 1.4.4 with amd64 gentoo and mysql 5.0.26-r2.  Lately I have been having lots of problems with the amarok collection and have had to delete my collection and rebuild it several times.  It often just loses my collection all together.  This happens to my friend using amarok with x86 kubuntu quite often too, and I'm not really wanting to spend a lot of time re-fixing amarok to get  it to read my collection database again.

I use mysql with amarok and amarok has started to constantly scan my collection. Once it finishes it just starts over again.  I'm not sharing the collection or doing anything fancy with it.  I looked at the "Configure Collection" dialog and amarok had changed my collection location from being the music folder (/mnt/music) to '/' (my entire system).  When I put a checkbox on just /mnt/music and push 'ok' the checked box is unchecked again when I go back to "Configure Collection". The unchecked checkbox does turn blue like it should be checked or something.  So currently nothing is checkmarked in "Configure Collection" dialog.

Amarok is compiled against the version of mysql I am using (5.0.26-r2).

Just a temporary "fix", uncheck "Watch folders for change".
Sorry I can' help.

Yea but that makes the collection even less useful than it already is, and you're right, disabling watch folders does stop it from scanning but it doesn't fix the problem.

Funny thing is on my x86_64 Kubuntu system, I had checked the watch checkbox against /media/music and then it unchecked it subsequently but it does scan for new music and updates the collection immediately. I added files ripped from my Jhonny Cash CD and it immediately showed up in the collection after a small update scan. I am running 1.4-SVN