After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 632112 - Banshee adds duplicate entries to the library when importing
Banshee adds duplicate entries to the library when importing
Status: RESOLVED DUPLICATE of bug 623441
Product: banshee
Classification: Other
Component: Importing
1.8.0
Other Linux
: Normal normal
: 1.x
Assigned To: Banshee Maintainers
Banshee Maintainers
Depends on:
Blocks:
 
 
Reported: 2010-10-14 01:07 UTC by Alex L. Mauer
Modified: 2010-10-14 02:52 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Alex L. Mauer 2010-10-14 01:07:05 UTC 
For me, using Media→Import Media… and selecting “Folders” will cause Banshee to add large quantities of duplicate tracks to the media library:

sqlite> select count(uri) from CoreTracks;
15653
sqlite> select count(distinct uri) from CoreTracks;
13784

(number of dupes continues to grow if I re-import repeatedly.)

I removed the dupes manually and added a unique index to the uri field.  Now I get the output like at http://pastebin.com/yEKhX9K4 for each file that it tries to import.
Comment 1 Alex L. Mauer 2010-10-14 01:25:13 UTC 
Looking at the output I see that the query for an already existing track URL-encodes the comma.  However, the insert does not.  This of course means that it will continue to try to insert the track with a comma over and over and over.

Obviously the solution is to normalize the uri format…

Also, it would probably be a good idea to add a unique constraint on the uri field to prevent similar problems.
Comment 2 Michael Martin-Smucker 2010-10-14 02:52:29 UTC 
Thanks for the report.  This sounds a lot like Bug 623441, so I'm closing it as a duplicate.  Feel free to reopen if I'm wrong.

*** This bug has been marked as a duplicate of bug 623441 ***