Menu Sort not working?

Hello peoples,

I have several MODx sites and one of them which is setup exactly the same as the others is having problems with the menu tree sort. I just upgraded this particular site to 0.9.6.2 to see if this would solve the problem but the menu sort won’t work no matter what option I set it too. I’m using a structured layout for my documents so it shows up the same in wayfinder

Main menu (13)
+ home (1)
+ sitemap (3)
Services (2)
+ hosting (4)
+ Web design (5)

for example... I want to have the main menu parent as my first option at the top of the menu but services is... I can understand why due to the ID of the document being created before the main menu one but using the tree sort should sort the list. I have tried using the menu index option as well... Main menu being 1 and services being 2 and that won’t help. AS I said, I have several sites using modX and I know how to use the sort but on one site it’s not working at all, no matter what settings I try.

I’m using php 5.25 and all the files that were upped were successfully transferred.

Any ideas what this could be?

Any help would be greatly appreciated.

Ross

Have you checked your database version? MySQL 5. something (I can never remember which version, but it’s in quite a lot of posts on the forums) has a bug that does this.

Hi Susan,

Thanks for the reply, according to my phpMyadmin it’s Server version: 5.0.51a-community

All my other MODx sites are using the same setup but the tree sort works... which is odd!

I’ll read up on what is said and see if there’s a way I can fix this.

Cheers, Ross

Well, that’s the buggy version all right. I think it’s related to this http://bugs.mysql.com/bug.php?id=36189

Which version would be the best to use with MODx? Just wondering why 3 sites are fine and 1 isn’t... all are hosted using the same exact setup. Is this a intermittent problem or should it of effected the other sites as well?

Ross

EDIT

Just emailed my host to see if they have plans to upgrade the Mysql version anytime soon. 5.1 is out so they should be keeping up with the times lol. No doubt they will say NO so i’ll be stuck with one tree that’s not working for a bit.

Another Edit

My host is looking in to the issue and will consider an upgrade after administrators check out the Mysql problems etc. I pointed them to the post you put up Susan so hopefully they start using at least 5.1!

:)

I am having the same issue, effecting 2 of my sites atm, but 3 are fine.
MySQL Version 5.0.32

Would I be better off backing up my DB and going to 4.0 MySQL?