Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-28763

"Data Too Long for Column" Error With Custom URL Field

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 5.0.2, 5.0.5, 6.0-OD-11/Beta1
    • Issue - Fields

    • Sandbox: Mac OS X 10.7.4, Apache Tomcat/6.0.32, Java 1.6.0_31, MySQL 5.5.22, JIRA 5.0.2
      Production: Linux 2.6.18-128.el5, Apache Tomcat/6.0.32, Java 1.6.0_18, PostgreSQL, JIRA 5.0.5

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Custom URL Field gives the following error when the following URL is entered and saved:

      URL ENTERED
      -----------
      http://bugzilla.cobaltgroup.com/buglist.cgi?&product=INV%20AutoNames&product=INV%20AutoShow&product=INV%20Data%20Loader&product=INV%20Exports&product=INV%20ImageServer&product=INV%20Imports&product=INV%20Reference%20Data&product=INV%20Reports&product=INV%20Resolver&product=INV%20Services&target_milestone=2.0.4.2

      ERROR MESSAGE
      -------------
      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,10960][stringvalue,http://bugzilla.cobaltgroup.com/buglist.cgi?&product=INV%20AutoNames&product=INV%20AutoShow&product=INV%20Data%20Loader&product=INV%20Exports&product=INV%20ImageServer&product=INV%20Imports&product=INV%20Reference%20Data&product=INV%20Reports&product=INV%20Resolver&product=INV%20Services&target_milestone=2.0.4.2][issue,10601][parentkey,null][customfield,10610] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'STRINGVALUE' at row 1))

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-17811 "URL Field" entry longer than 255 characters causes GenericEntityException

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-28763 "Data Too Long for Column" Error With Custom URL Field

          • Low - Low priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              ac5d9cbb8cdd Mikael Sikora
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: