upgrading from 139h tp 1.5.1 error #1062 - Duplicate entry '1' for key 'PRIMARY'

[Derek Bryant]

Hi

I get the above error message along with:

SQL query:

--
-- Dumping data for table `address_format`
--
INSERT INTO `address_format` ( `address_format_id` , `address_format` , `address_summary` )
VALUES ( 1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country' ) , ( 2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country' ) , ( 3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country' ) , ( 4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country' ) , ( 5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country' ) , ( 6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$postcode / $country' ) ;



MySQL said:

#1062 - Duplicate entry '1' for key 'PRIMARY'

I have installed a fresh copy of version 1.5.1. in a subdirectory
Run the installer
Exported the sql database file from the 1.39h version
Imported this file into my new 1.5.1 database
which gives the above errot message

Please can anyone help?SQL query:

--
-- Dumping data for table `address_format`
--
INSERT INTO `address_format` ( `address_format_id` , `address_format` , `address_summary` )
VALUES ( 1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country' ) , ( 2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country' ) , ( 3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country' ) , ( 4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country' ) , ( 5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country' ) , ( 6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$postcode / $country' ) ;



MySQL said:

#1062 - Duplicate entry '1' for key 'PRIMARY'


Derek:(

[kobra]

Did you try dropping all the tables before importing your 1.3.9 DB?

Or make a backup using this tutorial

http://www.zen-cart.com/content.php?...atabase-backup

[Derek Bryant]

Many thanks Kobra - that's cracked it!

I did waste quite a bit of time searching past similar threads
the "Welcome to Zen Cart" installation guide doesn't seem to cover this area unless it has recently been updated

Derek

[DrByte]

It's covered in the FAQ on making database backups: http://www.zen-cart.com/content.php?...atabase-backup
-- note the options to check, which includes "include DROP TABLE ..."