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.

Quote:

---

Originally Posted by 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.

---

Attachment 20323

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Attachment 20324

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

Quote:

---

Originally Posted by mprough

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

Attachment 20324

---

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

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

Quote:

---

Originally Posted by 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....72#post1390772

Quote:

---

Originally Posted by 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.

---

This gave me this

Attachment 20325

[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);
---------------

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by swguy

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

---

Attachment 20326

Attachment 20327

Attachment 20328

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.

Quote:

---

Originally Posted by 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

Attachment 20329

Quote:

---

Originally Posted by 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

No need, the problem is shown in the final image. In the configuration table,

You have

val_function mediumtext default NULL,

You need

val_function text default NULL,

This was done in zc_install/sql/updates/mysql_upgrade_zencart_156.sql:

ALTER TABLE configuration ADD val_function text default NULL AFTER set_function;

You will need to do a modify table to fix this.

Quote:

---

Originally Posted by swguy

No need, the problem is shown in the final image. In the configuration table,

You have

val_function mediumtext default NULL,

You need

val_function text default NULL,

This was done in zc_install/sql/updates/mysql_upgrade_zencart_156.sql:

ALTER TABLE configuration ADD val_function text default NULL AFTER set_function;

You will need to do a modify table to fix this.

---

Thank was the ticket, thank you bunches!

Nice one, @swguy!

It's a win-win - I'll use this data to amend the upgrade troubleshooting article.

Thanks to all who pitched in.