3.0.3 error: iso-8859-1

My installation of RT 3 works ok for the most time. But some e-mails
gets completely lost. I guess that it’s the use of characters like
’åäö’ on the first line of the e-mail that triggers the failure.

First where is a UTF8 error, followed by RT thinking that the queue
name is ‘’ (empty string).

I’l try to give some parts of the config and log that may be relevant:

Config

Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , ‘debug’);
Set($LogDir, ‘/usr/local/rt3/var/log’);
Set($LogToFileNamed , “$LogDir/rt.log”); #log to rt.log..

Set($TrustHTMLAttachments , undef);
@EmailInputEncodings = qw(iso-8859-1 utf-8 us-ascii) unless (@EmailEncodings);
Set($EmailOutputEncoding , ‘iso-8859-1’);

This log was generated then one e-mail was sent to the system:

[Sun Jun 29 16:54:35 2003] [debug]: Converting ‘iso-8859-1’ to ‘utf-8’ (/usr/local/rt3/lib/RT/I18N.pm:189)
[Sun Jun 29 16:54:35 2003] [debug]: Guessed encoding: ascii (/usr/local/rt3/lib/RT/I18N.pm:333)
[Sun Jun 29 16:54:35 2003] [debug]: Converting ‘ascii’ to ‘utf-8’ (/usr/local/rt3/lib/RT/I18N.pm:189)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: Invalid UNICODE character sequence found (0xe57220) at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT * FROM Tickets WHERE id
= ?’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [debug]: RT::Ticket=HASH(0xa7d5c3c) tried to load a bogus ticket: 346
(/usr/local/rt3/lib/RT/Ticket_Overlay.pm:197)
[Sun Jun 29 16:54:35 2003] [err]: RT::Transaction=HASH(0xa7d1d28) couldn’t load ticket 346
(/usr/local/rt3/lib/RT/Transaction_Overlay.pm:118)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query 'SELECT ACL.id from ACL, Groups,
Principals, CachedGroupMembers WHERE (ACL.RightName = ‘SuperUser’ OR ACL.RightName = ‘SeeQueue’) AND Principals.Disabled =
0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = ‘1’ AND ( ACL.ObjectType = ‘RT::System’ OR (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = ‘’)) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR Groups.Domain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain = ‘Personal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’
AND Groups.Instance = ‘’) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType
= ‘Group’) ) LIMIT 1’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder.pm line 145.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBIx::SearchBuilder error:ERROR: current transaction is aborted, queries ignored until end of transaction block
Query String is SELECT DISTINCT main.* FROM (Scrips main JOIN ScripConditions as ScripConditions_1 ON ( main.ScripCondition = ScripConditions_1.id)) WHERE ((ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’)OR(ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’)) AND ((main.Queue = ‘0’)) AND ((main.Stage = ‘TransactionCreate’))
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st fetchrow_hashref failed: no statement executing at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder.pm line 163.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT * FROM Tickets WHERE id
= ?’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [debug]: RT::Ticket=HASH(0xa14bf44) tried to load a bogus ticket: 346
(/usr/local/rt3/lib/RT/Ticket_Overlay.pm:197)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT ACL.id from ACL, Groups,
Principals, CachedGroupMembers WHERE (ACL.RightName = ‘SuperUser’ OR ACL.RightName = ‘SeeQueue’) AND Principals.Disabled =
0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = ‘1’ AND ( ACL.ObjectType = ‘RT::System’ OR (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = ‘1’)) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR Groups.Domain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain = ‘Personal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND Groups.Instance = ‘1’) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = ‘Group’) ) LIMIT 1’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [info]: Ticket 346 created in queue ‘’ by jonas (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:608)

And here are some maby relevant parts of the e-mail. This e-mail

had an attatchment.  But I don't think there is any problem with
the attatchment handling.  It may have to do with the 'å' on the
first line of the body:

Return-path: jonas@astral.paranormal.seTo: Redaktionen red@paranormal.se
Subject: [Jonas Liljegren] Re: [Para] =?iso-8859-1?q?Niv=E5er=3F?=
From: Jonas Liljegren jonas@liljegren.org
Date: Sun, 29 Jun 2003 14:08:37 +0200
User-Agent: Gnus/5.1002 (Gnus v5.10.2) Emacs/21.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="

Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Material f=F6r att uppdatera texten om niv=E5er.

What is wrong here?

jonas@rit.se RIT AB http://www.rit.se
Box 70, 428 21 Kållered Besök: G:a Riksvägen 36
Tel: +46 (0)31 751 8600 Fax: +46 (0)31 751 8609

Can you send me, personally (jesse@bestpractical.com) a message which
triggers this issue for you?On Sun, Jun 29, 2003 at 07:16:17PM +0200, Jonas Liljegren wrote:

My installation of RT 3 works ok for the most time. But some e-mails
gets completely lost. I guess that it’s the use of characters like
’���’ on the first line of the e-mail that triggers the failure.

