E-mail Templates are only a single character

RT Users
1

I applied the following (sql.queries output) to our RT database (mysql
4.1.18) and now my e-mail templates only list a single character. It
appears to be the first character of the template. Like S or R.

ALTER DATABASE rt3 DEFAULT CHARACTER SET utf8;
ALTER TABLE ACL DEFAULT CHARACTER SET utf8;
ALTER TABLE Attachments DEFAULT CHARACTER SET utf8;
ALTER TABLE Attachments MODIFY Subject VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Subject VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY ContentType VARBINARY(80) NULL DEFAULT
NULL;
ALTER TABLE Attachments MODIFY ContentType VARCHAR(80) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Filename VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE Attachments MODIFY Filename VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Headers LONGBLOB NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Headers LONGTEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Attachments MODIFY MessageId VARBINARY(160) NULL DEFAULT
NULL;
ALTER TABLE Attachments MODIFY MessageId VARCHAR(160) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY ContentEncoding VARBINARY(80) NULL
DEFAULT NULL;
ALTER TABLE Attachments MODIFY ContentEncoding VARCHAR(80) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Attributes DEFAULT CHARACTER SET utf8;
ALTER TABLE Attributes MODIFY ContentType VARBINARY(16) NULL DEFAULT
NULL;
ALTER TABLE Attributes MODIFY ContentType VARCHAR(16) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Attributes MODIFY Content BLOB NULL DEFAULT NULL;
ALTER TABLE Attributes MODIFY Description VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE Attributes MODIFY Description VARCHAR(255) CHARACTER SET
utf8 NULL DEFAULT NULL;
ALTER TABLE Attributes MODIFY Name VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Attributes MODIFY Name VARCHAR(255) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Attributes MODIFY ObjectType VARBINARY(64) NULL DEFAULT
NULL;
ALTER TABLE Attributes MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE CustomFields DEFAULT CHARACTER SET utf8;
ALTER TABLE CustomFields MODIFY Pattern BLOB NULL DEFAULT NULL;
ALTER TABLE CustomFields MODIFY Pattern TEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL
DEFAULT ‘’;
ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET
ascii NOT NULL DEFAULT ‘’;
ALTER TABLE CustomFields MODIFY Type VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE CustomFields MODIFY Type VARCHAR(200) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE CustomFields MODIFY Description VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE CustomFields MODIFY Description VARCHAR(255) CHARACTER SET
utf8 NULL DEFAULT NULL;
ALTER TABLE CustomFields MODIFY Name VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE CustomFields MODIFY Name VARCHAR(200) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE CustomFieldValues DEFAULT CHARACTER SET utf8;
ALTER TABLE CustomFieldValues MODIFY Description VARBINARY(255) NULL
DEFAULT NULL;
ALTER TABLE CustomFieldValues MODIFY Description VARCHAR(255) CHARACTER
SET utf8 NULL DEFAULT NULL;
ALTER TABLE CustomFieldValues MODIFY Name VARBINARY(200) NULL DEFAULT
NULL;
ALTER TABLE CustomFieldValues MODIFY Name VARCHAR(200) CHARACTER SET
utf8 NULL DEFAULT NULL;
ALTER TABLE GroupMembers DEFAULT CHARACTER SET utf8;
ALTER TABLE Groups DEFAULT CHARACTER SET utf8;
ALTER TABLE Groups MODIFY Domain VARBINARY(64) NULL DEFAULT NULL;
ALTER TABLE Groups MODIFY Domain VARCHAR(64) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Groups MODIFY Type VARBINARY(64) NULL DEFAULT NULL;
ALTER TABLE Groups MODIFY Type VARCHAR(64) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Groups MODIFY Description VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Groups MODIFY Description VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Groups MODIFY Name VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE Groups MODIFY Name VARCHAR(200) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Links DEFAULT CHARACTER SET utf8;
ALTER TABLE Links MODIFY Target VARBINARY(240) NULL DEFAULT NULL;
ALTER TABLE Links MODIFY Target VARCHAR(240) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Links MODIFY Base VARBINARY(240) NULL DEFAULT NULL;
ALTER TABLE Links MODIFY Base VARCHAR(240) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Links MODIFY Type VARBINARY(20) NOT NULL DEFAULT ‘’;
ALTER TABLE Links MODIFY Type VARCHAR(20) CHARACTER SET ascii NOT NULL
DEFAULT ‘’;
ALTER TABLE ObjectCustomFields DEFAULT CHARACTER SET utf8;
ALTER TABLE ObjectCustomFieldValues DEFAULT CHARACTER SET utf8;
ALTER TABLE ObjectCustomFieldValues MODIFY ContentType VARBINARY(80)
NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ContentType VARCHAR(80)
CHARACTER SET ascii NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY LargeContent LONGBLOB NULL
DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ContentEncoding VARBINARY(80)
NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ContentEncoding VARCHAR(80)
CHARACTER SET ascii NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY Content VARBINARY(255) NULL
DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY Content VARCHAR(255)
CHARACTER SET utf8 NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARBINARY(255) NOT
NULL DEFAULT ‘’;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARCHAR(255)
CHARACTER SET ascii NOT NULL DEFAULT ‘’;
ALTER TABLE Principals DEFAULT CHARACTER SET utf8;
ALTER TABLE Principals MODIFY PrincipalType VARBINARY(16) NOT NULL
DEFAULT ‘’;
ALTER TABLE Principals MODIFY PrincipalType VARCHAR(16) CHARACTER SET
ascii NOT NULL DEFAULT ‘’;
ALTER TABLE Queues DEFAULT CHARACTER SET utf8;
ALTER TABLE Queues MODIFY CorrespondAddress VARBINARY(120) NULL DEFAULT
NULL;
ALTER TABLE Queues MODIFY CorrespondAddress VARCHAR(120) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Queues MODIFY CommentAddress VARBINARY(120) NULL DEFAULT
NULL;
ALTER TABLE Queues MODIFY CommentAddress VARCHAR(120) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Queues MODIFY Description VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Queues MODIFY Description VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Queues MODIFY Name VARBINARY(200) NOT NULL DEFAULT ‘’;
ALTER TABLE Queues MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL
DEFAULT ‘’;
ALTER TABLE ScripActions DEFAULT CHARACTER SET utf8;
ALTER TABLE ScripActions MODIFY Argument VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE ScripActions MODIFY ExecModule VARBINARY(60) NULL DEFAULT
NULL;
ALTER TABLE ScripActions MODIFY ExecModule VARCHAR(60) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE ScripActions MODIFY Description VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE ScripActions MODIFY Description VARCHAR(255) CHARACTER SET
utf8 NULL DEFAULT NULL;
ALTER TABLE ScripActions MODIFY Name VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE ScripActions MODIFY Name VARCHAR(200) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE ScripConditions DEFAULT CHARACTER SET utf8;
ALTER TABLE ScripConditions MODIFY ApplicableTransTypes VARBINARY(60)
NULL DEFAULT NULL;
ALTER TABLE ScripConditions MODIFY ApplicableTransTypes VARCHAR(60)
CHARACTER SET ascii NULL DEFAULT NULL;
ALTER TABLE ScripConditions MODIFY Argument VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE ScripConditions MODIFY ExecModule VARBINARY(60) NULL DEFAULT
NULL;
ALTER TABLE ScripConditions MODIFY ExecModule VARCHAR(60) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE ScripConditions MODIFY Description VARBINARY(255) NULL
DEFAULT NULL;
ALTER TABLE ScripConditions MODIFY Description VARCHAR(255) CHARACTER
SET utf8 NULL DEFAULT NULL;
ALTER TABLE ScripConditions MODIFY Name VARBINARY(200) NULL DEFAULT
NULL;
ALTER TABLE ScripConditions MODIFY Name VARCHAR(200) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Scrips DEFAULT CHARACTER SET utf8;
ALTER TABLE Scrips MODIFY CustomPrepareCode BLOB NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY CustomPrepareCode TEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Scrips MODIFY CustomIsApplicableCode BLOB NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY CustomIsApplicableCode TEXT CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY ActionRules BLOB NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY ActionRules TEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Scrips MODIFY CustomCommitCode BLOB NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY CustomCommitCode TEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Scrips MODIFY Stage VARBINARY(32) NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY Stage VARCHAR(32) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Scrips MODIFY Description VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY Description VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY ConditionRules BLOB NULL DEFAULT NULL;
ALTER TABLE Scrips MODIFY ConditionRules TEXT CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE sessions DEFAULT CHARACTER SET utf8;
ALTER TABLE sessions MODIFY id VARBINARY(32) NOT NULL DEFAULT ‘’;
ALTER TABLE sessions MODIFY a_session CHAR NULL DEFAULT NULL;
ALTER TABLE Templates DEFAULT CHARACTER SET utf8;
ALTER TABLE Templates MODIFY Type VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Type VARCHAR(16) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Templates MODIFY Language VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Language VARCHAR(16) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Content CHAR NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Content BLOB NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Description VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE Templates MODIFY Description VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Templates MODIFY Name VARBINARY(200) NOT NULL DEFAULT ‘’;
ALTER TABLE Templates MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT
NULL DEFAULT ‘’;
ALTER TABLE Tickets DEFAULT CHARACTER SET utf8;
ALTER TABLE Tickets MODIFY Status VARBINARY(10) NULL DEFAULT NULL;
ALTER TABLE Tickets MODIFY Status VARCHAR(10) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Tickets MODIFY Type VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Tickets MODIFY Type VARCHAR(16) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Tickets MODIFY Subject VARBINARY(200) NULL DEFAULT ‘[no
subject]’;
ALTER TABLE Tickets MODIFY Subject VARCHAR(200) CHARACTER SET utf8 NULL
DEFAULT ‘[no subject]’;
ALTER TABLE Transactions DEFAULT CHARACTER SET utf8;
ALTER TABLE Transactions MODIFY Field VARBINARY(40) NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY Field VARCHAR(40) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY Type VARBINARY(20) NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY Type VARCHAR(20) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY OldValue VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE Transactions MODIFY OldValue VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY NewValue VARBINARY(255) NULL DEFAULT
NULL;
ALTER TABLE Transactions MODIFY NewValue VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ReferenceType VARBINARY(255) NULL
DEFAULT NULL;
ALTER TABLE Transactions MODIFY ReferenceType VARCHAR(255) CHARACTER SET
ascii NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY Data VARBINARY(100) NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY Data VARCHAR(100) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARBINARY(64) NOT NULL
DEFAULT ‘’;
ALTER TABLE Transactions MODIFY ObjectType VARCHAR(64) CHARACTER SET
ascii NOT NULL DEFAULT ‘’;
ALTER TABLE Users DEFAULT CHARACTER SET utf8;
ALTER TABLE Users MODIFY WebEncoding VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY WebEncoding VARCHAR(16) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Users MODIFY AuthSystem VARBINARY(30) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY AuthSystem VARCHAR(30) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY PGPKey BLOB NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Password VARBINARY(40) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY MobilePhone VARBINARY(30) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY MobilePhone VARCHAR(30) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY WorkPhone VARBINARY(30) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY WorkPhone VARCHAR(30) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY PagerPhone VARBINARY(30) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY PagerPhone VARCHAR(30) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY ExternalContactInfoId VARBINARY(100) NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY ExternalContactInfoId VARCHAR(100) CHARACTER
SET utf8 NULL DEFAULT NULL;
ALTER TABLE Users MODIFY ContactInfoSystem VARBINARY(30) NULL DEFAULT
NULL;
ALTER TABLE Users MODIFY ContactInfoSystem VARCHAR(30) CHARACTER SET
utf8 NULL DEFAULT NULL;
ALTER TABLE Users MODIFY HomePhone VARBINARY(30) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY HomePhone VARCHAR(30) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Address1 VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Address1 VARCHAR(200) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY ExternalAuthId VARBINARY(100) NULL DEFAULT
NULL;
ALTER TABLE Users MODIFY ExternalAuthId VARCHAR(100) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Comments CHAR NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Comments BLOB NULL DEFAULT NULL;
ALTER TABLE Users MODIFY NickName VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY NickName VARCHAR(16) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Address2 VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Address2 VARCHAR(200) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Timezone VARBINARY(50) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Timezone VARCHAR(50) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY FreeformContactInfo CHAR NULL DEFAULT NULL;
ALTER TABLE Users MODIFY FreeformContactInfo BLOB NULL DEFAULT NULL;
ALTER TABLE Users MODIFY RealName VARBINARY(120) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY RealName VARCHAR(120) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY City VARBINARY(100) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY City VARCHAR(100) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY EmailAddress VARBINARY(120) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY EmailAddress VARCHAR(120) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Users MODIFY EmailEncoding VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY EmailEncoding VARCHAR(16) CHARACTER SET ascii
NULL DEFAULT NULL;
ALTER TABLE Users MODIFY State VARBINARY(100) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY State VARCHAR(100) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Signature CHAR NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Signature BLOB NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Zip VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Zip VARCHAR(16) CHARACTER SET utf8 NULL DEFAULT
NULL;
ALTER TABLE Users MODIFY Organization VARBINARY(200) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Organization VARCHAR(200) CHARACTER SET utf8
NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Lang VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Lang VARCHAR(16) CHARACTER SET ascii NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Gecos VARBINARY(16) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Gecos VARCHAR(16) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Country VARBINARY(50) NULL DEFAULT NULL;
ALTER TABLE Users MODIFY Country VARCHAR(50) CHARACTER SET utf8 NULL
DEFAULT NULL;
ALTER TABLE Users MODIFY Name VARBINARY(200) NOT NULL DEFAULT ‘’;
ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL
DEFAULT ‘’;

