Option to remove duplicates in the music library database?

[menno]

Unfortunately my DB has a lot of duplicates, some records are in the library twice or even 4 times. All these entries refer to the exact same file.

Could there be an option made to remove duplicates (entries reffering to the exact same file) from the library?

[jmarshall]

They don't all refer to the same file at all I think you'll find.

Try looking in the actual db using something like sqlitespy, and you'll see they are in fact different.

In any case, yes, this is something I will be addressing with the video library redesign. Essentially the duplicates will need to be stacked down at display time, as there could be valid reasons for duplicates existing (eg you have multiple copies of the same movie, for different devices).

Cheers,
Jonathan

[menno]

I think the following happened;

All my music is on a samba share,
First time I added all my music on the samba share with a MANUAL username and password login....
I found this inconveniant to enter this info all the time, that i made samba login links in the sources config.
Than i rescanned my library (most important reason because first scan wasnt 100% done).
Now the database might think these are different samba locations.....
not sure ill investigate the DB further!

[ztripez]

why not do a "remove duplicates by checksum"? then the path would be irrelevant.

[jmarshall]

And which one should be removed exactly?