Bugzilla – Bug 4879
Wrong sort in database for "Greatest Hits" albums
Last modified: 2012-02-27 17:33:23 UTC
SlimServer Version: 6.5.2 - 11692 - Windows XP - EN - cp1252 Client Player Firmware Version: 80 If you have more then one album with the titel "Greatest Hits", this albums will be sortet wrong in database. E.g. if you have the "Greatest Hits" from Vangelis and from Suzi Quatro and you show under Suzi Quatro - Greatest Hits you will get all albums with the titel "Greatest Hits" (go to Playlist - Suzi Quatro "Greatest Hits", select a titel and then in the information klick the album titel - the upcomming list are wrong for Suzi Quatro). The same is if you search for "Greatest Hits" in 'Search' or 'Advance Search'. I meade a logfile and found the first album with "Greatest Hits" will be get a owne id, but all other with different Artists will get the same id! 2007-03-31 09:45:07.9468 newTrack(): Created track 'To The Unknown Man' (id: [3524]) 2007-03-31 09:45:07.9471 -- Track is a local track 2007-03-31 09:45:07.9505 -- Track has genre 'Electronic' 2007-03-31 09:45:07.9542 -- Track has contributor 'Vangelis' of role 'ARTIST' 2007-03-31 09:45:07.9543 -- Track has 1 contributor(s) 2007-03-31 09:45:07.9545 -- Track primary contributor is 'Vangelis' (id: [333]) 2007-03-31 09:45:07.9547 -- Checking for discs 2007-03-31 09:45:07.9588 -- Searching for an album with: 2007-03-31 09:45:07.9591 --- me.title : "Greatest Hits" 2007-03-31 09:45:07.9602 -- Created album 'Greatest Hits' (id: [245]) 2007-03-31 09:45:07.9617 -- Updating album 'Greatest Hits' (id: [245]) with columns: 2007-03-31 09:45:07.9618 --- discc : 01 2007-03-31 09:45:07.9620 --- titlesort : GREATEST HITS 2007-03-31 09:45:07.9621 --- titlesearch : GREATEST HITS 2007-03-31 09:45:07.9622 --- disc : 01 2007-03-31 09:45:07.9623 --- year : 1991 2007-03-31 09:45:07.9624 --- contributor : 333 2007-03-31 09:45:07.9629 -- Track has album 'Greatest Hits' (id: [245]) 2007-03-31 09:45:07.9676 -- Contributor 'Vangelis' (id: [333]) linked to album 'Greatest Hits' (id: [245]) with role: 'ARTIST' 2007-03-31 09:47:55.9218 newTrack(): Created track '48 Crash' (id: [6689]) 2007-03-31 09:47:55.9221 -- Track is a local track 2007-03-31 09:47:55.9259 -- Track has genre 'Rock' 2007-03-31 09:47:55.9307 -- Track has contributor 'Suzi Quatro' of role 'ARTIST' 2007-03-31 09:47:55.9308 -- Track has 1 contributor(s) 2007-03-31 09:47:55.9310 -- Track primary contributor is 'Suzi Quatro' (id: [924]) 2007-03-31 09:47:55.9312 -- Checking for discs 2007-03-31 09:47:55.9358 -- Searching for an album with: 2007-03-31 09:47:55.9361 --- me.title : "Greatest Hits" 2007-03-31 09:47:55.9363 -- Found the album id: [245] 2007-03-31 09:47:55.9376 -- Updating album 'Greatest Hits' (id: [245]) with columns: 2007-03-31 09:47:55.9377 --- discc : 1 2007-03-31 09:47:55.9378 --- titlesort : GREATEST HITS 2007-03-31 09:47:55.9379 --- titlesearch : GREATEST HITS 2007-03-31 09:47:55.9380 --- disc : 01 2007-03-31 09:47:55.9381 --- year : 1973 2007-03-31 09:47:55.9382 --- contributor : 924 2007-03-31 09:47:55.9386 -- Track has album 'Greatest Hits' (id: [245]) 2007-03-31 09:47:55.9430 -- Contributor 'Suzi Quatro' (id: [924]) linked to album 'Greatest Hits' (id: [245]) with role: 'ARTIST'
This may be related to Bug 1704. Will investigate.
Actually this looks more like Bug 4361. Jens, it appears that the files in question have disc number tags. Would you try removing the disc and discc tags temporarily from the files in question and see if you get the same behavior?
Yes, all files have disc and discc tags (ALL files on my disc have the count 1 in disc and discc). I will try to remove it this eventing and report the result.
After removing DISC and DISCC, one Artist is fine (Suzi Quatro in this case), but the next artist will have the same problem (see below). I don't want to remove all DISC and DISCC tags from my flac files. I cannot see why DISC and DISCC should have an impact on the database entry for ARTIST - ALBUM 2007-04-03 17:30:34.7869 newTrack(): Created track 'To The Unknown Man' (id: [3524]) 2007-04-03 17:30:34.7872 -- Track is a local track 2007-04-03 17:30:34.7915 -- Track has genre 'Electronic' 2007-04-03 17:30:34.7953 -- Track has contributor 'Vangelis' of role 'ARTIST' 2007-04-03 17:30:34.7954 -- Track has 1 contributor(s) 2007-04-03 17:30:34.7956 -- Track primary contributor is 'Vangelis' (id: [333]) 2007-04-03 17:30:34.7958 -- Checking for discs 2007-04-03 17:30:34.8009 -- Searching for an album with: 2007-04-03 17:30:34.8013 --- tracks.url : { like => "file:///M:/Audio/Electronic%" } 2007-04-03 17:30:34.8015 --- me.disc : undef 2007-04-03 17:30:34.8016 --- me.title : "Greatest Hits" 2007-04-03 17:30:34.8017 --- me.discc : undef 2007-04-03 17:30:34.8029 -- Created album 'Greatest Hits' (id: [245]) 2007-04-03 17:30:34.8044 -- Updating album 'Greatest Hits' (id: [245]) with columns: 2007-04-03 17:30:34.8045 --- titlesort : GREATEST HITS 2007-04-03 17:30:34.8046 --- titlesearch : GREATEST HITS 2007-04-03 17:30:34.8047 --- year : 1991 2007-04-03 17:30:34.8048 --- contributor : 333 2007-04-03 17:30:34.8052 -- Track has album 'Greatest Hits' (id: [245]) 2007-04-03 17:30:34.8090 -- Contributor 'Vangelis' (id: [333]) linked to album 'Greatest Hits' (id: [245]) with role: 'ARTIST' 2007-04-03 17:34:38.9182 newTrack(): Created track 'Old Before I Die' (id: [8157]) 2007-04-03 17:34:38.9185 -- Track is a local track 2007-04-03 17:34:38.9220 -- Track has genre 'Rock' 2007-04-03 17:34:38.9257 -- Track has contributor 'Robbie Williams' of role 'ARTIST' 2007-04-03 17:34:38.9258 -- Track has 1 contributor(s) 2007-04-03 17:34:38.9260 -- Track primary contributor is 'Robbie Williams' (id: [157]) 2007-04-03 17:34:38.9262 -- Checking for discs 2007-04-03 17:34:38.9306 -- Searching for an album with: 2007-04-03 17:34:38.9308 --- me.title : "Greatest Hits" 2007-04-03 17:34:38.9310 -- Found the album id: [245] 2007-04-03 17:34:38.9324 -- Updating album 'Greatest Hits' (id: [245]) with columns: 2007-04-03 17:34:38.9325 --- discc : 01 2007-04-03 17:34:38.9326 --- titlesort : GREATEST HITS 2007-04-03 17:34:38.9327 --- titlesearch : GREATEST HITS 2007-04-03 17:34:38.9327 --- disc : 01 2007-04-03 17:34:38.9328 --- year : 2004 2007-04-03 17:34:38.9329 --- contributor : 157 2007-04-03 17:34:38.9334 -- Track has album 'Greatest Hits' (id: [245]) 2007-04-03 17:34:38.9373 -- Contributor 'Robbie Williams' (id: [157]) linked to album 'Greatest Hits' (id: [245]) with role: 'ARTIST'
Steven, would it be appropriate to dupe this with bug 4361?
Ping Steven :)
ping, steven
I'm thinking that this is the same as bug 4361. However I noted in that bug that just having a DISC tag present will change the behavior. Perhaps the description should be changed. Please reopen if this behavior persists after bug 4361 is fixed. *** This bug has been marked as a duplicate of 4361 ***
Closing resolved bugs - if you feel this bug still exists please first re-test with the latest SW/FW version. If you are able to reproduce then feel free to reopen and attach new logs / steps to reproduce.