The Joomla! Forum ™



Forum rules


Please use the official Bug Tracker to report a bug: http://issues.joomla.org



Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: 2.5.4 upgrade errors
PostPosted: Wed Apr 04, 2012 4:40 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 17, 2010 3:28 pm
Posts: 15
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);


Top
 Profile  
 
 Post subject: Re: 2.5.4 upgrade errors
PostPosted: Thu Apr 05, 2012 4:35 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Mon Aug 29, 2005 10:17 am
Posts: 13805
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Read this and you know how to resolve:

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

Leo 8)

_________________
-- Joomla Professional Support Services : http://gws-desk.com --
-- Good & Cheap Joomla Sites Ready To Roll : http://gws-deals.today --
-- Joomla Specialized Hosting Solutions : www.gws-host.com --
-- Member Joomla Bug Squad --


Top
 Profile  
 
 Post subject: Re: 2.5.4 upgrade errors
PostPosted: Thu Apr 05, 2012 9:09 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 17, 2010 3:28 pm
Posts: 15
Many thanks - I will apply this.

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


Top
 Profile  
 
 Post subject: Re: 2.5.4 upgrade errors
PostPosted: Thu Apr 05, 2012 5:47 pm 
Joomla! Virtuoso
Joomla! Virtuoso

Joined: Sat Oct 01, 2011 7:06 pm
Posts: 4230
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.


Top
 Profile  
 
 Post subject: Re: 2.5.4 upgrade errors
PostPosted: Thu Apr 05, 2012 7:09 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 17, 2010 3:28 pm
Posts: 15
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?


Top
 Profile  
 
 Post subject: Re: 2.5.4 upgrade errors
PostPosted: Thu Apr 05, 2012 11:39 pm 
Joomla! Virtuoso
Joomla! Virtuoso

Joined: Sat Oct 01, 2011 7:06 pm
Posts: 4230
@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.
Moved Part of the reply (to GW54nuNN) to the post f=622&t=708735#p2781904


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 



Who is online

Users browsing this forum: No registered users and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group