[jira] Created: (OFBIZ-3881) Error when "Add All to Cart" or "Add Checked to Cart" viewing an order in ecommerce

[Nicolas Malin (Jira)]

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

                 Key: OFBIZ-3881
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3881
             Project: OFBiz
          Issue Type: Bug
          Components: specialpurpose/ecommerce
    Affects Versions: Release Branch 10.04, SVN trunk
         Environment: ALL
            Reporter: David - DiSiD Technologies


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:

{panel:title=:ERROR MESSAGE:| borderStyle=solid| borderColor=#000| titleBGColor=#cc6666| bgColor=#fff}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.))){panel}

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"

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12895631#action_12895631 ]

David - DiSiD Technologies commented on OFBIZ-3881:
---------------------------------------------------

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

> Error when "Add All to Cart" or "Add Checked to Cart" viewing an order in ecommerce
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-3881
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3881
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: Release Branch 10.04, SVN trunk
>         Environment: ALL
>            Reporter: David - DiSiD Technologies
>
> 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:
> {panel:title=:ERROR MESSAGE:| borderStyle=solid| borderColor=#000| titleBGColor=#cc6666| bgColor=#fff}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.))){panel}
> 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"

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.