[ https://issues.apache.org/jira/browse/OFBIZ-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-3881. ---------------------------------- Resolution: Fixed Fix Version/s: SVN trunk Release Branch 10.04 Release Branch 09.04 Assignee: Jacques Le Roux Thanks Sascha, Your patch is in trunk at r1058488, R10.04 at r1058491, R9.04 at r1058492 Thanks David for report > 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 > Assignee: Jacques Le Roux > Fix For: Release Branch 09.04, Release Branch 10.04, SVN trunk > > 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.