upgrading from 1.3.8a to 1.5.1

I have read through numerous posts and don't find an answer to this problem.

My website (1.3.8a) is on a php5.1 server and I want to upgrade to 1.5.1 which requires moving to a php 5.3 server.
Here are the steps I did:

1- Exported my 1.3.8a Database.
2- Created a new database
3- Uploaded zen 1.5.1 files into a new folder
4- Changed permissions and changed names on both configure.php file
5- Changed permissions on all other files as per Instructions.
6- Ran install with no problems.
7- renamed admin folder.
8- Deleted zc_install folder
9- Changed permissions on both configure.php files to 444
10-Logged into Admin - no problems
11- Website accessed without a problem.

FINAL STEP - Tried to imported my 1.3.8 database and receied the following error:

localhost:3306 » herbschina_zc15
Error

SQL query:

--
-- Dumping data for table zen_address_format

INSERT INTO zen_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' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

any ideas?

Thanks

If you INSTALLED zencart 1.5.1, then you filled your new database with zencart 1.5.1 INITIAL information.

You cannot "import" your 1.3.8 database into one that is already configured for zencart. The idea is to import your 1.3.8 data into an empty database, then "point" the configure.php files of 1.5.1 to that database, and then to run a DATABASE UPGRADE.

But you should also be doing this on a CLONED site - not your live site.

There are tutorials for upgrading. Reference these and follow procedure,.

Thanks for the quick reply.

My live site is not involved. I sdid this on a new server.

Will try your suggestions.

The other thing to bear in mind - BEFORE you upgrade the DATABASE - is to make sure that any CUSTOM FILES are compatible with 1.5.

So... you need to find ALL FILES that are CUSTOM VERSIONS of CORE FILES. Typically, these are CUSTOM TEMPLATE FILES and CUSTOM LANGUAGE FILES mostly, but if you have added plugins that modify other files (such as tpl_header.php) or MODULE files (often the header.php files in the /modules/pages/xxxxxx/ can be modified) then you MUST do a FILE COMPARISON and make sure that your CUSTOM files are suitable for use in a 1.5 environment.

This usually involves bringing any CORE CHANGES into the custom files affected, and the best way of doing this is to use a file comparison tool sich as WINMERGE or BEYOND COMPARE.

Additionally, SOME plugins (modules / add-ons) are not compatible with 1.5, and those that are may need to have their previous versions removed before they can be re-installed.

OK, Let's clear up some confusion.

I am doing a CLEAN INSTALL.
My live site is on a php 5.1 server (most of the modules are not ZEN 1.5 compatible.)
This NEW site I am building is on a SEPARATE SERVER W/PHP 5.3.
All of the above steps were done on that NEW server.

I did as you originally suggested and imported the DB backup from my live site into a NEW CLEAN database on the NEW server.

• Configure.php files are pointed to the NEW database.
• I ran the Database update but hung up on the admin password which it doesn't accept even though it is correct as it is the same as in the original install .
  When I try to go to the Admin on the new site I get the following message:

"database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install"

THIS NOW PUTS ME IN A CATCH-22 SITUATION UNTIL YOU CAN FIGURE OUT WHAT I DID WRONG!
Thanks

I ran the Database update but hung up on the admin password which it doesn't accept even though it is correct as it is the same as in the original install
You have imported your live database therefore the admin user & pass are the same as your live store

Thanks Kobra.
That was it. everything working.

Glad you got it sorted

These instruction were the clearest of all. Thank you for this help and continued forum. ZenCart the only way to go almost.

Worth a read if you haven't already: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading