Stop Joomla Menu Links from Re-ordering

menu-reorderThere's a recurring problem that we've seen on several Joomla sites that have been migrated from Joomla 1.5.

Software such as a jUpgrade and SPUpgrade does a good job of moving site content and menu links.

However, the recurring problem is that the menu links on the migrated sites will re-order themselves. Often this happens when other menu links are changed or when extensions are installed.

Here's how to fix the problem.

Log in to your site's database

  • The first step is to log in to your site's database. In this example, I'm using phpMyAdmin to login to my site's database.
  • Look for the _menu table.
  • Look for the "ordering" column.
  • Inside the "ordering" column, look to see if there are any entries that are not 0. Every entry in this column should be 0, so this column is causing problems.
  • To fix the problem, you can reset all of the entries in the column to 0, using this SQL query:

update jos_menu set ordering = 0

Don't forget to replace jos_ with your database prefix.

  • Check the _menu table and the ordering problem again. If all the enteries are 0, your menus won't re-order themselves again.