Ankit Joshi created OFBIZ-7683:
----------------------------------
Summary: Error occurred when making Shopping list public/private
from Party Detail screen
Key: OFBIZ-7683
URL: https://issues.apache.org/jira/browse/OFBIZ-7683
Project: OFBiz
Issue Type: Bug
Components: party
Affects Versions: Release Branch 15.12, Trunk, Release Branch 14.12,
Release Branch 13.07
Reporter: Ankit Joshi
Assignee: Ankit Joshi
Steps to regenerate
1) Navigate to party component.
2) Search parties and move to the detail page.
3) Select Shopping List tab and create shopping list for the party.
4) Try to update shopping list with public / private.
Following error occurred -
{code}
Error while updating:
[GenericEntity:ShoppingList][carrierPartyId,null()][carrierRoleTypeId,null()][contactMechId,null()][createdStamp,2016-06-30
13:57:21.0(java.sql.Timestamp)][createdTxStamp,2016-06-30
13:57:21.0(java.sql.Timestamp)][currencyUom,null()][description,null()][isActive,Y(java.lang.String)][isPublic,Yes(java.lang.String)][lastAdminModified,2016-06-30
14:03:25.0(java.sql.Timestamp)][lastOrderedDate,null()][lastUpdatedStamp,2016-06-30
14:15:21.079(java.sql.Timestamp)][lastUpdatedTxStamp,2016-06-30
14:15:21.008(java.sql.Timestamp)][listName,New Shopping
List(java.lang.String)][parentShoppingListId,null()][partyId,10000(java.lang.String)][paymentMethodId,null()][productPromoCodeId,null()][productStoreId,null()][recurrenceInfoId,null()][shipmentMethodTypeId,null()][shoppingListId,10030(java.lang.String)][shoppingListTypeId,SLT_WISH_LIST(java.lang.String)][visitorId,null()]
(SQL Exception while executing the following:UPDATE SHOPPING_LIST SET
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=?,
PRODUCT_PROMO_CODE_ID=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?,
CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE SHOPPING_LIST_ID=? (Data truncation:
Data too long for column 'IS_PUBLIC' at row 1))
{code}
Here is the reference link -
https://ofbiz-vm.apache.org:8443/partymgr/control/editShoppingList?partyId=Company
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
