errors on update to 2.5.24

[carsten888]

Code: Select all

JInstaller: :Install: Error SQL DB function failed with error number 1062 
Duplicate entry '22' for key 'PRIMARY' SQL=INSERT INTO `sadk_menu` (`id`, `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 (22, '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);
SQL =
INSERT INTO `#__menu` (`id`, `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
(22, '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);
Files Update: SQL error file DB function failed with error number 1062 
Duplicate entry '22' for key 'PRIMARY' SQL=INSERT INTO `sadk_menu` (`id`, `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 (22, '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);
SQL =
INSERT INTO `#__menu` (`id`, `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
(22, '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);

using the updater

[Webdongle]

Have a look at the Database tab and 'Fix' any errors
Clear cache and try again

[carsten888]

Thank you.

There where some issues which where fixed. Unfortunately I just uploaded the patch, so not sure if that fix would have solved the update-issue. Will just have to wait till the next update to see if it still gives me this error.

Thanks for the fast reply.

[Webdongle]

I am experiencing a similar problem on one site. The method above did not fix things completely. There is a new component in 2.5.4 that did not install with the update.

Did your Joomla have its version stated twice in the footer ?

[carsten888]

Did your Joomla have its version stated twice in the footer ?

no.

[Webdongle]

Do you see the new Joomla update component in the Components menu ?

Capture 139.PNG

If not use phpMyAdmin to add the following to your database. Be sure to backup first and in the following change #_ to your prefix

INSERT INTO `#__menu` (`id`, `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
(22, '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);

[diesl]

First of all, hello to Joomla forums

I am also experiencing this error. I have 3 Joomla installations, of which two show this error. They have been installed in J1.0 era and upgraded to J1.7 and finally 2.5. The third one was a late J1.7 installation, now on J2.5 and shows no errors.

After inspecting the DB, the error is clear: As the message states, ID 22 is already in use in table #__menu. In my case, a mainmenu item has taken ID 22.

Comparing things with the working Joomla installation, Frontend menu items start with ID 101, meaning there is space for another ~80 entries before. In the broken installation, frontend menus start at ID 21. This means Smart Search (ID 21) and JoomlaUpdate (ID 22) have not been inserted and are missing in backend component menu.

So there seems to be a convention to reserve IDs numbers <= 100 for backend menu items. Did this convention already exist in J1.x? Can somebody with a J1.x installation take a look?

So, my question is, were was the error introduced? Some remarks:
- As only few people have this problem, I think it isn't a migration component did issue.
- In my broken Joomla installations, I did use exmenu component pre J2.5. Does anybody of you use this menu module?
- This is not a auto_increment issue (at least at my databases)

Without digging deeper into the DB, i think manually editing IDs would be PITA. But I also don't want to recreate all menu items.

Suggestions, anybody?

[Webdongle]

Hi diesl welcome to the forum. https://www.akeebabackup.com/documentat ... pdate.html may help you.

[diesl]

Thanks for the link, Webdongle!

The link Webdongle posted contains a link to a bug tracker ticket adressing this issue.

So, as it seems this is an error introduced when upgrading Joomla to 2.5.
I just wonder why only a few people report this error. I expected that many people upgraded their Joomla installation and then get this error.

I will watch the bug tracker for the next days and wait if they show up with a better solution as the one posted on the Akeeba page.

[hanjimail]

Hi, Webdongle.

I tried the below but I got an error duplicate ID 22.
How can I fix this?

Do you see the new Joomla update component in the Components menu ?

Capture 139.PNG

If not use phpMyAdmin to add the following to your database. Be sure to backup first and in the following change #_ to your prefix

INSERT INTO `#__menu` (`id`, `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
(22, '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);

[Webdongle]

Look at https://www.akeebabackup.com/documentat ... pdate.html and you will see why my fix does not work every time but the fix on that page should

[hanjimail]

Thank you, Webdongle.

It worked perfect. Joomla update menu is shown in component menu now.

[leolam]

So, as it seems this is an error introduced when upgrading Joomla to 2.5.I just wonder why only a few people report this error. I expected that many people upgraded their Joomla installation and then get this error.

read this link https://www.akeebabackup.com/documentat ... pdate.html and you have a better understanding what is causing this

Leo

[diesl]

Well, I did read the link, and as I understand it, jUpgrade introduced this "error" or let's say, misbehaviour.

That's the reason why I wonder that only few people have this error, because everybody who upgraded his site with jUpgrade should get these errors now, shouldn't they?