Menu Order Problem

For some of our Joomla 2.5 sites, the menu order changed by itself (possibly after a secuity update). We started seeing this problem around Nov 2013, particularly with sites that were upgraded from Joomla 1.5


Joomla 2.5.16 gets confused when the "order" record is filled out in the "_menu" table in the Joomla database.


To fix required knowledge of SQL. You will need to edit the joomla database manually using phpMyAdmin, or SSH in and use SQL.

We need make the "order" record = 0 for every menu item. This is the SQL command to execute...

UPDATE `joomla_database`.`prefix_menu` SET `ordering` = '0'

Where 'joomla_database' is the joomla database name, and 'prefix_menu' is your joomla _menu table name. These names are different depening on your installation.