sorting order in album view

[niavlys]

it seem a bug only when browsing an album with firefox (the bug did not occur with IE).
in the thumbnail display preference I set sorting order ascendent by name and 20 thumbnail by page
On the firts pages the image a sorted acendently

Code Select Expand

[22] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
                    WHERE ((aid = 20  ) OR (keywords like '%crozon%'  ))
                    ORDER BY title ASC
                     LIMIT 0 ,20 [include/functions.inc.php:1289] (2 ms)
the lasts pager of the same album are sorted descendently

Code Select Expand

[26] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
                    WHERE ((aid = 20  ) OR (keywords like '%crozon%'  ))
                    ORDER BY title DESC
                     LIMIT 22 ,20 [include/functions.inc.php:1289] (2 ms)

my album contains 120 but I can only see the first 80


my site : http://albums.moindron.net/thumbnails.php?album=20

[Joachim Müller]

I can't see how a query could change because you're using different browsers.

[niavlys]

I don't understand either
here is the request in IE

Code Select Expand

SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip FROM cpg15x_pictures AS r
                    WHERE ((aid = 20  ) OR (keywords like '%crozon%'  ))
                    ORDER BY filename ASC
                     LIMIT 0 ,20 [include/functions.inc.php:1289] (1 ms)


I think I understand how the select is done. Ascendent for the the first half and descendant for the second
I don't understand why in IE the order is on filename and on title in firefox ? is the sort index cached locally (I changed my parameter this morning)?

[niavlys]

I uploaded my images via FTP batch so they have no title which explain the bad sorting with firefox who use title sorting

[niavlys]

I deleted all my cookie and the problem disappeared.