[ https://issues.apache.org/jira/browse/OFBIZ-4903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795297#comment-13795297 ]
Jacques Le Roux commented on OFBIZ-4903: ---------------------------------------- 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.))] -- This message was sent by Atlassian JIRA (v6.1#6144)