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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Agile

                Completed Sprint:
                2016 - OFBiz Community Day 4 ended 22/Dec/16
                View on Board

                Slack

                  Issue deployment