RESOLVED: Error: #1062 - Duplicate entry '1' for key 1
Posted: Fri Apr 23, 2010 3:26 am
I searched the forums and it appears others get this error during migration/upgrading to Joomla 1.5. My error is occurring when I try to update the database.
I was able to successfull export the db from my localhost and import it using phpmyadmin the first time, but now every subsequent time I try to import I get the following error:
TIA
* - looking over the categories I'm not sure if this should go in the "General" or "Installation" category. Installing Joomla onto my host is complete and the site is running fine. It's only the updating of the SQL that is giving me problems.
I was able to successfull export the db from my localhost and import it using phpmyadmin the first time, but now every subsequent time I try to import I get the following error:
I have checked the jos_categories table and "Add AUTO_INCREMENT" value is on.Error
SQL query:
--
-- Dumping data for table `jos_categories`
--
INSERT INTO `jos_categories` ( `id` , `parent_id` , `title` , `name` , `alias` , `image` , `section` , `image_position` , `description` , `published` , `checked_out` , `checked_out_time` , `editor` , `ordering` , `access` , `count` , `params` )
VALUES ( 1, 0, 'Random Quotes', '', 'random-quotes', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL , 1, 0, 0, '' ) , ( 2, 0, 'Introduction', '', 'introduction', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL , 2, 0, 0, '' ) , ( 3, 0, 'Latest Updates', '', 'latest-updates', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL , 3, 0, 0, '' ) , ( 4, 0, 'Personal', '', 'personal', '', 'com_contact_details', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL , 1, 0, 0, '' ) ;
MySQL said:
#1062 - Duplicate entry '1' for key 1
TIA
* - looking over the categories I'm not sure if this should go in the "General" or "Installation" category. Installing Joomla onto my host is complete and the site is running fine. It's only the updating of the SQL that is giving me problems.