1.5.8a Upgrade stops

[swguy]

I think 1.5.5 -> 1.5.6 was done but had errors because of the issue described in the block you referenced.
If they apply the patches I showed, the 1.5.6 test will pass and the upgrade can proceed.

See
https://www.zen-cart.com/showthread....72#post1390772

[mprough]

it is choking on the upgrade. that is happening here:

https://github.com/zencart/zencart/b....sql#L194-L202

any number of people had problems with this splitting of the 2 ezpages table. look at the comments on line 198.

i think you can safely comment out lines 194-196.

but as @lat9 says, looking at the table structure would give you best idea as to what has happened.

This gave me this



[29-Jun-2023 08:41:01 UTC] MySQL error 1062 encountered during zc_install:
Duplicate entry 'categoriesProductListing' for key 'page_key'
VALUES ('categoriesProductListing', 'BOX_CATALOG_CATEGORIES_PRODUCTS', 'FILENAME_CATEGORY_PRODUCT_LISTING', '', 'catalog', 'Y', 1);
---------------

[mprough]

> it is choking on the upgrade. that is happening here:
Or rather, it choked on the upgrade that was done when you went to 1.5.6.

You can run these commands to get things fixed up again:

ALTER TABLE customers_basket DROP final_price;
ALTER TABLE ezpages DROP languages_id;
ALTER TABLE ezpages DROP pages_title;
ALTER TABLE ezpages DROP pages_html_text;

Then run zc_install again.

#1091 - Can't DROP 'languages_id'; check that column/key exists

[swguy]

Please post schemas of ezpages, ezpages_content and sessions tables. Also, does your db have a prefix?

[mprough]

Please post schemas of ezpages, ezpages_content and sessions tables. Also, does your db have a prefix?

Database has no prefix.

[swguy]

OK -note that image 2 was contents, not schema, but it was enough. Please post *schema* not contents for configuration table.

[swguy]

I'm guessing this failed when you upgraded to 1.5.6:

ALTER TABLE configuration ADD val_function text default NULL AFTER set_function;

but let's see what the schema says.

[mprough]

OK -note that image 2 was contents, not schema, but it was enough. Please post *schema* not contents for configuration table.

Here it is, sorry about the sessions table... very long night

[mprough]

I'm guessing this failed when you upgraded to 1.5.6:

ALTER TABLE configuration ADD val_function text default NULL AFTER set_function;

but let's see what the schema says.

It was not myself who did the previous upgrades.

[lat9]

Let's try a different tack. @mprough, would you post the contents of these database tables:

project_version
project_version_history
upgrade_exceptions