> 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 13.07, Release Branch 14.12, Trunk, Release Branch 15.12
> Reporter: Ankit Joshi
> Assignee: Ankit Joshi
> Attachments: OFBIZ-7683-14.12.patch, OFBIZ-7683-trunk.patch
>
>
> 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
Locked
