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

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3389225 ] New: JAC Suggestion Workflow 3 [ 3629646 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1393298 ] New: JAC Suggestion Workflow [ 3389225 ]
            Issue Type Original: Improvement [ 4 ] New: Suggestion [ 10000 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 272861 ] New: Simplified Crowd Development Workflow v2 [ 1393298 ]
            jawong.adm made changes -
            Workflow Original: Feature Request Workflow [ 174502 ] New: Crowd Development Workflow v2 [ 272861 ]
            Justin Koke made changes -
            Link New: This issue is duplicated by CWD-1635 [ CWD-1635 ]
            SarahA made changes -
            Summary Original: Mail Template size is limted to 255 characters New: 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 made changes -
            Workflow Original: jira [ 81055 ] New: Feature Request Workflow [ 174502 ]
            Justin Koke made changes -
            Assignee Original: Justen Stepka [Atlassian] [ justen.stepka@atlassian.com ] New: Justin Koke [ justin@atlassian.com ]
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]

            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

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

                Created:
                Updated:
                Resolved: