Admin/Tools/EZ-Pages cannot open after upgrade from 1.57d to 1.58

[njcyx]

zc 1.58
php 8.0
MySQL 5.7.39

I just upgraded my datebase from 1.57d to the 1.58. The upgrade process ran smoothly, but I cannot open Admin/Tools/EZ-Pages page. The following log file is generated.

[20-Oct-2022 14:48:52 America/New_York] Request URI: /admin/index.php?cmd=ezpages&reset_ez_sort_order=1
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/admin/includes/classes/split_page_results.php:220]
#5 splitPageResults->numberRows() called at [/admin/includes/classes/split_page_results.php:131]
#6 splitPageResults->__construct() called at [/admin/ezpages.php:577]
#7 require(/admin/ezpages.php) called at [/admin/index.php:11]
--> PHP Fatal error: 1060: Duplicate column name 'pages_title' :: SELECT count(*) as total FROM (SELECT e.*, ec.pages_title, ec.pages_html_text FROM zen_ezpages e INNER JOIN zen_ezpages_content ec ON (e.pages_id=ec.pages_id AND ec.languages_id = 1) ORDER BY e.header_sort_order, ec.pages_title) countresults ==> (as called by) /admin/includes/classes/split_page_results.php on line 220 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Or

--> PHP Fatal error: 1060: Duplicate column name 'pages_title' :: SELECT count(*) as total FROM (SELECT e.*, ec.pages_title, ec.pages_html_text FROM zen_ezpages e INNER JOIN zen_ezpages_content ec ON (e.pages_id=ec.pages_id AND ec.languages_id = 1) ORDER BY e.header_sort_order, ec.pages_title) countresults ==> (as called by) /admin/includes/classes/split_page_results.php on line 220 <== in /includes/classes/db/mysql/query_factory.php on line 667.

[swguy]

Look at your database in phpMyAdmin, and go to the table ezpages, and see if you have a column called "pages_title".

(You shouldn't - that column was removed from that table as part of the 1.5.6 upgrade.)

[njcyx]

Hi @swguy, thanks for your reply. I just checked my database (both 1.57d and 1.58 databases) and I indeed found "pages_title" column there. Can I remove this column manually?

It is a test site so I can easily destroy the whole database and start from the old backup. I can try to upgrade my database later after this bug is fixed...

Thanks for your help again.

[swguy]

This operation failed in the 156 upgrade and we did it again in 157 but somehow it's failing again (at least in some cases).
If you just want to keep on testing, then yes, go ahead and do

ALTER TABLE ezpages DROP pages_title;

(you may have to do this for the fields pages_html_text and languages_id too).

[njcyx]

Hi @swguy, I just dropped pages_title, pages_html_text and languages_id under table ezpages. It worked perfectly! I can now open the EZ-page! Thanks!

If you need me to test something else, please let me know.

[swguy]

Yep this is a bug. See
https://www.zen-cart.com/showthread....72#post1390772

[njcyx]

Hi @swguy, thanks for your update again.

I noted that you mentioned one more change in this link above. I checked my 1.58 database, and I did find column "final_price" under table "customers_basket". I have deleted that column by your provided command.