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.