I went through each of the templates and updated them with the full
text, but upon creating a ticket, rt logs the following:

[Fri Oct 17 14:27:56 2008] [debug]: About to think about scrips for
transaction #2056453 (/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:163)
[Fri Oct 17 14:27:56 2008] [debug]: Committing scrip #108 on txn
#2056452 of ticket #255478
(/opt/rt3/bin/…/lib/RT/Scrips_Overlay.pm:190)
[Fri Oct 17 14:27:56 2008] [info]: Auto assign ticket #255478 to user
#1177810 ((eval 608):11)
[Fri Oct 17 14:27:56 2008] [debug]: About to think about scrips for
transaction #2056454 (/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:163)
[Fri Oct 17 14:27:56 2008] [debug]: About to prepare scrips for
transaction #2056454 (/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:167)
[Fri Oct 17 14:27:56 2008] [debug]: Found 2 scrips for TransactionCreate
stage with applicable type(s) Give
(/opt/rt3/bin/…/lib/RT/Scrips_Overlay.pm:370)
[Fri Oct 17 14:27:56 2008] [error]: Template parsing error: Can’t find
string terminator “’” anywhere before EOF at template line 11.

Stack:
[template:11]
[/opt/rt3/bin/…/lib/RT/Template_Overlay.pm:432]
[/opt/rt3/bin/…/lib/RT/Template_Overlay.pm:336]
[/opt/rt3/bin/…/lib/RT/Template_Overlay.pm:312]
[/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:158]
[/opt/rt3/bin/…/lib/RT/Action/Notify.pm:69]
[/opt/rt3/bin/…/lib/RT/ScripAction_Overlay.pm:230]
[/opt/rt3/bin/…/lib/RT/Scrip_Overlay.pm:435]
[/opt/rt3/bin/…/lib/RT/Scrips_Overlay.pm:240]
[/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:169]
[/opt/rt3/bin/…/lib/RT/Record.pm:1419]
[/opt/rt3/bin/…/lib/RT/Ticket_Overlay.pm:2796]
[(eval 608):12]
[/opt/rt3/bin/…/lib/RT/ScripAction_Overlay.pm:238]
[/opt/rt3/bin/…/lib/RT/Scrip_Overlay.pm:464]
[/opt/rt3/bin/…/lib/RT/Scrips_Overlay.pm:196]
[/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:177]
[/opt/rt3/bin/…/lib/RT/Record.pm:1419]
[/opt/rt3/bin/…/lib/RT/Ticket_Overlay.pm:3250]
[/opt/rt3/bin/…/lib/RT/Ticket_Overlay.pm:2961]

[/opt/rt3/bin/…/local/lib/RT/Interface/Email/Filter/TakeAction.pm:607]

[/opt/rt3/bin/…/local/lib/RT/Interface/Email/Filter/TakeAction.pm:409]
[/opt/rt3/bin/…/lib/RT/Interface/Email.pm:1274]
[/opt/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61]
(/opt/rt3/bin/…/lib/RT/Template_Overlay.pm:427)
[Fri Oct 17 14:27:56 2008] [debug]: About to commit scrips for
transaction #2056454 (/opt/rt3/bin/…/lib/RT/Transaction_Overlay.pm:176)

2

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. :slight_smile:

— cut —

3

Thanks I will check this. As it appears that my templates are hosed, could you send me a copy of the “Content” for one of your templates, say Autoreply? I pulled the data from initialdata, but rt.log spits an error:

Template parsing error: Can't find string terminator "'" anywhere before EOF at template line 4.

Somewhere I am missing a separator-----Original Message-----
From: Panu [mailto:panu@colorplaza.com]
Sent: Friday, October 17, 2008 11:19 AM
To: rt-users@lists.bestpractical.com
Cc: Timothy Butkiewicz
Subject: Re: E-mail Templates are only a single character

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. :slight_smile:

— cut —

4

I’ve managed to get the templates working, but e-mail does not appear to be generating on certain scrips and queues. I am seeing this in the log:

