Error Saving New Mail Template In Crowd 1.x
The following error is thrown when saving a new mail template:
SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state ; error code ; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
The Mail Template supports a maximum of 255 characters, as the data type maps to Varchar(255).
The recent schema changes in Crowd 2.0, changed the data type to a CLOB and it's now possible to store up to 4000 characters in the column.
Upgrade to the latest Crowd release for a fix.