Not understanding upgrade process

I am upgrade from 1.50 to 1.54 I am willing to go thru and redo all of the little custom bits here and there, main thing I need is the database with the products, however, I cannot seem to grasp how to get the new site to use that data. I have tried to import it but get an error when I try. Is there an easier way to do this??

SQL error:

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' ) , ( 6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$postcode / $country' ) ;


MySQL said: Documentation

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

Need to drop the old tables before trying to insert/upload/import the old database.. Basically the response is that the new database already has a product with product_id 1.

Um, it sounds like you're importing data into a database that ALREADY HAS data. Why?

I suspect reading this post may benefit you: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

DrByte:

Um, it sounds like you're importing data into a database that ALREADY HAS data. Why?

I suspect reading this post may benefit you: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

MC123... hit the nail on the head, I wasnt dropping any data. I don't do a lot of work with sql and was literally going step by step from the directions, which, assume basic understandings of the mysql apparently.

Tuxydoh:

MC123... hit the nail on the head, I wasnt dropping any data. I don't do a lot of work with sql and was literally going step by step from the directions, which, assume basic understandings of the mysql apparently.

I believe though, one of the steps is to create the new database without the default products. That is one of the reasons the good Dr. Pointed out the instructions I nearly also attached, but went for the answer I did.

I created without default products, but it creates fields for address etc for customers and I think that is where it was snagging. Honestly, this has really had me going for a while. it started just as the update, I wasnt getting that, so I figured I would just do clean install. It has been a couple years since I did full install or anything with it and I must say I am out of practice and it is showing.

With your clarification I was able to link the database, so thank you very much. If I decide to go back to the actual upgrade route, one thing wasnt clear to me, do I need to have the complete unzipped 1.5.4 in the same directory as my older site or just the zc install folder?

Tuxydoh:

With your clarification I was able to link the database, so thank you very much. If I decide to go back to the actual upgrade route, one thing wasnt clear to me, do I need to have the complete unzipped 1.5.4 in the same directory as my older site or just the zc install folder?

If I understand the question correctly (which I am not entirely sure I do), I think the answer is a sense is yes...

If you follow the very cautious and controlled process of the link: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading, at one point the ZC 1.5.4 (when upgrading to that version or the latest version) files will be at the location of the old site. (Remember there are a number of ways to locate/relocate files, copy, rename, move, etc...)

But to perform the database upgrade portion, which is sort of like the last step when applying the upgrade to the live site, requires the zc_install folder to be at the root of the store path that is being upgraded. (The zc_install for 1.5.4 should only be run against store code that supports 1.5.4. )

Basically, step by step in the guide, understanding that some of the early discussion is just that, discussion. Concepts about how the whole thing fits together... Read and understand first, then apply... The task will go much quicker (less errors) when approached with understanding first.

Sorry, long msg. :|

mc12345678:

If I understand the question correctly (which I am not entirely sure I do), I think the answer is a sense is yes...

If you follow the very cautious and controlled process of the link: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading, at one point the ZC 1.5.4 (when upgrading to that version or the latest version) files will be at the location of the old site. (Remember there are a number of ways to locate/relocate files, copy, rename, move, etc...)

But to perform the database upgrade portion, which is sort of like the last step when applying the upgrade to the live site, requires the zc_install folder to be at the root of the store path that is being upgraded. (The zc_install for 1.5.4 should only be run against store code that supports 1.5.4. )

Basically, step by step in the guide, understanding that some of the early discussion is just that, discussion. Concepts about how the whole thing fits together... Read and understand first, then apply... The task will go much quicker (less errors) when approached with understanding first.

Sorry, long msg. :|

I have read that page several times, I just don't get it, unfortunately, reading that was what lead me into the confusion with the databases and products. So, how my twisted understanding is right now is, I am installing 1.5.4 and then just replacing any files I had previously customized?

Tuxydoh:

I have read that page several times, I just don't get it, unfortunately, reading that was what lead me into the confusion with the databases and products. So, how my twisted understanding is right now is, I am installing 1.5.4 and then just replacing any files I had previously customized?

The specific changes that were made in files are what need to be carried over, if they appear to provide value to your store and are still compatible with ZC 1.5.4. It is not necessarily the file, but the change made to the file...

That's the short answer.