[
https://issues.apache.org/jira/browse/OFBIZ-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sascha Rodekamp updated OFBIZ-3881:
-----------------------------------
Attachment: OFBIZ-3881_FixTheAddAllFunctionInOrderHistory.patch
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
> 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
> Attachments: OFBIZ-3881_FixTheAddAllFunctionInOrderHistory.patch
>
>
> 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.
