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

        Hide
        David - DiSiD Technologies added a comment -

        Thank guys

        Show
        David - DiSiD Technologies added a comment - Thank guys
        Hide
        Jacques Le Roux added a comment -

        Thanks Sascha,

        Your patch is in trunk at r1058488, R10.04 at r1058491, R9.04 at r1058492

        Thanks David for report

        Show
        Jacques Le Roux added a comment - Thanks Sascha, Your patch is in trunk at r1058488, R10.04 at r1058491, R9.04 at r1058492 Thanks David for report
        Hide
        Sascha Rodekamp added a comment -

        Hi David,
        here is a fix for your reported bug.

        The reason for the bug was that the request was called with an additional orderId get parameter. But the orderId was still in the parameter map so the request handler created with these two orderIds a orderId List. These list couldn't be interpreted from the groovy script(because a string was expected). The result was the error message.

        Have a good day
        Sascha

        Show
        Sascha Rodekamp added a comment - Hi David, here is a fix for your reported bug. The reason for the bug was that the request was called with an additional orderId get parameter. But the orderId was still in the parameter map so the request handler created with these two orderIds a orderId List. These list couldn't be interpreted from the groovy script(because a string was expected). The result was the error message. Have a good day Sascha
        Hide
        David - DiSiD Technologies added a comment -

        I don't check if this bug affects Branches jquery and 9.04, but probably the problem is happening there too.

        Show
        David - DiSiD Technologies added a comment - I don't check if this bug affects Branches jquery and 9.04, but probably the problem is happening there too.

          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