Adding a custom field option value with more than 255 characters results on a 500 error page

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 7.13.18, 8.3.1, 8.13.0
    • None
    • 7.13
    • 5
    • Severity 3 - Minor
    • 0

      Issue Summary

      When updating an option value with more than 255 characters at a "Select List (single choice)" custom field, a 500 error page is exhibited.
      The issue happens because the value exceeds the size from column "customvalue" of the table "customfieldoption".

      Steps to Reproduce

      1. Create a "Select List (single choice)" custom field with any option value.
      2. At the Jira Custom Fields management page (Administration > Issues > Custom fields), click at the Actions > Configure button for the newly created custom field.
      3. At the bottom of the page, click at the "Edit Options" link.
      4. Try to add a new Custom Field Option or edit one that already exists using a text field with more than 255 characters.
      5. A 500 error page will occur when trying to save the value

      Expected Results

      There should be a filter at the UI for these fields, limiting the field up to 255 characters.

      Actual Results

      A 500 error message containing the text below:

      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO customfieldoption (ID, CUSTOMFIELD, CUSTOMFIELDCONFIG, PARENTOPTIONID, SEQUENCE, customvalue, optiontype, disabled) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'customvalue' at row 1)
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Unassigned
            Reporter:
            Alisson Dalmago
            Votes:
            14 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated: