Can't change menu item order *in backend*

[[n]atalie]

I've found a lot posted about problems changing menu item ordering in Joomla 1.6, but it all appears to either be that they can change them in the backend but the changes don't appear in the frontend (a cache issue I think) or that they're not clicking on the Ordering heading.

If I repeatedly click on the blue arrows every time the page refreshes, about 1 in every 5 times the menu item actually moves. This is frustrating, but I thought it was working. I can't change menu order by typing in the numbers. When I press the save button it looks like it worked and it says "Ordering successfully saved." but either nothing happened.

Then eventually after doing this for a while all of the menu items will spontaneously go back to one order that I never set but they keep changing to.

It's incredibly frustrating and I need to change this menu order asap.

Can anyone offer any suggestions? I am fairly new to Joomla, and this is only the second site I've done in 1.6.

[dylanjh]

Have you tried site->maintenance->clear cache?

[[n]atalie]

Yeah, that was one of the first things I did...

[rbuelund]

I've got the exact same problem - but also had it in Joomla 1.5.23 (a site upgraded from 1.0.15) - and now upgraded tp 1.7 - is it a upgrade thing ?

[infograf768]

Have you tried "rebuild" for the menu concerned?

[rbuelund]

Yes I have - the problem is still there.

[jpreville]

Same issue here. with Joomla 1.7.0

Only way around it seems to edit the jos_menu db table ordering field manually. in the order you want. its like the save button is not updating the database or something.

John

[rbuelund]

Infograf and I seem to have found the problem! It is a problem with JUpgrade - the column "ordering" in table "_menu" is filled with different numbers - it should be just zero's as the ordering of the menu items is drawn from the columns "lgt" and "rgt".

Use this in phpMyAdmin to correct the issue: UPDATE `your db name`.`your table prefix_menu` SET `ordering` = '0'

[[n]atalie]

Sorry, I don't understand exactly what you did. Could you explain it again?

[rbuelund]

You have to alter the column "ordering" in table "_menu" in your database and set the value to zero for all rows.

[rbuelund]

You can use this little "component" to place zero's in your ordering column in "_menu"
Just uninstall afterwards. (Only for J!1.7)

[maguirre]

Thanks for reporting this. This bug will be fixed in the next version of jUpgrade 1.2.0

Take care

[infograf768]

Thanks maguirre

[[n]atalie]

Thank you everyone.

[bop]

I have seen this in 1.7 version also and i have found that if you try and push a menu item up the tree structure it doesn't work. BUT if you push the menu's in the downward direction it does. It is an odd bug i believe, but you can move them, just have to think about how you are going to get them all where you want them by only moving them down. Make sure you save when you are done then clean out your cache.

I hope this helps someone get themselves out of situation. Hopefully this is fixed soon.

[TomT]

You can use this little "component" to place zero's in your ordering column in "_menu"
Just uninstall afterwards. (Only for J!1.7)

This works for me, thanks a lot

[parkingkarma]

