138A to 139H Slowhand Upgrade

I plan to upgrade to 139H over the Turkey Day weekend. Bad weekend to do this anyway.

What Directories can I upgrade without adversely affecting the whole system and forcing a restore before doing the full upgrade say on the 29th when business slows down for the day? :book:

OR is the best way to install a fresh 139H to a new directory and then try to tweak the store from there before taking that live? Are there directions to upgrade the DB as well so the 2 directories can share the same DB?

Thanks in advance.

OR is the best way to install a fresh 139H to a new directory and then try to tweak the store from there before taking that live? Are there directions to upgrade the DB as well so the 2 directories can share the same DB?
Do not share the same DB....create a new db for the upgrade and follow the tutorial
https://www.zen-cart.com/tutorials/index.php?article=108

When satisfied with the temp install, place your live site down for maint
Pull another proper DB backup and import into the new db and re-run zc_install and upgrade db only
Move all live site files to a folder
Move all new install files to your present shop location and edit the configure.php files to reflect the move
Enter the admin and remove from maint
https://www.zen-cart.com/tutorials/index.php?article=103

Thanks cobra. Looking forward to it.

I have to admit.

Uploading a fresh install of 139H is really making the upgrade easier than expected. Many of the extra modules already installed in the current shop seem to be in place and I can decide which additional ones really need to be added later.

So the new site should load faster.

Many of the extra modules already installed in the current shop seem to be in place

Something about that statement bothers me......are you seeing some of your add-on modules in the admin menus? if you are this would be because you upgraded a copy of your database from the live store, which is fine......but that only means the configs are set for them, the files for those mods will be missing from the fileset.

No. It has been years since doing a fresh install on my own server so it just "seemed" as if there are some cool changes/addons that have been added.

I just want to import my Products from the old "Store" to the New 139v so do I just import all the Product tables or just Product Desription? Will that populate the inventory with pics, quantities, weights, etc?

LOCK TABLES products_description WRITE;

I just want to import my Products from the old "Store" to the New 139v so do I just import all the Product tables or just Product Desription?
Not recommended
Import the full DB and re-run zc_install to upgrade it

Due to new higher costs and terrible customer service I decided to start fresh on another host.

Since the copy of 139H is fresh on the server can't import the old database into the new one so that the products are there, customers, and orders continue from here?

I backed up the old site according to the recommendations.

If you look at the published upgrade instructions, one of the steps is a clean install of the latest version. Since your new host has a clean install of that version, that's the only step you'll skip in the rest of the instructions.

Ooops what I meant was... can't I import the old database into the new one so that the products are there, customers, and orders can continue from here?

Insomuch as there is a database-import requirement for doing an upgrade, yes: you'll import your data the same way you would in preparing an upgrade. Later on in the upgrade steps you'll run zc_install to upgrade its structure, in addition to dealing with all your php file customizations etc.

Got it. Thanks Doc.

Found this when function testing the Email and send Newsletter send:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or cust' at line 1
in:
[SELECT email_address as customers_email_address FROM WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]

Any hints?

Do you have a tool to sniff out the other sql errors IF they exist on my site?

That's a result of having had the Newsletter Subscribe addon installed but not fully uninstalling all the changes it made to your database.
You'll need to manually hack out (delete) all entries in the query_builder table that make any mention of TABLE_SUBSCRIBERS in order to prevent that error.

Okay I'm ready for a site function test.

Please do not complete the order in paypal. If you do then I will refund your money.