1.5.8a Upgrade stops

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

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.

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.

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.

mprough:

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.

carlwhat:

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

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.

mprough:

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.

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

https://github.com/zencart/zencart/blob/9df7dec2ff199a1ab26d30ee40eb585b85181cb7/zc_install/sql/updates/mysql_upgrade_zencart_156.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.

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.

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.

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.

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.php?229042-Known-bugs-%28and-fixes%29-for-v1-5-8-series&p=1390772#post1390772

carlwhat:

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

https://github.com/zencart/zencart/blob/9df7dec2ff199a1ab26d30ee40eb585b85181cb7/zc_install/sql/updates/mysql_upgrade_zencart_156.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);

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.

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

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

swguy:

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

Database has no prefix.

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

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.

swguy:

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

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.

It was not myself who did the previous upgrades.

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

project_version
project_version_history
upgrade_exceptions