PDA

View Full Version : Albums sortorder *very* mysterious



GoodVibrations
2008-02-17, 03:10
Hi,

I'm pretty new to SS.
I'm in the process of ripping my 2500 cd's.
Yesterday I finally managed to get compilations to work.

But I have a very mysterious problem with the sortorder when browsing albums by name.

I can't see any kind of system to it.

SlimServer Version: 6.5.4 - 12568 - Debian - EN - iso-8859-1
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.51-3

Below are some screenshots.

What is the sortorder here?
P
C
A
G
T
P
....
Notice "The Pet Sounds Sessions" 1 & 3, not being next to each other...

Also notice entry no. 3 " Alle Tiders Clausen..." is also entry no. 423!!

At entry no. 3 it list 17 of the 21 songs on the album.
At entry no. 423 the last 4 songs are listed.
All 21 songs are in the same directory btw.
I've shown the tags for two of the songs. Track 1 being listed in the album entry no. 423 and track 2 being listed in album no. 3!

Sorting by "year,album" shows exactly the same order!
Sorting by "year,artist,album" also dosen't work.

Sorting by "artist,album" & "artist,year,album" works fine.

I cleared the cache last night and did a new scan (to get compilations to work). But the album listening didn't work before and it dosen't work now either.

I have never gotten "clear library and rescan everything" to work. It just dosen't do anything. I don't know why. So I always clears the cache manually when doing major changes.
Don't know if this problem is in any way connected to my sorting problem?

I'm quite baffled by this.

GoodVibrations
2008-02-17, 03:26
Just noticed that for some reason I haven't gotten "0" in front off all the single digit tracks on the album. I'll fix that.

But still, the 4 tracks listed as album no. 423 are tracks no. 1, 10, 13 & 17.

So that's shouldn't be the problem with the album in question.

And it still dosen't answer why the sort-order is out of whack.

Pet Sound Sessions 1 & 3 have all the track numberede 01, 02, 03...

max.spicer
2008-02-17, 03:43
I have a very mysterious problem with the sortorder when browsing albums by name.

Sounds like you've hit the same problem I'm getting. No solution as yet, I'm afraid. http://bugs.slimdevices.com/show_bug.cgi?id=7035

Max

max.spicer
2008-02-17, 07:10
Sounds like you've hit the same problem I'm getting. No solution as yet, I'm afraid. http://bugs.slimdevices.com/show_bug.cgi?id=7035

Max

I think this is actually a MySQL bug. http://bugs.mysql.com/bug.php?id=32202

Max

GoodVibrations
2008-02-17, 08:42
I'm fine with that.

Thank you for your answers.

I can then go on with the ripping and tagging, knowing that that's not the cause of the strange sorting, and hope that the bugs will be fixed in a later update.

bhaagensen
2008-02-17, 10:15
I think a workaround in SqueezeCenter is necessary here. It is a major pain to browse the music library with artist/album/genres appearing randomly.

Edit: Added a comment to the

http://bugs.slimdevices.com/show_bug.cgi?id=7035

I'm seeing some strange things artist orderings. The metadata below is from track for which the artist apears under 'D' in browse artist.


vendor string: reference libFLAC 1.1.4 20070213
comments: 18
comment[0]: album=Enter
comment[1]: asin=B00005R1RV
comment[2]: albumartistsort=Swan Lee
comment[3]: musicbrainz_artistid=330a8e2c-ce16-4df8-97bc-3f6b7fca4704
comment[4]: title=Flowers in the Wintertime
comment[5]: artist=Swan Lee
comment[6]: releasetype=album
comment[7]: releasecountry=XU
comment[8]: musicbrainz_albumid=60c634cb-e652-4801-b171-c61e62e9a77d
comment[9]: releasestatus=official
comment[10]: totaltracks=10
comment[11]: albumartist=Swan Lee
comment[12]: musicbrainz_albumartistid=330a8e2c-ce16-4df8-97bc-3f6b7fca4704
comment[13]: genre=Danish, Britpop, Female Vocalists, Pop, Scandinavian, 00S, Rock
comment[14]: date=2001
comment[15]: tracknumber=1
comment[16]: artistsort=Swan Lee
comment[17]: musicbrainz_trackid=09300d70-0222-408c-8c46-84f8efbacd39

GoodVibrations
2008-02-17, 11:14
Commented on the bugreport.

Well my genre sort is also wrong. Never use it, so I hadn't noticed it before.

Luckily my artist sort works. For now... ;-)

Looks like we all 3 use Debian/Debian-based distros. A clue perhaps?

I'm building a new pc next week, for Squeeze.
When I move my music to it, I think I'll pull MySQL from sid (5.0.51a-1) to see if that makes a difference, sorting wise.

GoodVibrations
2008-02-17, 11:21
When I move my music to it, I think I'll pull MySQL from sid (5.0.51a-1) to see if that makes a difference, sorting wise.

Well, not:

"Noted in 5.0.52, 5.1.23, 6.0.4 changelogs.
Under certain conditions, the presence of a GROUP BY clause could
cause an ORDER BY clause to be ignored."

I'll wait untill 5.0.52 hits unstable then.

kdf
2008-02-17, 12:35
On 17-Feb-08, at 2:43 AM, max.spicer wrote:

>
> GoodVibrations;270293 Wrote:
>> I have a very mysterious problem with the sortorder when browsing
>> albums
>> by name.
>
> Sounds like you've hit the same problem I'm getting. No solution as
> yet, I'm afraid. http://bugs.slimdevices.com/show_bug.cgi?id=7035

notice the pattern of mysql 5.0.51?
-kdf

JJZolx
2008-02-18, 17:10
Just noticed that for some reason I haven't gotten "0" in front off all the single digit tracks on the album. I'll fix that.

This isn't necessary in the tracknumber tags - in fact I generally force tracknumbers to not have the leading zero. However, it's a very good idea in file names so that simply listing or browsing the folder in your operating system will show the tracks in the original order.

andyg
2008-02-18, 18:28
We're not going to workaround an already-fixed MySQL bug.

egd
2008-02-18, 18:36
This isn't necessary in the tracknumber tags - in fact I generally force tracknumbers to not have the leading zero. However, it's a very good idea in file names so that simply listing or browsing the folder in your operating system will show the tracks in the original order.mp3tag does a great job taking care of both for you and can do renumbering across multiple folders in a single operation, resetting the counter on each folder change. The key thing is to make sure your tracks are sorted correctly before applying.