1.5.8a Upgrade stops

[mprough]

Upgrading database from 1.5.6c to 1.5.8a

Stops says must upgrade from 1.5.5 first, log below


[28-Jun-2023 11:00:54 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);
---------------
I have manually verified only 1 page key for categoriesProductListing exists.


[28-Jun-2023 11:00:54 UTC] MySQL error 1054 encountered during zc_install:
Unknown column 'e.pages_title' in 'field list'
LEFT JOIN languages l ON 1;
---------------
Not sure about this one at all

Any suggestions would be appreciated, I've dealt with quite a few of these upgrade issues... Never these

Thank in advance
~Melanie

[lat9]

What plugins are installed on the zc156c version of the site?

I'll note that @swguy's "Mod List" plugin (https://www.zen-cart.com/downloads.php?do=file&id=2039) can be invaluable in situations like this. You won't be able to use the most recent version, which uses the zc_plugins structure, but you can use v1.2a.

[mprough]

What plugins are installed on the zc156c version of the site?

I'll note that @swguy's "Mod List" plugin (https://www.zen-cart.com/downloads.php?do=file&id=2039) can be invaluable in situations like this. You won't be able to use the most recent version, which uses the zc_plugins structure, but you can use v1.2a.

I see multiples of Quick Updates & EP... I tried to uninstall Quick Updates, but it looks like there are multiple versions or maybe hacked up versions installed.

[carlwhat]

Upgrading database from 1.5.6c to 1.5.8a


[28-Jun-2023 11:00:54 UTC] MySQL error 1054 encountered during zc_install:
Unknown column 'e.pages_title' in 'field list'
LEFT JOIN languages l ON 1;
---------------
Not sure about this one at all

Any suggestions would be appreciated, I've dealt with quite a few of these upgrade issues... Never these

Thank in advance
~Melanie

at some point, ezpages was split into 2 files. it seems on your upgrade path that split is missing.

i think it was from 155 to 156. but you would have to look it up.

it seems there was problems with that upgrade that others had as well.

but that is my best guess of the problem that you are running into.

best.

[mprough]

at some point, ezpages was split into 2 files. it seems on your upgrade path that split is missing.

i think it was from 155 to 156. but you would have to look it up.

it seems there was problems with that upgrade that others had as well.

but that is my best guess of the problem that you are running into.

best.

You mean 2 database tables? Because that is done already as it's 1.5.6

[swguy]

> Stops says must upgrade from 1.5.5 first, log below

1.5.6 has three checks. See
zc_install/includes/systemChecks.yml
lines 328-341. You are failing one of these tests.

[lat9]

You mean 2 database tables? Because that is done already as it's 1.5.6

It would help to see the "Structure" of those two tables, per previous comments.

[carlwhat]

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.

[swguy]

> 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.

[carlwhat]

> 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.

i think this is wrong. look above; the OP says the system says:

"Stops says must upgrade from 1.5.5 first, log below..."

the upgrade from 155 to 156 expects the ezpages table to have the pages_title field. clearly it does not.

to get to 156 all of the remaining lines in the script i referenced in my previous post need to be run, ie, lines 203-264.

after that the OP can continue the upgrade from v156.

best.