[jira] [Commented] (OFBIZ-4903) addition of item to shopping list is not working

[Nicolas Malin (Jira)]

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

Jacques Le Roux commented on OFBIZ-4903:
----------------------------------------

This is because r1293379 has not been  backported to R12.04 (OFBIZ-4589). But I will not backport before fixing other related issues we currently have on trunk (related to r1178344)...

> addition of item to shopping list is not working
> ------------------------------------------------
>
>                 Key: OFBIZ-4903
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4903
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party, specialpurpose/ecommerce
>    Affects Versions: Release Branch 12.04
>         Environment: Ofbiz 12.04 r133603 on Ubuntu 10.04.4 LTS
>            Reporter: Ivan Cauchi
>            Priority: Minor
>
> When attempting to add an item to a shopping list, the transaction fails, both when accessed through the ecommerce or the party manager application, with the following error:
> The Following Errors Occurred:
> ERROR: Could not complete the Create a ShoppingList Item [file:/home/xxxxxxx/ofbiz/branches/trunk/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml#createShoppingListItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ShoppingListItem][createdStamp,2012-05-28 18:57:53.715(java.sql.Timestamp)][createdTxStamp,2012-05-28 18:57:53.694(java.sql.Timestamp)][lastUpdatedStamp,2012-05-28 18:57:53.715(java.sql.Timestamp)][lastUpdatedTxStamp,2012-05-28 18:57:53.694(java.sql.Timestamp)][productId,test(java.lang.String)][quantity,1(java.math.BigDecimal)][shoppingListId,10000(java.lang.String)][shoppingListItemSeqId,00001(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SHOPPING_LIST_ITEM (SHOPPING_LIST_ID, SHOPPING_LIST_ITEM_SEQ_ID, PRODUCT_ID, QUANTITY, MODIFIED_PRICE, RESERV_START, RESERV_LENGTH, RESERV_PERSONS, QUANTITY_PURCHASED, CONFIG_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SHOPPING_LIST_ITEM' caused a violation of foreign key constraint 'SHLIST_ITEM_PROD' for key (test). The statement has been rolled back.))]

--
This message was sent by Atlassian JIRA
(v6.1#6144)