Tracks duplicated on import

[arkeine]

Hi,

On every importation, I get duplicated entries in data base.

I take a look here #122 and here #129 but it's not exactly the same problem.

I never removed files, I just add new files and import them. The importation end successfully, but when I run this script on the data base, I can see multiple entries for the same song:

SELECT track_number,title,album,COUNT(*) FROM sonerezh.songs G ROUP BY track_number,title,album HAVING COUNT(*) > 1;

So, I remove these links manualy with another script. Is it only me who have this bug?

PS: The clean script:

DELETE sonerezh.songs FROM sonerezh.songs LEFT OUTER JOIN ( SELECT MIN(id) as id, track_number,title,album FROM sonerezh.songs GROUP BY track_number,title,album ) as KeepRows ON sonerezh.songs.id = KeepRows.id WHERE KeepRows.id IS NULL;

[MightyCreak]

I also have duplicated tracks in the same album although I verified I only have the file once in all of my library.

[lGuillaume124]

Hi,

What version of Sonerezh do you use?

[MightyCreak]

The latest one: v1.1.1

[lGuillaume124]

Could you send us one or more tracks please?

[MightyCreak]

I'll email it to you.

Edit: As I'm looking at the data, I remarked that I have 960 tracks and 9 duplicates. Is it possible that you are browsing 100 tracks at a time and that each batch includes the last track of the previous batch?

[arkeine]

I'm also using the last version v1.1.1.

I will send to you a sample of song which are duplicated (link). I have not the time now, but I will check if I remarke the same correlation that @MightyCreak said.

[arkeine]

I try to reset my db and import again.

I have now 2477 songs and, as MightyCreak said, I got 24 duplicated tracks. The duplicated tracks aren't the same than before.

[MightyCreak]

Could it be possible flag this issue as Bug and in priority High? Because it quite is ;)

[MightyCreak]

Is the bug fixed? I haven't seen a fix for it in the development branch.