I'm bumping this thread up because we were fighting with this problem for weeks, and the restoreorderingcolum.zip file that's attached lower in this thread was the fix for us too! (even though we didn't use jUpgrade ...

This fix needs to be made known to all users of 1.6/1.7 because it is so frustrating to battle something like this when a fix is available ....

We installed the Drag n Drop Admin extension (http://extensions.joomla.org/extensions ... tion/14389) and now that Joomla will actually save the new positions, everything is great!

Thanks a ton to rbuelund for making this fix available, and please get this fixed asap in the next Joomla update, as this is a pretty critical one.

Cheers,

PK

[1soul]

Worked like a charm! I have been having this problem for awhile now with 1.7. Since this seems to be a live thread perhaps I can inquire if anyone else has been having problems with FB login not responding and/or any paypal buttons simply refreshing the same page without redirecting member to paypal? Anyone...

[1soul]

As far as the FB login, it seems to work fine through the register page. The only place where it doesn't seem to work is trying to use it through the "Hello Me" module. Any ideas...

[wmys]

Infograf and I seem to have found the problem! It is a problem with JUpgrade - the column "ordering" in table "_menu" is filled with different numbers - it should be just zero's as the ordering of the menu items is drawn from the columns "lgt" and "rgt".

Use this in phpMyAdmin to correct the issue: UPDATE `your db name`.`your table prefix_menu` SET `ordering` = '0'

This works. More specific instructions:

1.Go to PHPMyAdmin
2. Click on your database name on left too open that database.
3. Once the database is open, click on the tab near top called SQL. You will get a white box.
4. In the white box, past in UPDATE `your db name`.`your table prefix_menu` SET `ordering` = '0'
Example of what to put for these values (db name - and - table prefix_menu) depend on what your database name and table prefix are. Say your database name is shoes_tie and your table prefix (this is the prefix on all of the tables listed on the left in your database) is jos151_. IN this case you would put the following into the white box:

UPDATE `shoes_tie`.`jos151_menu` SET `ordering` = '0'

5. Once you have this pasted in the white box (make sure you have the db and prefix correct), click GO at bottom right on screen.

That's it. After that, you should be able to reorder using the blue arrows or using draganddropadmin if you have that installed and it wasn't working before.

Kerry

[chrisg76]

I found the only way to fix it is to go into the Module manager> your module> choose the pull down "ordering" on the right side of the page and select the NUMBER you want your module to wind up at. So, your module (The one you just opened) may be "1-mod" and you may want it last. So, on the pull down "ordering" click on the last number (in my case it is "5-men"); click save and close. when you refresh your page you will see it has moved. Please don't ask me why...

[ajrallen]

It's not a jUpgrade bug - I didn't use jUpgrade and I can duplicate the problem in the Menu Item Manager. I am on version 1.7.1 now.

I watched the database carefully and the order is controlled by the ordering column and the lft/rgt columns. When you reorder (I was testing by numerically reordering and using the "save" button) Joomla sets new lft values, but does not change the ordering column. Then it calls a rebuild, and that uses the ordering column. Since the ordering column never changed, it just sets the lft value back to where it was, making it impossible to reorder using the "save" button, and causing strange behavior after you use the up/down arrows (though sometimes it initially seems to work).

The fix may be to add a line after line 1432 of /libraries/joomla/database/tablenested.php:

$query->set('ordering = ' . (int) $lft_array[$i]);

WARNINGS!!!!!
I haven't thoroughly tested all cases with this new fix yet. The worst it could do, though, is mess up ordering -- but I've already got that problem!

AND.... This would be a CORE HACK. Which is a NO-NO-NO bad idea, most of the time, but if you have tons of reordering to do and this bug is making you crazy, it might be worth it. Hopefully this bug is fixed in the next version but if not you should be prepared to repeat the fix after upgrading.

Oh, and I'm not a newbie to Joomla but I am a newbie in the forum so please be kind.

[infograf768]

FYI: The Rebuild function is ONLY using the "ordering" column, if there is in that column a number not equal to 0 (zero). Com_languages uses the ordering column while menu should not, which created the issue.

If you have still some figures ≠ 0 in the ordering column, there is the error, as far as I know.

[e-mates]

Well Thanks All of You.But i have still the same issue. I have installed the components of Ronny Buelund but still not working for me how do i solve this issue manually Any help please

[beachfunk]

Love/Hate Joomla! No blue arrows with which to reorder my main menu items and can't type positions into the boxes --

FIXED - I simply clicked on the "Ordering" header (in blue 1.7.1) to change to descending and behold, the blue arrows appeared next to the menu items. After that everything worked as you would expect. When switching back to default ordering, however, blue arrows vanish and no changes can be made.

Now I love Joomla again...

[ProtoPC]

Had the same menu ordering problem...I emptied all trashed menus and the ordering worked again no other changes made. We'll see if it lasts.

[mopha]

I am on 1.7.2 and the issue still persists. Tried the attached component, but no dice either (after install, selecting it in the Component menu returns a "Component not found error").

[barback]

Before I found this thread I had figured a way to get items in line on a small site with ~10 items. I used the MOVE function at the bottom of the menu manager to move an item to the same menu -- it brings it in at the bottom of the menu. Not as easy as the numbering or tweaking blue arrows, but it seems to have worked.

I don't have access to directly look at the database on this site, so I needed another way around. Just for insurance, I also installed the reset component.

Is installing it all that is required? Like mopha, I got the "component not found error".

[rbuelund]

Yes installing is all - you can remove it afterwards.

[bleonard]

Rebuilding the Menu Item and then Changing the order, corrected this problem for me. I tried this first before any of the patches.