inconsistant sort order

[stevehof]

Hi,

I just noticed that when I view a photo by clicking a microthumb on the 'homepage' and then go to the exhibition browser from the link in the header or footer on the photo page my default sort order selection of 'author's order' is not honored. Exhibition browser opens with 'publish order' instead. This only happens when going to a photo page from the microthumbs on the homepage. Is this a bug or am I missing something in my set up?

Thanks, Steve

http://www.sphoto.com

[seanspeng]

It is a bug due to the difference that mysql and php handles the queries. In Misc Setting, set optimization limit to "Always sort and paginate using mysql engine" and that should solves most of the problem. Although you may still find disorder if you click on the center " to Exhibition browser" in multiarea navigation.

[stevehof]

Sean,

Thanks for the info. I don't see an option in the miscellaneous settings editor to set optimization limit for 'always sort and paginate using MYsql engine'. Is this option available in EE 1.22?

[seanspeng]

This is in 1.3. But I remember 1.22 has similar option, like using sql over 250 photos, etc? Not sure. I would go ahead and upgrade to 1.3 and you will see significant speed improvement. In my case, it's four times faster!

[stevehof]

Sean,

Thanks for all the help! I don't have time to do the upgrade and associated PHP editing right now. So, since I'm only running ONE public exibhition, I just hard coded the link on the photo page instead of letting mysql sort it out...

Cheers,