Duplicate songs in music library

[dan_f14]

Hi I was hoping somebody could help me with a problem I seem to have with my music library on XBMC. The songs are not duplicated where they are stored and going through smb it is not duplicated, however in library mode it has duplicated several songs within the albums. I have tried rescanning the library without success. When I cleaned the library it did remove several duplicate songs in some of the albums but not all of them. So several albums still remain with duplicate songs. I have tried searching for the solution within the forum and on the wiki without much success other than what I have already tried. I was hoping somebody might know where the library file is stored in xbmc and whether deleting that and scanning the source fresh again would rectify the problem.

Thanks in advance
Dan

[sho]

Tried the manual?
http://xbmc.org/wiki/?title=The_XBMC_Database

[dan_f14]

Cheers. Problem solved :D Dunno how I missed that though :S

[jmarshall]

The reason is almost always due to having different paths in the db to the same file. eg a smb path with user/pass and a plain smb path without user path. XBMC doesn't know the difference between the two, so assumes two unique paths + thus unique files.

Cheers,
Jonathan