"Data too long for column" errors

[Tim Stoel]

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 Rufle-2]

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
[hidden email]
O:480-626-8022
Yahoo IM: stephen_rufle
AOL IM: stephen1rufle

[Tim Stoel]

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 <[hidden email]>
Organization: Salmon LLC
Reply-To: <[hidden email]>
Date: Fri, 12 Aug 2011 12:21:59 -0700
To: <[hidden email]>
Cc: Tim Stoel <[hidden email]>
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
> [hidden email]
> O:480-626-8022
> Yahoo IM: stephen_rufle
> AOL IM: stephen1rufle
>