2.5.4 upgrade errors

The support for Joomla 2.5 ended on December 31, 2014. Possible bugs in Joomla 2.5 will not be patched anymore. This forum has been closed. Please update your website to Joomla 3.x

Moderators: ooffick, dam-man

Forum rules
Please use the official Bug Tracker to report a bug: http://issues.joomla.org
tecpartner
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Mon May 17, 2010 3:28 pm

2.5.4 upgrade errors

Postby tecpartner » Wed Apr 04, 2012 4:40 pm

Doing an upgrade of Joomla 2.5.3 to 2.5.4 using the backend Extension Manager Update function I get the following errors.
This seems the same as the allegedly fixed {#27488] JInstaller: :Install: Error on upgrade 1.7.3 to 2.5 Beta 1 reported on joomlacode.org.


JInstaller: :Install: Error SQL DB function failed with error number 1062
Duplicate entry '22' for key 'PRIMARY' SQL=INSERT INTO `j16_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 `j16_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);

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 16696
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: 2.5.4 upgrade errors

Postby leolam » Thu Apr 05, 2012 4:35 am

Read this and you know how to resolve:

https://www.akeebabackup.com/documentat ... pdate.html

Leo 8)
- Joomla Professional Support Services :https://gws-desk.com -
- Joomla Specialized Hosting Solutions:https://gws-host.com -
- Joomla Professional Web Development :www.gws-studio.com -
- Member Joomla Bug Squad & J-CMS Release Team

tecpartner
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Mon May 17, 2010 3:28 pm

Re: 2.5.4 upgrade errors

Postby tecpartner » Thu Apr 05, 2012 9:09 am

Many thanks - I will apply this.

Just for interest, is the database actually broken by this error or could it be ignored?

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8447
Joined: Sat Oct 01, 2011 7:06 pm

Re: 2.5.4 upgrade errors

Postby sovainfo » Thu Apr 05, 2012 5:47 pm

This error doesn't break the database. It only doesn't show the component joomlaupdate in the components menu in the backend. The suggested fix adds this to the menu.

Do verify the contents of administrator\components\com_admin\sql\updates\mysql\2.5.4-2012-03-19.sql. Those commands have to be executed as well.

Also verify #_schemas id 700. The version_id should start with 2.5.4.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

tecpartner
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Mon May 17, 2010 3:28 pm

Re: 2.5.4 upgrade errors

Postby tecpartner » Thu Apr 05, 2012 7:09 pm

Thanks sovainfo.

Running the sql you describe leads to error on first step (column access already exists), so have ignored this hoping that everything else is OK.
Schemas id 700 is correct already.

How did you get to know this stuff?

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8447
Joined: Sat Oct 01, 2011 7:06 pm

Re: 2.5.4 upgrade errors

Postby sovainfo » Thu Apr 05, 2012 11:39 pm

@tecpartner: I studied the code of com_admin.
Last edited by imanickam on Fri Apr 06, 2012 1:31 am, edited 1 time in total.
Reason: Moved Part of the reply (to GW54nuNN) to the post f=622&t=708735#p2781904
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!


Return to “Joomla! 2.5 Bug Reporting”

Who is online

Users browsing this forum: No registered users and 5 guests