Upgrading from 1.5.1 to 1.5.4 clarification of process please

I want to use the 'rebuild' site method to upgrade from 1.5.1 to 1.5.4 but need some help - mainly regarding database upgrade.

• the main reason for concern is that in my current 1.5.1 site(s) I have an add-on currently that does not work 100% (image slide in template won't work) and one that doesn't work at all but creates error logs - both issues are SQL file issues (loaded > deleted> won't reload) however I have put up with it.
• now I want to update to 1.5.4 but have concerns about database upgrade once I have built the 'new site' - will SQL errors currently in existing database be carried across to new database overriding the SQL files from these add-on modules in question? ... do I need to find and delete these faulty SQL lines from the existing database first?

Also do I have the upgrade process correct here??

1. create new folder
2. create new data base
3. upload ZC 1.5.4
4. upload add-on modules and template currently used in existing 1.5.1 site (and any other file modifications)
5. upload images to new site from existing site
6. import database from existing site to database in new site
7. test new site (which is now a complete rebuild of existing site, however now 1.5.4)
8. if all is OK and new site functions fully, then ....... replace ALL files in old site with ALL files from new site ?? (after having made full back up of existing site)

Maybe 6 and 7 should be reversed?? Should 6 above be a database 'Upgrade' of existing site instead - if so, how exactly is that done? (doing this would negate step 8 in my list, right?)

cheers,
Mike

I have read this FAQ on the subject of upgrading via site rebuild and get the gist but it's dialogue isn't quite simple enough for me, i.e. follow the bouncing ball, step by step, simple(r) language ... sorry DrByte, no offence intended - https://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

shags38:

I want to use the 'rebuild' site method to upgrade from 1.5.1 to 1.5.4 but need some help - mainly regarding database upgrade.

• the main reason for concern is that in my current 1.5.1 site(s) I have an add-on currently that does not work 100% (image slide in template won't work) and one that doesn't work at all but creates error logs - both issues are SQL file issues (loaded > deleted> won't reload) however I have put up with it.
• now I want to update to 1.5.4 but have concerns about database upgrade once I have built the 'new site' - will SQL errors currently in existing database be carried across to new database overriding the SQL files from these add-on modules in question? ... do I need to find and delete these faulty SQL lines from the existing database first?

Also do I have the upgrade process correct here??

1. create new folder
2. create new data base
3. upload ZC 1.5.4
4. upload add-on modules and template currently used in existing 1.5.1 site (and any other file modifications)
5. upload images to new site from existing site
6. import database from existing site to database in new site
7. test new site (which is now a complete rebuild of existing site, however now 1.5.4)
8. if all is OK and new site functions fully, then ....... replace ALL files in old site with ALL files from new site ?? (after having made full back up of existing site)

Maybe 6 and 7 should be reversed?? Should 6 above be a database 'Upgrade' of existing site instead - if so, how exactly is that done? (doing this would negate step 8 in my list, right?)

cheers,
Mike

I have read this FAQ on the subject of upgrading via site rebuild and get the gist but it's dialogue isn't quite simple enough for me, i.e. follow the bouncing ball, step by step, simple(r) language ... sorry DrByte, no offence intended - https://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

My approach would be to create a clone of your existing 1.5.1 installation (database and files) in a separate directory.

Now only work on the cloned 1.5.1 site.

Uninstall the faulty plugins so the cloned 1.5.1 DB is cleaned of any modifications. Let's call this DB-151-2 for illustration purposes.

Then do a vanilla installation of 1.5.4 in a third directory, copy all images from the original 1.5.1 site to the new 1.5.4 installation. When it all works, dump all tables from the new 1.5.4 DB and import your cleaned DB-151-2. Then run zc_install again to upgrade that DB.

You now have a working 1.5.4 site with all products / customers / images etc.

frank18:

My approach would be to create a clone of your existing 1.5.1 installation (database and files) in a separate directory.

Now only work on the cloned 1.5.1 site.

Uninstall the faulty plugins so the cloned 1.5.1 DB is cleaned of any modifications. Let's call this DB-151-2 for illustration purposes.

Then do a vanilla installation of 1.5.4 in a third directory, copy all images from the original 1.5.1 site to the new 1.5.4 installation. When it all works, dump all tables from the new 1.5.4 DB and import your cleaned DB-151-2. Then run zc_install again to upgrade that DB.

You now have a working 1.5.4 site with all products / customers / images etc.

Thanks for the reply Frank - I have tried deleting the troublesome SQL's via uninstall.sql files with no luck so I guess I will have to try and find them in the db and manually delete them?

This is the part I for some reason or other can't get my head around, I am not good with DataBases;
[quote]When it all works, dump all tables from the new 1.5.4 DB and import your cleaned DB-151-2. Then run zc_install again to upgrade that DB.[\quote]

1. 'dump all tables' means?? (delete?)
2. run ZC_install in 'WHICH' directory version? 3 I take it?

cheers,
Mike

shags38:

Thanks for the reply Frank - I have tried deleting the troublesome SQL's via uninstall.sql files with no luck so I guess I will have to try and find them in the db and manually delete them?

This is the part I for some reason or other can't get my head around, I am not good with DataBases;

When it all works, dump all tables from the new 1.5.4 DB and import your cleaned DB-151-2. Then run zc_install again to upgrade that DB.[\quote]

1. 'dump all tables' means?? (delete?)

Yes, you end up with an empty DB. Then import the DB-151-2 into this empty DB.

shags38:

2. run ZC_install in 'WHICH' directory version? 3 I take it?

Yes, you run that in the 3rd directory which contains your new 1.5.4 installation

Thanks very much Frank - the muddy waters are now crystal clear so I can proceed fearlessly with my upgrades (5 of them) :)

Really appreciate your help.

cheers,
Mike