Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-7683

Error occurred when making Shopping list public/private from Party Detail screen

    Details

    • Sprint:
      2016 - OFBiz Community Day 4

      Description

      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 -

      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))
      

      Here is the reference link -
      https://ofbiz-vm.apache.org:8443/partymgr/control/editShoppingList?partyId=Company

        Attachments

        1. OFBIZ-7683-14.12.patch
          0.8 kB
          Ankit Joshi
        2. OFBIZ-7683-trunk.patch
          0.8 kB
          Ankit Joshi

          Activity

            People

            • Assignee:
              mbrohl Michael Brohl
              Reporter:
              ankit.joshi Ankit Joshi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: