forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: niavlys on June 14, 2010, 11:54:27 am

Title: sorting order in album view
Post by: niavlys on June 14, 2010, 11:54:27 am

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]

[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]

[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 (http://albums.moindron.net/thumbnails.php?album=20)

Title: Re: sorting order in album view
Post by: Joachim Müller on June 14, 2010, 12:54:15 pm

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

Title: Re: sorting order in album view
Post by: niavlys on June 14, 2010, 01:08:09 pm

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

Code: [Select]

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)?

Title: Re: sorting order in album view
Post by: niavlys on June 14, 2010, 01:11:25 pm

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

Title: Re: sorting order in album view
Post by: niavlys on June 17, 2010, 08:15:17 am

I deleted all my cookie and the problem disappeared.