Results 1 to 9 of 9

Threaded View

  1. #1
    Join Date
    Aug 2009
    Posts
    48
    Plugin Contributions
    0

    Default 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?
    Attached Images Attached Images  
    20th Century Glass - Antique & Collectable Glass Store

 

 

Similar Threads

  1. SQL Errors Post Checkout and Order Details
    By rkhan3366 in forum Upgrading to 1.5.x
    Replies: 6
    Last Post: 29 Mar 2021, 01:56 AM
  2. v151 query_factory.php on line 46 errors when upgrade from 150 to 151
    By nuganics in forum Upgrading to 1.5.x
    Replies: 29
    Last Post: 17 Jul 2014, 02:13 AM
  3. Replies: 1
    Last Post: 5 Jan 2011, 07:34 PM
  4. Replies: 1
    Last Post: 3 Oct 2009, 03:38 PM
  5. Some info missing in order details when shipping page skipped
    By FrenchFrog in forum Managing Customers and Orders
    Replies: 12
    Last Post: 8 Nov 2007, 06:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR