You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Babu Sreekanth (JIRA)" <ji...@apache.org> on 2010/02/15 17:05:27 UTC
[jira] Created: (OFBIZ-3479) create category through Ofbiz setup
throws truncation error
create category through Ofbiz setup throws truncation error
-----------------------------------------------------------
Key: OFBIZ-3479
URL: https://issues.apache.org/jira/browse/OFBIZ-3479
Project: OFBiz
Issue Type: Bug
Affects Versions: SVN trunk
Reporter: Babu Sreekanth
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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-3479) create category through Ofbiz setup
throws truncation error
Posted by "Babu Sreekanth (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-3479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Babu Sreekanth updated OFBIZ-3479:
----------------------------------
Attachment: screenshot.1.png
Screenshot
> create category through Ofbiz setup throws truncation error
> -----------------------------------------------------------
>
> Key: OFBIZ-3479
> URL: https://issues.apache.org/jira/browse/OFBIZ-3479
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: SVN trunk
> Reporter: Babu Sreekanth
> 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.