First where is a UTF8 error, followed by RT thinking that the queue
name is ‘’ (empty string).

I’l try to give some parts of the config and log that may be relevant:

Config

Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , ‘debug’);
Set($LogDir, ‘/usr/local/rt3/var/log’);
Set($LogToFileNamed , “$LogDir/rt.log”); #log to rt.log..

Set($TrustHTMLAttachments , undef);
@EmailInputEncodings = qw(iso-8859-1 utf-8 us-ascii) unless (@EmailEncodings);
Set($EmailOutputEncoding , ‘iso-8859-1’);

This log was generated then one e-mail was sent to the system:

[Sun Jun 29 16:54:35 2003] [debug]: Converting ‘iso-8859-1’ to ‘utf-8’ (/usr/local/rt3/lib/RT/I18N.pm:189)
[Sun Jun 29 16:54:35 2003] [debug]: Guessed encoding: ascii (/usr/local/rt3/lib/RT/I18N.pm:333)
[Sun Jun 29 16:54:35 2003] [debug]: Converting ‘ascii’ to ‘utf-8’ (/usr/local/rt3/lib/RT/I18N.pm:189)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: Invalid UNICODE character sequence found (0xe57220) at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT * FROM Tickets WHERE id
= ?’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [debug]: RT::Ticket=HASH(0xa7d5c3c) tried to load a bogus ticket: 346
(/usr/local/rt3/lib/RT/Ticket_Overlay.pm:197)
[Sun Jun 29 16:54:35 2003] [err]: RT::Transaction=HASH(0xa7d1d28) couldn’t load ticket 346
(/usr/local/rt3/lib/RT/Transaction_Overlay.pm:118)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query 'SELECT ACL.id from ACL, Groups,
Principals, CachedGroupMembers WHERE (ACL.RightName = ‘SuperUser’ OR ACL.RightName = ‘SeeQueue’) AND Principals.Disabled =
0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = ‘1’ AND ( ACL.ObjectType = ‘RT::System’ OR (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = ‘’)) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR Groups.Domain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain = ‘Personal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’
AND Groups.Instance = ‘’) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType
= ‘Group’) ) LIMIT 1’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder.pm line 145.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBIx::SearchBuilder error:ERROR: current transaction is aborted, queries ignored until end of transaction block
Query String is SELECT DISTINCT main.* FROM (Scrips main JOIN ScripConditions as ScripConditions_1 ON ( main.ScripCondition = ScripConditions_1.id)) WHERE ((ScripConditions_1.ApplicableTransTypes LIKE ‘%Create%’)OR(ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’)) AND ((main.Queue = ‘0’)) AND ((main.Stage = ‘TransactionCreate’))
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st fetchrow_hashref failed: no statement executing at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder.pm line 163.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT * FROM Tickets WHERE id
= ?’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [debug]: RT::Ticket=HASH(0xa14bf44) tried to load a bogus ticket: 346
(/usr/local/rt3/lib/RT/Ticket_Overlay.pm:197)
[Sun Jun 29 16:54:35 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [warning]: RT::Handle=HASH(0x9e8e56c) couldn’t execute the query ‘SELECT ACL.id from ACL, Groups,
Principals, CachedGroupMembers WHERE (ACL.RightName = ‘SuperUser’ OR ACL.RightName = ‘SeeQueue’) AND Principals.Disabled =
0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = ‘1’ AND ( ACL.ObjectType = ‘RT::System’ OR (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = ‘1’)) AND ( ( ACL.PrincipalId = Principals.id AND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR Groups.Domain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain = ‘Personal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND Groups.Instance = ‘1’) ) AND Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType = ‘Group’) ) LIMIT 1’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Sun Jun 29 16:54:35 2003] [info]: Ticket 346 created in queue ‘’ by jonas (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:608)

And here are some maby relevant parts of the e-mail. This e-mail

had an attatchment.  But I don't think there is any problem with
the attatchment handling.  It may have to do with the '�' on the
first line of the body:

Return-path: jonas@astral.paranormal.se
To: Redaktionen red@paranormal.se
Subject: [Jonas Liljegren] Re: [Para] =?iso-8859-1?q?Niv=E5er=3F?=
From: Jonas Liljegren jonas@liljegren.org
Date: Sun, 29 Jun 2003 14:08:37 +0200
User-Agent: Gnus/5.1002 (Gnus v5.10.2) Emacs/21.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="

–=-=-=
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Material f=F6r att uppdatera texten om niv=E5er.

What is wrong here?


jonas@rit.se RIT AB http://www.rit.se
Box 70, 428 21 K�llered Bes�k: G:a Riksv�gen 36
Tel: +46 (0)31 751 8600 Fax: +46 (0)31 751 8609


rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

http://www.bestpractical.com/rt – Trouble Ticketing. Free.