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

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

        Activity

        Hide
        ankit.joshi Ankit Joshi added a comment -

        Here is the patch with proper fix for the issue.

        Show
        ankit.joshi Ankit Joshi added a comment - Here is the patch with proper fix for the issue.
        Hide
        mbrohl Michael Brohl added a comment -

        Thanks, Ankit,

        your patches are in
        trunk r1774772,
        release branch 14.12 r1774775

        Show
        mbrohl Michael Brohl added a comment - Thanks, Ankit, your patches are in trunk r1774772, release branch 14.12 r1774775
        Hide
        pfm.smits Pierre Smits added a comment -

        It seems to me that this issue should be reopened as release branches 15.12. (as stated in the 'Affect Version(s)) and 16.11 are affected. And the solution also applies to those branches.

        Show
        pfm.smits Pierre Smits added a comment - It seems to me that this issue should be reopened as release branches 15.12. (as stated in the 'Affect Version(s)) and 16.11 are affected. And the solution also applies to those branches.
        Hide
        mbrohl Michael Brohl added a comment -

        Pierre is right, I'll backport to 15.12 and 16.11.

        Show
        mbrohl Michael Brohl added a comment - Pierre is right, I'll backport to 15.12 and 16.11.
        Hide
        mbrohl Michael Brohl added a comment -

        Also backported to release branches
        15.12 r1774778
        16.11 r1774783

        Show
        mbrohl Michael Brohl added a comment - Also backported to release branches 15.12 r1774778 16.11 r1774783

          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:

              Development

                Agile