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 569379 - Syncing removes and then adds the same files every time
Syncing removes and then adds the same files every time
Status: RESOLVED FIXED
Product: banshee
Classification: Other
Component: general
git master
Other Linux
: High normal
: 1.x
Assigned To: Banshee Maintainers
Banshee Maintainers
: 573219 573683 (view as bug list)
Depends on: 528493
Blocks:
 
 
Reported: 2009-01-27 19:24 UTC by Gabriel Burt
Modified: 2009-03-20 03:41 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Gabriel Burt 2009-01-27 19:24:13 UTC 
There is a bug with syncing such that it removes some files from the device, then adds them back every time.

This must be because the MetadataHash (calculated from AlbumTitle, ArtistName, (int)Duration.TotalSeconds, Genre, TrackTitle, TrackNumber, Year) is not equal between the track on the device and in the Library.

I need somebody that sees this problem to
1) identify a song that this is happening on
2) find it in the music library, right click on it -> Edit Track Information, write down all the values above (AlbumTitle, etc)
3) find it on the device (within Banshee) and do the same as 2)
4) report the info here
Comment 1 Gabriel Burt 2009-02-05 17:18:50 UTC 
OK, I was able to reproduce and track down the root cause.

The MetadataHash seems to be incorrectly calculated for songs w/ "Unknown Artist/Album" when they are first imported.  I think this best way to fix this would be to replace our current MetadataHash calcualtion with a custom Sqlite funciton that runs on insert/update, like this:

UPDATE CoreTracks SET MetadataHash = BANSHEE_CALC_METADATAHASH(..)
Comment 2 Gabriel Burt 2009-03-01 22:16:34 UTC 
*** Bug 573219 has been marked as a duplicate of this bug. ***
Comment 3 Gabriel Burt 2009-03-01 22:16:40 UTC 
*** Bug 573683 has been marked as a duplicate of this bug. ***
Comment 4 Andrés G. Aragoneses (IRC: knocte) 2009-03-01 22:34:59 UTC 
FYI: The patch for bug 528493 fixes this bug as well.
Comment 5 Andrés G. Aragoneses (IRC: knocte) 2009-03-20 03:13:00 UTC 
The patch for bug 528493 was committed so this should be marked FIXED as well. Thanks!
Comment 6 Gabriel Burt 2009-03-20 03:41:34 UTC 
Fixed it for newly imported tracks, but not for tracks already in your library.  I committed a migration to regenerate the MetadataHash for tracks with unknown artist/album/title.  Fixed in my testing!