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

Mail Template size is limited to 255 characters

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • 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.

      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?

            [CWD-310] Mail Template size is limited to 255 characters

            SarahA added a comment -

            Fixed spelling in title

            SarahA added a comment - Fixed spelling in title

            Justin Koke added a comment -

            This issue has been fixed by CWD-1507

            Justin Koke added a comment - This issue has been fixed by CWD-1507

            Brian Topping added a comment -

            Heh, great call on the schema edit.

            Brian Topping added a comment - Heh, great call on the schema edit.

            Toni Birrer added a comment -

            Thats what I did, and so far it is working fine for me.

            Toni Birrer added a comment - Thats what I did, and so far it is working fine for me.

            John Ryan added a comment -

            I have the same problem.
            Can I just alter the database table without breaking anything else?

            John Ryan added a comment - I have the same problem. Can I just alter the database table without breaking anything else?

            Jason Coward added a comment -

            I have to agree, this is absolutely unusable as is, and with it being SSO, it is absolutely critical that I can get important information to the users I am adding when I reset their passwords. This is 41 weeks old and still isn't addressed? What I need to do to get around this for now, and can this please be fixed for the next release?

            Jason Coward added a comment - I have to agree, this is absolutely unusable as is, and with it being SSO, it is absolutely critical that I can get important information to the users I am adding when I reset their passwords. This is 41 weeks old and still isn't addressed? What I need to do to get around this for now, and can this please be fixed for the next release?

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

                Created:
                Updated:
                Resolved: