Testing v2.0.0 Upgrade - Issues / Errors When Loading Order Details

[WayneStephens]

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?

[swguy]

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?

[WayneStephens]

That fixed the first problem, thanks!

Database Engine: MySQL 8.0.32

[WayneStephens]

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!

[carlwhat]

interesting issue.

apparently your host has ANSI mode enabled in your mysql configuration.

good job by @swguy figuring that one out!

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

[swguy]

PR https://github.com/zencart/zencart/pull/6403

[WayneStephens]

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

[swguy]

LOL @lat9 has found a bunch already. Watch the issue I linked earlier for more updates.