Actually I already committed r1293379 in R12.04: it was before the branch freezing! :D
> 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
> Assignee: Jacques Le Roux
> Priority: Minor
> Fix For: SVN trunk
>
>
> 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.))]
Locked
