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

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:(

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?144-how-can-i-do-a-site-backup-or-use-phpmyadmin-for-database-backup

Many thanks Kobra - that's cracked it!:smile:

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

It's covered in the FAQ on making database backups: http://www.zen-cart.com/content.php?144-how-can-i-do-a-site-backup-or-use-phpmyadmin-for-database-backup
-- note the options to check, which includes "include DROP TABLE ..."