Sorting of user albums

[cellarius]

Some of my users do have a rather big number of user albums. If showing their user gallery, the user albums listed there do not show up in any order I can recognize.

Example:
Asterixinchen Galerie - Rom-Forum Fotogalerie

The albums are neither sorted alphabetically by album title nor chronologically (by catorder?). I do know about the possibility to change the album position by means of album admin, but should'nt they be in some order by default?


BTW, in my database, catorder value is set to 9999 for all albums. Is that correct?

[Chuck S]

The albums are in cronological order backwards newest displayed first all the way to oldest.

[cellarius]

No, they are not.

cat-nrs. from upper left to lower right:
682, 652, 650
648, 642, 635
632, 631, 626
616, 658, 659
680, 679, 678,
677, 676, 672

further down:
574, 607, 606


And they are not sorted by the newest foto in the album. See albums

- HAMBURG // 06.03.08 (second in the list)
last foto date: 6.3.2008

- Taufe des Römerschiffes - Hamburg (fourteenth in the list)
last foto date: 2.6.2008

[Chuck S]

well are any of those albums in that order sticky or sorted any other way. Actually albums are sorted bu catordered ascending order looking at it in showgallery.php this line.

Content visible to verified customers only.

[cellarius]

Originally Posted by Chuck S

well are any of those albums in that order sticky

no.

or sorted any other way.

How would that be? Please give an example.

Actually albums are sorted bu catordered ascending order looking at it in showgallery.php this line.

Content visible to verified customers only.

The line is there - but the albums are not sorted correctly.

[Chuck S]

They are sorted by catorder so if you ran the query above it will return the albums sorted by the catorder stored in your database for those entries.

Content visible to verified customers only.

This query is taken directly out of showgallery.php and is the one used if the category is 500