Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: sorting order in album view  (Read 2492 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.015 seconds with 19 queries.