[
https://issues.apache.org/jira/browse/OFBIZ-3479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashish Vijaywargiya updated OFBIZ-3479:
---------------------------------------
Priority: Minor (was: Major)
Issue Type: Wish (was: Bug)
This is not the bug. There is configuration settings that user can do in
fieldType*.xml file and increase the length of any database field. Here * can
represent mysql, derby, postgres, mssql etc.
> create category through Ofbiz setup throws truncation error
> -----------------------------------------------------------
>
> Key: OFBIZ-3479
> URL: https://issues.apache.org/jira/browse/OFBIZ-3479
> Project: OFBiz
> Issue Type: Wish
> Components: commonext/setup
> Affects Versions: Trunk
> Reporter: Babu Sreekanth
> Priority: Minor
> Attachments: screenshot.1.png
>
>
> Please find the description from the maiing list message:
> I found an issue with create category. The screen shot is attached. The
> scenario is.
> 1. Through the setup application (ofbiz setup), created an organization
> 2. Added Facility, Product store etc. and came to the last section 'First
> product"
> 3. Created a product catalog , then tried to create a category. It throws the
> below exception.
> A TRUNCATION ERROR WAS ENCOUNTERED TRYING TO SHRINK VARCHAR
> 'ABJ_CATALOG_PROMOTIONS' TO LENGTH 20.
> CALLING SERVICE CREATEPRODUCTCATEGORY IN
> CREATEPRODUCTCATEGORYANDADDTOPRODCATALOG
> The issue was on SVN trun, retrieved on 02/12/2010 (Yesterday).
> Well the error seems to occur when it try to shrink to fit into the 20 char
> table name. In the setup UI, there is no place to give the name for catalog
> promotion table.
> Also, it is possible to create the same category through catalog manager. I
> assume it may not create promotion category like it does with ofbizsetup.
> According to Bilgin Ibryam, this should be fixed by suffixing a shorted text
> while creating a promotion category. See
> http://n4.nabble.com/Issue-with-create-category-Raising-Jira-issue-tt1554760.html#a1554760
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
