Stop Joomla Menu Links from Re-ordering

There’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.
media_1376425397488.png
  • To fix the problem, you can reset all of the entries in the column to 0, using this SQL query:
1.update jos_menu set ordering = 0

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

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

Gửi phản hồi

Please log in using one of these methods to post your comment:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s

%d bloggers like this: