Support

You have used jUpgrade to upgrade your formerly Joomla! 1.5 site to Joomla! 2.5. jUpgrade is buggy and squashes all IDs, including menu item IDs. This creates a big problem.

Joomla! 1.6 and later is built on the hypothesis that certain IDs in the menu, assets and extensions tables are free, because this is how its installation is designed to handle database the default contents. As a result, some SQL files in the update packages use those supposedly free IDs to install new features. Unfortunately, jUpgrade squashes those IDs, causing SQL errors during the update. Ergo, the problem is neither with Admin Tools, nor Joomla!. It is a problem created during the upgrade of your site.

In order to work around the issue caused by the 2.5.3 to 2.5.4 upgrade, you will have to run the following SQL command in phpMyAdmin:

INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES
('menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 0, 1, 1, 28, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1);

replacing #__ with your site's database name prefix (the common part of your site's database table names, up to and including the underscore).

You're welcome!

No, you don't have to reapply the update. The only thing which was missing was running this query.

You're welcome!