[solved] Sort by menuindex problem

Hi people,
I have a problem sorting by menuindex with Ditto ( and phx ). I try to sort DESC, but using both DESC or ASC, the result is the same order. All menuindex values are different, but the result is always the same order.

This is the line used ( page not cacheable ):


Any idea?

MySQL 5.0.51? If so, it’s a known bug in that version of MySQL.

Yes! I’ve tested it in the development server ( Mysql 5.0.90 ) and works fine. Can you tell me something else about this bug or send me a link to report it to the sysadmins for the mysql upgrade please?
Thanks for the fast response and for the solution.
EDIT: http://svn.modxcms.com/docs/display/revolution/MySQL+5.0.51+Issues

PS. Anybody knows why when we duplicate a document, the menuindex is the same, and why is not increased as if we create a new document? I know "duplicate" is "duplicate" but... why could we need to have a menuindex duplicated?

5.0.51 and 5.0.51a have several serious bugs and should have been upgraded long ago.