ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Stoel <...@paserv.com>
Subject Re: "Data too long for column" errors
Date Fri, 12 Aug 2011 22:50:31 GMT
Thanks for the tip Stephen, I found that the setup wizard has no safeguard
against creating this situation, if you make the catalog ID longer than ten
characters, when “_PROMOTIONS” gets tacked on the end, it is too long.
Then, you are unable to go back and change the ID of the catalog, so I just
ran ./and clean-all and started over again, using 001 for IDs of the
catalog, store, website, etc, and it worked fine.

Tim



From: Stephen Rufle <srufle@salmonllc.com>
Organization: Salmon LLC
Reply-To: <srufle@salmonllc.com>
Date: Fri, 12 Aug 2011 12:21:59 -0700
To: <user@ofbiz.apache.org>
Cc: Tim Stoel <tim@paserv.com>
Subject: Re: "Data too long for column" errors

   
ABC-CATALOG_PROMOTIONS is greater then the default 20 chars
 
 
 On 8/12/2011 12:06 PM, Tim Stoel wrote:
>  
> I am getting this ³Data too long for column² error when adding a category. I
> tried using only one character and still get this error.  Am I making
> another parameter too long?  I am using 11.04 downloaded via SVN on
> MySQL/CentOS.  The full error reads:
> 
> Error: ERROR: Could not complete the Create an ProductCategory
> [file:/opt/release11.04/applications/product/script/org/ofbiz/product/catego
> ry/CategoryServices.xml#createProductCategory] process [problem creating the
> newEntity value: Error while inserting:
> [GenericEntity:ProductCategory][categoryName,ABC-CATALOG
> Promotions(java.lang.String)][createdStamp,2011-08-12
> 12:04:54.739(java.sql.Timestamp)][createdTxStamp,2011-08-12
> 12:04:54.69(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/C
> atalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2
> 011-08-12 12:04:54.739(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-12
> 12:04:54.69(java.sql.Timestamp)][productCategoryId,ABC-CATALOG_PROMOTIONS(ja
> va.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO PRODUCT_CATEGORY
> (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID,
> CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL,
> LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data
> too long for column 'PRODUCT_CATEGORY_ID' at row 1))]  calling service
> createProductCategory in createProductCategoryAndAddToProdCatalog
> 
> Thanks,
> Tim
> 
>  
>  
>  
> -- 
> Stephen P Rufle
> srufle@salmonllc.com
> O:480-626-8022
> Yahoo IM: stephen_rufle
> AOL IM: stephen1rufle
>  


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message