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
