[
https://issues.apache.org/jira/browse/OFBIZ-4903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-4903.
----------------------------------
> 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)
