[OFBiz] Users - Creating a new Shopping list

[Nguyen Minh Triet]

Hi,

I am getting the following error when creating a new Shopping list:


ERROR: Could not complete the Create a ShoppingList process [problem
creating the newEntity value: Exception while inserting the following
entity: [GenericEntity:ShoppingList][createdStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][createdTxStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][isA
ctive,Y(java.lang.String)][isPublic,N(java.lang.String)][lastUpdatedStam
p,2005-03-21
13:48:58.218(java.sql.Timestamp)][lastUpdatedTxStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][listName,New Shopping
List(java.lang.String)][partyId,10022(java.lang.String)][productStoreId,
9000(java.lang.String)][shoppingListId,10010(java.lang.String)][shopping
ListTypeId,SLT_WISH_LIST(java.lang.String)] (while inserting:
[GenericEntity:ShoppingList][createdStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][createdTxStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][isA
ctive,Y(java.lang.String)][isPublic,N(java.lang.String)][lastUpdatedStam
p,2005-03-21
13:48:58.218(java.sql.Timestamp)][lastUpdatedTxStamp,2005-03-21
13:48:58.218(java.sql.Timestamp)][listName,New Shopping
List(java.lang.String)][partyId,10022(java.lang.String)][productStoreId,
9000(java.lang.String)][shoppingListId,10010(java.lang.String)][shopping
ListTypeId,SLT_WISH_LIST(java.lang.String)] (SQL Exception while
executing the following:INSERT INTO SHOPPING_LIST (SHOPPING_LIST_ID,
SHOPPING_LIST_TYPE_ID, PARENT_SHOPPING_LIST_ID, PRODUCT_STORE_ID,
VISITOR_ID, PARTY_ID, LIST_NAME, DESCRIPTION, IS_PUBLIC, IS_ACTIVE,
CURRENCY_UOM, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID,
CARRIER_ROLE_TYPE_ID, CONTACT_MECH_ID, PAYMENT_METHOD_ID,
RECURRENCE_INFO_ID, LAST_ORDERED_DATE, LAST_ADMIN_MODIFIED,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (Incorrect arguments to mysql_stmt_execute)))]


The logs say:





Minh