[Fri Oct 17 17:15:13 2008] [debug]: Working on mailfield Bcc; recipients are (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:640)
[Fri Oct 17 17:15:13 2008] [debug]: Subject: subject
norm message headers
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8 (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:647)
[Fri Oct 17 17:15:13 2008] [debug]: Removing deferred recipients from Bcc: line (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:670)
[Fri Oct 17 17:15:13 2008] [debug]: Setting deferred recipients for attribute creation (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:679)
[Fri Oct 17 17:15:13 2008] [debug]: No recipients found for deferred delivery on transaction #2056671 (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:692)

Appears that RT isn’t picking up the watcher recipients

5

Timothy,

There could be a couple reasons for this. For example, if the scrip

action is “Notify Others” and you only have Watcher CC’s, then they
don’t get included. There is a distinction between “Watcher” CC’s,
Others (added CC’s at the time of clicking “Update” when in Reply) and
also, CC’s that are on a ticket only. Hope this helps.

Kenn
LBNLOn 10/17/2008 10:18 AM, Timothy Butkiewicz wrote:

I’ve managed to get the templates working, but e-mail does not appear to be generating on certain scrips and queues. I am seeing this in the log:

[Fri Oct 17 17:15:13 2008] [debug]: Working on mailfield Bcc; recipients are (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:640)
[Fri Oct 17 17:15:13 2008] [debug]: Subject: subject
norm message headers
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=“utf-8”
X-RT-Original-Encoding: utf-8 (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:647)
[Fri Oct 17 17:15:13 2008] [debug]: Removing deferred recipients from Bcc: line (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:670)
[Fri Oct 17 17:15:13 2008] [debug]: Setting deferred recipients for attribute creation (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:679)
[Fri Oct 17 17:15:13 2008] [debug]: No recipients found for deferred delivery on transaction #2056671 (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:692)

Appears that RT isn’t picking up the watcher recipients

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com