[rt-devel] 3.0.3 error: iso-8859-1
Jesse Vincent
jesse at bestpractical.com
Sun Jun 29 14:53:28 EDT 2003
Can you send me, personally (jesse at 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.<pid>.<user>
>
> 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 at astral.paranormal.se>
> To: Redaktionen <red at paranormal.se>
> Subject: [Jonas Liljegren] Re: [Para] =?iso-8859-1?q?Niv=E5er=3F?=
> From: Jonas Liljegren <jonas at 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 at 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 at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
>
--
http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
More information about the Rt-devel
mailing list