Bug 4879 - Wrong sort in database for "Greatest Hits" albums
: Wrong sort in database for "Greatest Hits" albums
Status: CLOSED DUPLICATE of bug 4361
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b2
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Spies Steven
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-03-31 01:53 UTC by Jens Boettiger
Modified: 2012-02-27 17:33 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jens Boettiger 2007-03-31 01:53:41 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'
Comment 1 Spies Steven 2007-04-02 10:32:55 UTC
This may be related to Bug 1704. Will investigate.
Comment 2 Spies Steven 2007-04-02 10:50:09 UTC
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?
Comment 3 Jens Boettiger 2007-04-02 23:21:12 UTC
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.
Comment 4 Jens Boettiger 2007-04-03 09:11:33 UTC
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'
Comment 5 KDF 2007-05-18 11:26:52 UTC
Steven, would it be appropriate to dupe this with bug 4361?
Comment 6 Chris Owens 2007-12-10 09:37:04 UTC
Ping Steven :)
Comment 7 Blackketter Dean 2007-12-17 09:35:21 UTC
ping, steven
Comment 8 Spies Steven 2007-12-17 10:44:04 UTC
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 ***
Comment 9 James Richardson 2012-02-27 17:33:23 UTC
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.