Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
3.13.4, 5.0.2, 5.0.5, 5.2.9, 6.0.6, 6.3.4, 6.4
-
Java Version 1.5.0_15
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.5.0_15-b04
System Encoding ISO-8859-1
Operating System Linux 2.6.5-7.311-smp (SLES9)
OS Architecture amd64
Application Server Container Apache Tomcat/5.5.26
Database version 5.1.24-rc-community
Database driver MySQL-AB JDBC Driver mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
External user management ON
Crowd integration ONJava Version 1.5.0_15 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.5.0_15-b04 System Encoding ISO-8859-1 Operating System Linux 2.6.5-7.311-smp (SLES9) OS Architecture amd64 Application Server Container Apache Tomcat/5.5.26 Database version 5.1.24-rc-community Database driver MySQL-AB JDBC Driver mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) External user management ON Crowd integration ON
-
3.13
-
Description
For a JIRA installation using MySQL (in strict mode), a URL entered into a custom field of type "URL Field" longer than 255 characters will lead to a GenericEntityException with error message Data truncation: Data too long for column 'STRINGVALUE' at row 1.
If this happens during a workflow transition, an integrity check is needed (assuming no transactional database backend) - quite bothersome.
I believe this is due to the fact that the length of the entry is not checked and stored with PersistenceFieldType TYPE_LIMITED_TEXT.
Workarounds are of course a custom validator for said type or a custom extensions of it performing the validation. However I really think this should be fixed within JIRA, perhaps by a change of the persistance type, as URLs can get long.
Another possible workaround would be to edit edit-basictext.vm to include a maxLength-attribute. The downside of this is that pasted content will be truncated silently.
Attachments
Issue Links
- has a derivative of
-
JRASERVER-66070 URL Field should support more than 255 characters
- Gathering Interest
- is duplicated by
-
-
- Closed
-
-
-
- Gathering Impact
-
