# The Joomla! Forum ™

### Forum rules

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

 Page 1 of 1 [ 6 posts ]
Author Message
 Post subject: 2.5.4 upgrade errorsPosted: Wed Apr 04, 2012 4:40 pm
 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

 Post subject: Re: 2.5.4 upgrade errorsPosted: Thu Apr 05, 2012 4:35 am
 Joomla! Master

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

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

Leo

_________________
-- 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

 Post subject: Re: 2.5.4 upgrade errorsPosted: Thu Apr 05, 2012 9:09 am
 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

 Post subject: Re: 2.5.4 upgrade errorsPosted: Thu Apr 05, 2012 5:47 pm
 Joomla! Champion

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

_________________
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)

Top

 Post subject: Re: 2.5.4 upgrade errorsPosted: Thu Apr 05, 2012 7:09 pm
 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

 Post subject: Re: 2.5.4 upgrade errorsPosted: Thu Apr 05, 2012 11:39 pm
 Joomla! Champion

Joined: Sat Oct 01, 2011 7:06 pm
Posts: 5788
@tecpartner: I studied the code of com_admin.

_________________
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)

 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

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 6 posts ]

#### Who is online

Users browsing this forum: No registered users and 8 guests

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