Upgrade from 1.2.4 to 1.3.7

I have my new site working ver 1.3.7, all products and data transfered from old version 1.2.4, but i need to now move the customers and address, but the tables are different.

Can i just upgrade the sql files from 1.2.4 to 1.3.7 using zc_installer? without damaging the 1.2.4 working site?

I do have a complete up to date backup if it goes wrong, but wanted info before I start

The 1.2.4 site is the live one at present, but a soon as the customers are transfered acrross the 1.3.7 will be live
thanks

or is there another way via phpmyadmin to alter the tables for a export to the new version

thanks

Andy

If you have a 1.3.7 site with a separate DB then in phpmy admin select this DB and drop all the tables.

Import the 1.2.4 DB backup into this DB and run the zc_install - upgrade DB only.

This should get all your tables updated correctly. Now that you know how to do this you will do this again just before taking 1.3.7 live by taking the 1.2.4 site down for maint performing a DB back - applying to the new store & run zcinstall again this captures the most up todate information. Bring up the new site as the live site.

thanks
i will give it a go

Andy

just a thought, and i will give your way a go, but, can i just add the two new lines in the customer table myself and them export the customers, would that still work?

Andy

It has been too long since I have seen a 1.2.4 DB so I can' provide an opinion buy know that the recommended method works. And if a live store you need more than this to bring all new customers, new orders, inventory etc up todate

I only ask, as im having problems uploading 15meg files via phpMyAdmin

Andy

Have you cleared out the Admin Activity Log (Admin > Tools > Store Manager > reset button at top)? This can get really big and the data is for information only.

1.2.4 does not have the reset button, can this be done in phpMyadmin?

It seems im stuck, as i cant upload the backup files

Andy

Wow looks like I'm not the only lazy person in here.

This is exactly what I'm about to do.

Will post my results tomorrow if I can.

In the meantime though, will this update still be as simple considering I have added a fair handfull of mods?

Thanks in advance:)

If you've added a fair number of mods designed for version 1.2.x then I'm afraid that the upgrade is very unlikely to be straightforward. The impacts of each mod on the core code will need to be checked. Often you will need to install a later version instead.

Thanks Kuroi

I should have stated my intended method I guess: I am intending to import the 1.2.4 db into a scratch 1.3.7 build as the mods are mostly obsolete now anyway. So I guess what I am asking, is: if I import the modified 1.2.4 db into a new 1.3.7 shop will it simply take the entries it needs? Or will the modded queries corrupt it? If so, can you suggest anything to help?

What i did was, upload a fresh copy of the 1.3.7 files, then add the 1.2.* sql file via phpMy admin, import your backup database, then run the upgrade DB in the zc_install for 1.3.7

this added the correct tables and altered the existing where needed.

very painless

Andy

andy:

What i did was, upload a fresh copy of the 1.3.7 files, then add the 1.2.* sql file via phpMy admin, import your backup database, then run the upgrade DB in the zc_install for 1.3.7

this added the correct tables and altered the existing where needed.

very painless

Andy

That's pretty much what I did when I upgraded from 1.2.7 to 1.3.7. I set up 1.3.7 in a testbed with a new db and imported the live db into it. I fiddled with the look of the site and when I was done I uploaded 1.3.7 (with my template changes) to the live site. All I had to do was change the config files to make sure they pointed to the live site instead of the test bed. Then I ran zc_install to upgrade the live DB. Worked like a charm.

Sweeet

Couldn't have been easier.

As above; I installed 1.3.7 completely. Then imported the backed-up db and upgraded.

Easy as 1-2-3

Thanks! :)

Generally this approach will work fine and is my preference when I upgrade clients. You may find a few left over configuration switches, but generally these simply won't do anything. Similarly, you may have some additional tables and entries in core tables that are simply ignored, but this won't normally cause any problems.