-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 7.13.18, 8.3.1, 8.13.0
-
Component/s: Administration - Fields
-
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
- Create a "Select List (single choice)" custom field with any option value.
- At the Jira Custom Fields management page (Administration > Issues > Custom fields), click at the Actions > Configure button for the newly created custom field.
- At the bottom of the page, click at the "Edit Options" link.
- Try to add a new Custom Field Option or edit one that already exists using a text field with more than 255 characters.
- 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