Incorrect sorting

Hello,

Just notice that one of my modx sites is sorting incorrectly the menus (in administration manager) and in the front end (using wayfinder). it uses the object id instead of the menuindex. Some weeks ago it was working... I tried to clear cache, etc.

So, I’ve updated the 0.9.5 install to the new 0.9.6.1, but the incorrect sorting is still occurring. I also have tried to change the &sortBy in the Wayfinder code, but even changing to "random" it always sort by object id.

The only explanation I have is that the MySQL Server was updated some weeks ago from 4.1 to 5.0.51. I’ve been looking in the forum, but just found some comments about incorrect sorting at MySQL 4.1.21

Any idea?

Make sure your database collation is correct and supported in the new configuration. The collation determines how rows are sorted.