Viewing disorder?

[seanspeng]

I found this issue a while back. I chose to display all galleries' photos by Author's Order. When I enter a gallery, all the thumbnails are displayed in Author's Order. However, if I click through all the photos in that gallery, the order is not in author's order.

This can be noted by going to a specific gallery, click on the last photo, then from the thumbnail on the top navigation, it shows this is not the last.

Is this a bug? I would like to see both in author's order.

Thank you!

[Pekka]

This is a known bug which is related to "Set optimization limit" setting in misc editor. It is caused by difference PHP and MySQL handles equal sorting criteria and can be fixed by selecting "Always sort and paginate using MySQL engine" in that selection.

[seanspeng]

Thanks! I have fixed it by what you suggested. Just for our knowledge, could you please let us know what difference it makes by using only mysql, or only php, or the mixed?

Thanks!