Uploaded image for project: 'Crowd'
  1. Crowd
  2. CWD-310

Mail Template size is limited to 255 characters

    XMLWordPrintable

Details

    • Suggestion
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • 2.0
    • Core features, Database
    • None
    • Standalone Version, JDK 1.5.0_08, MSSQL 2005 SP2
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      When i try to update the mail template with a slightly longer version i get a java exception:

      00:34:58,164 ERROR 500ErrorPage: Exception caught in 500 page Hibernate operation: could not update: com.atlassian.crowd.model.property.Property#15; uncategorized SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: com.atlassian.crowd.model.property.Property#15; uncategorized SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
      java.sql.DataTruncation: Data truncation
      ...

      I looked at the SERVERPROPERTY table, and the column VALUE is set to varchar(255), and my template is longer than 255 chars.
      255 chars is a harsh limit for a e-mail template.

      Could you please increase the varchar size to something more usable?

      Attachments

        Issue Links

          Activity

            People

              justin@atlassian.com Justin Koke
              c5e1f1874f20 Toni Birrer
              Votes:
              12 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: