Ivan Cauchi created OFBIZ-4903:
----------------------------------
Summary: 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
