2011-09-05, 14:12
To cut a long story short, some time ago I modded the recently added script to include recently added music singles (yes i know its built in now,but not for music singles) & had some funky results which at thime I thought was down to my sql statements, found out it's down to xbmc's music DB.
Ok here's the problem.
My music singles are all tagged correctly & sit in folders A - Z then Sub folders for the artists. So from an empty DB the scan behaves like you would expect. eg. A-Ha would have IdSong, IdAlbum & IdArtist as 1 & lets say Zig & Zag being the last has IdSong, IdAlbum & IdArtist as 1000.
If i add a new artist & scan, everything is still ok eg. Dj Fresh will have IdSong, IdAlbum & IdArtist as 1001.
But if I add a new song by an artist thats already in the music DB it will add the new song ok, but change the song id's for the songs from that artist that are already in the DB! eg. if i added a new rihanna song, That shows up at the end say with IdSong 1002, but the other rihanna songs that were scanned in before which maybe had IdSong of 317 & 318 now have IdSong of 1003 & 1004. So its impossible to workout was was last added cos the song id's change.
Is this by design?
Sorry if its abit long winded!!
Thanks
Ok here's the problem.
My music singles are all tagged correctly & sit in folders A - Z then Sub folders for the artists. So from an empty DB the scan behaves like you would expect. eg. A-Ha would have IdSong, IdAlbum & IdArtist as 1 & lets say Zig & Zag being the last has IdSong, IdAlbum & IdArtist as 1000.
If i add a new artist & scan, everything is still ok eg. Dj Fresh will have IdSong, IdAlbum & IdArtist as 1001.
But if I add a new song by an artist thats already in the music DB it will add the new song ok, but change the song id's for the songs from that artist that are already in the DB! eg. if i added a new rihanna song, That shows up at the end say with IdSong 1002, but the other rihanna songs that were scanned in before which maybe had IdSong of 317 & 318 now have IdSong of 1003 & 1004. So its impossible to workout was was last added cos the song id's change.
Is this by design?
Sorry if its abit long winded!!
Thanks