I've had this problem for a long time, since before 2.0 and possibly back a lot further.

Not sure if something is screwed up in my database or what.

Using Banshee 2.2.0 from PPA on Ubuntu Natty.

In my database the Uri fields in CoreTracks just have a , or & in them, they are not encoded as %2C and %26 respectively. Spaces are encoded as %20.

When I do a library re-scan it picks up these file names as new files or something and re-adds them to the database with the encoded characters in the Uri. So I end up with duplicate copies of all these tracks in the database.

I tried to fix the problem my self by running:

sqlite> UPDATE CoreTracks SET Uri = replace(Uri,',','%2C');
sqlite> UPDATE CoreTracks SET Uri = replace(Uri,'&','%26');

But the weird thing is Banshee converts these encoded characters back to , and & on a rescan and then still re-adds them!!

Has anyone else experienced this? I couldn't find a bug.