1 Attachment(s)
Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
Versions: Zen Cart 2.0.0, PHP 8.0, MySQL 8.0
Upgrading from 1.5.7d to 2.0.0
Mods: Keep Cart, Google reCaptcha, Google Merchant Feeder
I'm testing an upgrade to v2.0.0, and I have things more or less working as intended, just a couple of issues, which both may be related.
Firstly, when logging into the admin area, the home page with the widgets is blank after the "Orders" header (screenshot attached).
Error report:
PHP Fatal error: MySQL error 1054: Unknown column '1' in 'where clause' :: SELECT orders_status_id, orders_status_name FROM orders_status
WHERE language_id = "1" ORDER BY sort_order, orders_status_id ==> (as called by) ****/includes/functions/general.php on line 720 <== in ****/includes/classes/db/mysql/query_factory.php on line 714.
Also, when logging in as a customer, I get a blank page with the message "WARNING: An Error occurred, please let us know!".
Error report:
PHP Fatal error: MySQL error 1054: Unknown column '0' in 'order clause' :: SELECT products_options_id, products_options_value_id, products_options_value_text
FROM customers_basket_attributes
WHERE customers_id = 12
AND products_id = '11681' ORDER BY LPAD(products_options_sort_order,11,"0") ==> (as called by) ****/includes/classes/shopping_cart.php on line 180 <== in ****/includes/classes/db/mysql/query_factory.php on line 714.
Any ideas what could be causing this?
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
for the first one, would you please edit admin/includes/functions/general.php line 720 and remove the double quotes - change
language_id = "'
to
language_id = '
and change
'" ORDER BY
to
' ORDER BY
and see if that fixes it? Then go to Admin > Tools > Version and post the Database Engine value?
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
That fixed the first problem, thanks!
Database Engine: MySQL 8.0.32
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
I took your advice and applied it to the other problem, and changed line 173 in /includes/classes/shopping_cart.php
from:
ORDER BY LPAD(products_options_sort_order,11,"0")
to:
ORDER BY LPAD(products_options_sort_order,11,0)
and the second problem seems to be fixed also! So thanks again!
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
interesting issue.
apparently your host has ANSI mode enabled in your mysql configuration.
good job by @swguy figuring that one out!
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
@WayneStephens you will likely run into others, but now you know the drill for fixing them. Would you please do a quick report when you encounter these issues on this thread so we can be sure to get them all fixed? Thanks.
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
Quote:
Originally Posted by
swguy
@WayneStephens you will likely run into others, but now you know the drill for fixing them. Would you please do a quick report when you encounter these issues on this thread so we can be sure to get them all fixed? Thanks.
Sure thing, will do.
Re: Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details
LOL @lat9 has found a bunch already. Watch the issue I linked earlier for more updates.