OFBiz
  1. OFBiz
  2. OFBIZ-3881

Error when "Add All to Cart" or "Add Checked to Cart" viewing an order in ecommerce

    Details

      Description

      When you click the button "Add all to Cart" or "Add Checked to Cart" viewing an order in ecommerce application an error is shown.

      The error is:

      :ERROR MESSAGE:

      org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen component://ecommerce/widget/OrderScreens.xml#orderstatus: org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://ecommerce/webapp/ecommerce/WEB-INF/actions/order/OrderStatus.groovy] (SQL Exception while executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ORDER_HEADER WHERE ORDER_ID=(?, ?) (Syntax error: Encountered "," at line 1, column 563.)) (Error running Groovy script at location [component://ecommerce/webapp/ecommerce/WEB-INF/actions/order/OrderStatus.groovy] (SQL Exception while executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ORDER_HEADER WHERE ORDER_ID=(?, ?) (Syntax error: Encountered "," at line 1, column 563.)))

      To repeat the bug:

      In ecommerce application > Order History (https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/orderhistory) > Login as demo customer (DemoCustomer / ofbiz) > Select an order > Click "Add All to Cart" or "Add Checked to Cart"

        Activity

        David - DiSiD Technologies created issue -
        Sascha Rodekamp made changes -
        Field Original Value New Value
        Attachment OFBIZ-3881_FixTheAddAllFunctionInOrderHistory.patch [ 12468239 ]
        Jacques Le Roux made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Assignee Jacques Le Roux [ jacques.le.roux ]
        Fix Version/s Release Branch 09.04 [ 12313602 ]
        Fix Version/s Release Branch 10.04 [ 12314832 ]
        Fix Version/s SVN trunk [ 12311928 ]
        Resolution Fixed [ 1 ]

          People

          • Assignee:
            Jacques Le Roux
            Reporter:
            David - DiSiD Technologies
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development