Bugzilla – Bug 3710
Still some Album sort issues
Last modified: 2008-09-15 14:39:24 UTC
It seems to have something to do with partial matches. Some examples: "Awake" is after "Awake Is The New Sleep" "Beat" is after "Beat Happening" "Blood" is after "Blood Money" and "Blood Sugar Sex Magik" "Bring It On" is after "Bring It On Home, Vol. 2" "Dig" is after "Dig Your Own Hole" etc. Another thing that may or not be considered a bug is the sorting of titles that start with numbers: SlimServer Sort --------------------------------------------- 000 (2000) by The Delta 72 0898 (1992) by The Beautiful South 1 (1970) by The Beatles 100% Fun (1995) by Sweet, Matthew 12 Memories (2003) by Travis 14 Songs (1993) by Westerberg, Paul 18 (2002) by Moby 3..6..9 Seconds Of Light (1997) by Belle & Sebastian 60 Watt Silver Lining (1996) by Eitzel, Mark 700 Miles (1992) by 700 Miles 99.9 F� (1992) by Vega, Suzanne versus iTunes Sort --------------------------------------------- 000 1 3..6..9 Seconds Of Light 12 Memories 14 Songs 18 60 Watt Silver Lining 99.9 F� 100% Fun 0898 I certainly prefer the way that SlimServer ignores leading punctuation. In iTunes my first album is "...Finally"
Evan - this should be better/fixed in the latest nightly.
Running SlimServer Version: 6.5b1 - 8394 - Mac OS X 10.4.7 (8J2135) - EN - utf8 Did a clear and rescan - no change in order on SB or web interface. Looks fine in the database. mysql> select * from albums where title like "Awake%"; +------+------------------------+------------------------+------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | id | title | titlesort | titlesearch | customsearch | contributor | compilation | year | artwork | disc | discc | replay_gain | replay_peak | musicbrainz_id | musicmagic_mixable | +------+------------------------+------------------------+------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | 450 | Awake | AWAKE | AWAKE | NULL | 1535 | 0 | 2001 | 6118 | 1 | 1 | NULL | NULL | NULL | NULL | | 1559 | Awake Is The New Sleep | AWAKE IS THE NEW SLEEP | AWAKE IS THE NEW SLEEP | NULL | 8184 | NULL | 2005 | 22996 | 1 | 1 | NULL | NULL | NULL | NULL | +------+------------------------+------------------------+------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ 2 rows in set (0.04 sec) mysql> select * from albums where title like "Blood%"; +-----+-----------------------+-----------------------+-----------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | id | title | titlesort | titlesearch | customsearch | contributor | compilation | year | artwork | disc | discc | replay_gain | replay_peak | musicbrainz_id | musicmagic_mixable | +-----+-----------------------+-----------------------+-----------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | 759 | Blood | BLOOD | BLOOD | NULL | 2358 | 0 | 1991 | 10427 | 3 | 4 | NULL | NULL | NULL | NULL | | 846 | Blood Money | BLOOD MONEY | BLOOD MONEY | NULL | 1171 | 0 | 2002 | 11543 | 1 | 1 | NULL | NULL | NULL | NULL | | 620 | Blood Sugar Sex Magik | BLOOD SUGAR SEX MAGIK | BLOOD SUGAR SEX MAGIK | NULL | 1977 | 0 | 1991 | 8351 | 1 | 1 | NULL | NULL | NULL | NULL | | 619 | Bloodline | BLOODLINE | BLOODLINE | NULL | 1971 | 0 | 1992 | 8344 | 1 | 1 | NULL | NULL | NULL | NULL | +-----+-----------------------+-----------------------+-----------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ 4 rows in set (0.00 sec) mysql> select * from albums where title like "Bring%"; +------+---------------------------+---------------------------+---------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | id | title | titlesort | titlesearch | customsearch | contributor | compilation | year | artwork | disc | discc | replay_gain | replay_peak | musicbrainz_id | musicmagic_mixable | +------+---------------------------+---------------------------+---------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | 1400 | Bring It On | BRING IT ON | BRING IT ON | NULL | 6254 | 0 | 1998 | 20834 | 1 | 1 | NULL | NULL | NULL | NULL | | 1069 | Bring It On Home, Vol. 2 | BRING IT ON HOME VOL 2 | BRING IT ON HOME VOL 2 | NULL | 5474 | 1 | 1994 | 15456 | NULL | NULL | NULL | NULL | NULL | NULL | | 672 | Bring On The Night [Live] | BRING ON THE NIGHT [LIVE] | BRING ON THE NIGHT [LIVE] | NULL | 2112 | 0 | 1986 | 8974 | 2 | 2 | NULL | NULL | NULL | NULL | | 196 | Bringing It All Back Home | BRINGING IT ALL BACK HOME | BRINGING IT ALL BACK HOME | NULL | 402 | 0 | 1965 | 2525 | 1 | 1 | NULL | NULL | NULL | NULL | +------+---------------------------+---------------------------+---------------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ 4 rows in set (0.01 sec) mysql> select * from albums where title like "Dig%"; +-----+-------------------+-------------------+-------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | id | title | titlesort | titlesearch | customsearch | contributor | compilation | year | artwork | disc | discc | replay_gain | replay_peak | musicbrainz_id | musicmagic_mixable | +-----+-------------------+-------------------+-------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ | 635 | Dig | DIG | DIG | NULL | 2003 | 0 | 2001 | 8524 | 1 | 1 | NULL | NULL | NULL | NULL | | 44 | Dig Your Own Hole | DIG YOUR OWN HOLE | DIG YOUR OWN HOLE | NULL | 134 | 0 | 1997 | 541 | 1 | 1 | NULL | NULL | NULL | NULL | +-----+-------------------+-------------------+-------------------+--------------+-------------+-------------+------+---------+------+-------+-------------+-------------+----------------+--------------------+ 2 rows in set (0.00 sec)
Fixed the Dig / Dig Your Own Hole issue. The numeric sort is just the way it is. Fixed in change 8504