Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: sorting order in album view  (Read 3132 times)

0 Members and 1 Guest are viewing this topic.

niavlys

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
sorting order in album view
« 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


Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: sorting order in album view
« Reply #1 on: June 14, 2010, 12:54:15 pm »

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

niavlys

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: sorting order in album view
« Reply #2 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)?
Logged

niavlys

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: sorting order in album view
« Reply #3 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
Logged

niavlys

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: sorting order in album view
« Reply #4 on: June 17, 2010, 08:15:17 am »

I deleted all my cookie and the problem disappeared.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.