OFBiz
  1. OFBiz
  2. OFBIZ-3479

create category through Ofbiz setup throws truncation error

    Details

    • Type: Wish Wish
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Invalid
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: commonext/setup
    • Labels:
      None

      Description

      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

      1. screenshot.1.png
        52 kB
        Babu Sreekanth

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        1677d 22h 36m 1 Ashish Vijaywargiya 20/Sep/14 15:40
        In Progress In Progress Closed Closed
        1m 12s 1 Ashish Vijaywargiya 20/Sep/14 15:41
        Ashish Vijaywargiya made changes -
        Status In Progress [ 3 ] Closed [ 6 ]
        Resolution Invalid [ 6 ]
        Hide
        Ashish Vijaywargiya added a comment -

        Please refer my comment on the jira issue for configuration settings. This is invalid issue.

        Show
        Ashish Vijaywargiya added a comment - Please refer my comment on the jira issue for configuration settings. This is invalid issue.
        Ashish Vijaywargiya made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Ashish Vijaywargiya made changes -
        Assignee Ashish Vijaywargiya [ toashishvijay ]
        Ashish Vijaywargiya made changes -
        Issue Type Bug [ 1 ] Wish [ 5 ]
        Priority Major [ 3 ] Minor [ 4 ]
        Hide
        Ashish Vijaywargiya added a comment -

        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.

        Show
        Ashish Vijaywargiya added a comment - 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.
        Christian Geisert made changes -
        Component/s commonext/setup [ 12313162 ]
        Gavin made changes -
        Workflow jira [ 12499042 ] OFbiz Workflow [ 12507312 ]
        Babu Sreekanth made changes -
        Field Original Value New Value
        Attachment screenshot.1.png [ 12435882 ]
        Hide
        Babu Sreekanth added a comment -

        Screenshot

        Show
        Babu Sreekanth added a comment - Screenshot
        Babu Sreekanth created issue -

          People

          • Assignee:
            Ashish Vijaywargiya
            Reporter:
            Babu Sreekanth
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development