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

Moderator: ooffick

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

2.5.4 upgrade errors

Post by 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: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: 2.5.4 upgrade errors

Post by 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's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

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

Re: 2.5.4 upgrade errors

Post by 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: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: 2.5.4 upgrade errors

Post by 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

Post by 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: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: 2.5.4 upgrade errors

Post by 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!


Locked

Return to “Joomla! 2.5 Bug Reporting”