Forums / Upgrading to 2.x.x / Just did an upgrade tp 2.2.2 and...

Just did an upgrade tp 2.2.2 and...

Views: 191

Results 1 to 6 of 6
29 Jun 2026, 12:15 AM
#1
spminis avatar

spminis

Zen Follower

Join Date:
Feb 2015
Location:
USA
Posts:
194
Plugin Contributions:
0

Just did an upgrade tp 2.2.2 and...

Getting this error message for the orders page

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

Carol

29 Jun 2026, 12:21 AM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Just did an upgrade tp 2.2.2 and...

spminis:

Getting this error message for the orders page

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

Carol
Check the site's /logs directory for files that start with myDEBUG; they'll have information that identifies the source of the error.

You can also install the "Display Logs" plugin from the admin. Just navigate to the admin's Modules :: Plugin Manager and install the "Display Logs" plugin. That will add "Display Log Files" to the admin's "Tools" menu so that you can view those debug logs directly.

29 Jun 2026, 12:53 AM
#3
spminis avatar

spminis

Zen Follower

Join Date:
Feb 2015
Location:
USA
Posts:
194
Plugin Contributions:
0

Re: Just did an upgrade tp 2.2.2 and...

lat9:

Check the site's /logs directory for files that start with myDEBUG; they'll have information that identifies the source of the error.

You can also install the "Display Logs" plugin from the admin. Just navigate to the admin's Modules :: Plugin Manager and install the "Display Logs" plugin. That will add "Display Log Files" to the admin's "Tools" menu so that you can view those debug logs directly.

Thanks. This is what the log says:
[29-Jun-2026 00:51:42 UTC] Request URI: /store/admin2/index.php?cmd=orders, IP address: 71.59.73.158, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(757): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(701): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(314): queryFactory->set_error()
#4 /admin2/includes/functions/general.php(778): queryFactory->Execute()
#5 /admin2/orders.php(43): zen_getOrdersStatuses()
#6 /admin2/index.php(16): require('/home/spmini5/p...')
--> PHP Fatal error: FATAL MySQL error 1054: Unknown column 'orders_status_color_code' in 'SELECT' :: SELECT orders_status_id, orders_status_name, orders_status_color_code FROM orders_status
WHERE language_id = 1 ORDER BY sort_order, orders_status_id ==> (as called by) /admin2/includes/functions/general.php on line 778 <== in /includes/classes/db/mysql/query_factory.php on line 757.

29 Jun 2026, 9:52 AM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Just did an upgrade tp 2.2.2 and...

How did you do that upgrade? I ask because the zc_install process adds that orders_status_color_code to the orders_status table.

If you're missing that one, there are probably others missing as well.

29 Jun 2026, 2:02 PM
#5
spminis avatar

spminis

Zen Follower

Join Date:
Feb 2015
Location:
USA
Posts:
194
Plugin Contributions:
0

Re: Just did an upgrade tp 2.2.2 and...

i did a clean install

29 Jun 2026, 5:05 PM
#6
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Just did an upgrade tp 2.2.2 and...

After you did that "clean install", did you update the database with the site's previous information? That would have overwritten any changes that the "clean install" provided.

If that's what happened, you'll need to re-run zc_install ... this time looking for the "Upgrade" path. That way the installer will update the database with new and changed fields on top of your existing customizations.