If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.2 to 1.3.x / 1.2.x to 1.3.x advice required please

1.2.x to 1.3.x advice required please

Locked

Started by steveyork136 on 23 Apr 2008, 8:13 PM · Views: 5,041

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
23 Apr 2008, 8:13 PM
#1
steveyork136 avatar

steveyork136

New Zenner

Join Date:
Nov 2005
Posts:
84
Plugin Contributions:
0

1.2.x to 1.3.x advice required please

I have a question about upgrading my site.
I'm about to update my site to 1.3 and as its my first upgrade I'm a little cautious (and nervous).

I decided that as I was doing the upgrade, I should look at redesigning the original site and remove some of the errors I made during the original build.

So I followed the upgrade instruction as detailed on this site and everything went fine.

I started to build the new site and now 3 months later I'm at a stage where i am happy with and its ready to go live.

But as 3 months has passed since I did the upgrade the old sites database has changed new orders, new customers etc..

What is the best way for me to "merge" the old site and new site?

Should I take the old database and run the upgrade and use this on the new site, thus losing the changes to the new site.

Or can I upgrade the old database and compare the upgraded database and new database, then manually compare and alter the database line by line.

Your suggestions and help are gratefully recived

23 Apr 2008, 8:32 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1.2.x to 1.3.x advice required please

Or can I upgrade the old database and compare the upgraded database and new database, then manually compare and alter the database line by line.
backup backup backup, FIRST

Maintain your new DB & grab from the old DB only the tables(many) that pertain to customers(address also), all product tables if you have added changed any during that time, and all order tables including any gateway trancaction tables that you use. This leaves out a few tables. Import this into the new DB and re-run zc_install on the resulting DB

See this for the correct settings when creating the backup -
https://www.zen-cart.com/tutorials/index.php?article=103

Zen-Venom Get Bitten

24 Apr 2008, 8:44 PM
#3
steveyork136 avatar

steveyork136

New Zenner

Join Date:
Nov 2005
Posts:
84
Plugin Contributions:
0

Re: 1.2.x to 1.3.x advice required please

thanks for that kobra.

I backup often but that thread has shown what phpadmin options are best, which I didn't know.

i forsee a long and stressfull day fuelled by large amounts of coffee

4 May 2008, 11:40 AM
#4
wapboy avatar

wapboy

New Zenner

Join Date:
Mar 2006
Posts:
8
Plugin Contributions:
0

Re: 1.2.x to 1.3.x advice required please

I'm trying to upgrade my database from 1.2.x version of shop to 1.3.8 version and I think the link included in Kobra's reply gives misleading advice - it tells you to backup both structure and data with phpMyAdmin, but at least some of the tables have different structures at 1.3.x.

For example, the customers table has 16 fields at 1.2.x and 18 fields at 1.3.x - so won't these extra fields be lost if you follow the advice in the link and back up structure and ADD Drop table. Losing these 2 fields must surely them impact running of zencart shop.

Can anyone point me to clear instructions on how to upgrade the database (MySQL) from a 1.2.x shop to a 1.3.x shop.

Thanks

4 May 2008, 2:53 PM
#5
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1.2.x to 1.3.x advice required please

If you do this as described then on the new install import the old DB and run the DB upgrade this will be taken care of

Zen-Venom Get Bitten

14 May 2008, 2:30 AM
#6
felixh avatar

felixh

New Zenner

Join Date:
Mar 2008
Location:
Melbourne
Posts:
5
Plugin Contributions:
0

Re: 1.2.x to 1.3.x advice required please

Copy your old database for ZC1.2.x to other database, and run Zen-Cart database upgrade feature to upgrade it into ZC1.3.8 database structure.

How to do this:
Install new ZC1.3.8 and do not delete the ZC_Install folder. next edit configure.php in your includes folder to point to your ZC1.2.x database copy. And run the zc_install again. Follow the installation wizard and choose to upgrade the database.

Next you can just copy the following tables:
address_book;
authorizenet;
orders;
orders_products;
orders_products_attributes;
orders_products_download;
orders_status;
orders_status_history;
orders_total;
paypal;
paypal_payment_status;
paypal_payment_status_history;
customers;
customers_basket;
customers_basket_attributes;
customers_info;
customers_wishlist;

And replace the related tables in your upgraded site database. That's it.
if you want better way you can compare both databases and copy any new changes (new customer, new orders, etc...). Hope it helps.

P.S. The tables list may not be complete but it works for me... and always backup before doing any changes.

14 May 2008, 4:33 AM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1.2.x to 1.3.x advice required please

felixh:

next edit configure.php in your includes folder to point to your ZC1.2.x database copy.
Not if the 1.2.x shop is live and functioning...

Zen-Venom Get Bitten