> ALTER TABLE Templates MODIFY Content CHAR NULL DEFAULT NULL; > ALTER TABLE Templates MODIFY Content BLOB NULL DEFAULT NULL;
I think this is the problem. I had the same happening to me. Ole Graig told me the following: --- cut --- the sql.queries file that I got out of running "etc/upgrade/schema.mysql-4.0-4.1.pl" contained some destructive transforms that I had to change. Several multi-character fields were temporarily transformed into type CHAR, which truncated them to a single character. Check your sql.queries file (e.g. 'grep " CHAR " sql.queries) and make sure you're not hitting the same thing; in my case, one of the fields that was thus truncated was in fact this same Templates.Content field. RT's templates don't work so good when they consist of only one character. :-) --- cut --- _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com