Ditto sorting order fix for MySQL 5.0.51

With the known grouping / sorting issues with the MySQL version 5.0.51 and a host who will not upgrade or downgrade the version, I am stuck with trying to find a resolution to this known issue.

All I would like is to have ditto feed in ascending order and that will be enough to resolve the current issue.

Can anyone help?

Thank you in advance.

Hi J-7,

hm...there’s one fix for Wayfinder -> http://modxcms.com/forums/index.php/topic,21972.msg139654.html#msg139654 so probably fixing Ditto too should be possible somehow - maybe
http://modxcms.com/forums/index.php/topic,25845.msg174343.html#msg174343

Hi Sharkbait ,

Thank you for that info.

With regards to the ditto snippet, if anyone has already implemented a work around and could provide me with an example I would be most appreciative.

Cheers

I fixed it by removing the ORDER BY clause in the snippet code. That can have unpleasant side effects but it didn’t in my case.

Another way is to create the documents in the order you want them to appear since that’s the order they end up in with 5.0.51.

Quote from: BobRay at Sep 22, 2009, 07:51 PM

I fixed it by removing the ORDER BY clause in the snippet code. That can have unpleasant side effects but it didn’t in my case.

Another way is to create the documents in the order you want them to appear since that’s the order they end up in with 5.0.51.

Where in the code did you remove the ORDER BY clause. What files?

Quote from: thorjarle at Apr 11, 2011, 03:53 AM

Quote from: BobRay at Sep 22, 2009, 07:51 PM

I fixed it by removing the ORDER BY clause in the snippet code. That can have unpleasant side effects but it didn’t in my case.

Another way is to create the documents in the order you want them to appear since that’s the order they end up in with 5.0.51.

Where in the code did you remove the ORDER BY clause. What files?

That post over a year old and 5.0.51 is now hopelessly out of date and known to be very bug-ridden. Really, updating from 5.0.51 is a much better solution. No one should be running it any more.