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?
Bookmarks