HTML-encoded mails with umlaute

Hello,

installing 3.0.3pre2 on Postgres works without any Problems and
emails with german special characters (umlaute) are converted if
they send as text, but we still get an error by sending
HTML-encoded mails with these german characters:

Jun 10 16:45:02 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed: ERROR: Invalid
UNICODE
character sequence found (0xfcdf65) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128) couldn’t execute the
quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed: ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der Transaktion
ignoriert a
t /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/s
ys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128) couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id =
Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND Groups.Instance = ‘1’)
OR
(Groups.Domain = ‘RT::System-Role’ AND Groups.Instance = ‘1’) ) AND
Groups.Ty
pe = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalTyp
e = ‘Group’) ) ’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm

TIA
Gregor Stever

I suspect this bug is actually due to iso-8859-1 characters being
illegally introduced into the message headers by your mail client.
We actually discovered that bug in internal testing last week.
3.0.3pre3 is likely to be out within 24 hours with a fix for this issue.

-jOn Tue, Jun 10, 2003 at 04:55:39PM +0200, Stever, Gregor wrote:

Hello,

installing 3.0.3pre2 on Postgres works without any Problems and
emails with german special characters (umlaute) are converted if
they send as text, but we still get an error by sending
HTML-encoded mails with these german characters:

Jun 10 16:45:02 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed: ERROR: Invalid
UNICODE
character sequence found (0xfcdf65) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128) couldn’t execute the
quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed: ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der Transaktion
ignoriert a
t /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/s
ys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128) couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id =
Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND Groups.Instance = ‘1’)
OR
(Groups.Domain = ‘RT::System-Role’ AND Groups.Instance = ‘1’) ) AND
Groups.Ty
pe = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalTyp
e = ‘Group’) ) ’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm

TIA
Gregor Stever


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

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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

Hello,

i have updated to 3.0.3pre3 but we still get the an error, if
we receive html-mail with an umlaut in the messagebody
(BTW:umlaute only in the subject works):

Postfix returns:

RT server error. The RT server which handled your email did not behave as
expected. It said:

System error

error: Can’t locate object method “fetchall_arrayref” via package
"Class::ReturnValue" at /usr/sys/rt_3.0.3pre3/lib/RT/Principal_Overlay.pm
line 269.

context: …
265:
266: # have a look at role groups, if there are any
267: $or_check_roles.
268: " ) ";
269: my $acl = $self->_Handle->SimpleQuery($query)->fetchall_arrayref({});
270:
271:
272: my $time = time();
273: foreach my $obj (@{$args{'Objects

Log:

Jun 11 09:16:41 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 11 09:16:41 se-nuke RT: DBD::Pg::st execute failed: ERROR: Invalid
UNICODE
character sequence found (0xfc3c2f) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410. (/usr/sys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: RT::Handle=HASH(0x9b56674) couldn’t execute the
quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: DBD::Pg::st execute failed: ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der Transaktion
ignoriert a
t /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/s
ys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: RT::Handle=HASH(0x9b56674) couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id =
Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain = ‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND Groups.Instance = 1)
OR (
Groups.Domain = ‘RT::System-Role’ AND Groups.Instance = 1) ) AND
Groups.Type =
ACL.PrincipalType AND Groups.id = Principals.id AND
Principals.PrincipalType =
‘Group’) ) ’ at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
lin
e
Jun 11 09:16:41 se-nuke RT: Transaction not committed. Usually indicates a
softw
are fault. Data loss may have occurred
(/usr/sys/rt_3.0.3pre3/bin/webmux.pl:121)

Thank You
Gregor

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Tuesday, June 10, 2003 7:49 PM
To: Stever, Gregor
Cc: 'rt-users@lists.fsck.com’
Subject: Re: [rt-users] HTML-encoded mails with umlaute

I suspect this bug is actually due to iso-8859-1 characters being
illegally introduced into the message headers by your mail client.
We actually discovered that bug in internal testing last week.
3.0.3pre3 is likely to be out within 24 hours with a fix for
this issue.

-j

Hello,

installing 3.0.3pre2 on Postgres works without any Problems and
emails with german special characters (umlaute) are converted if
they send as text, but we still get an error by sending
HTML-encoded mails with these german characters:

Jun 10 16:45:02 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed:
ERROR: Invalid
UNICODE
character sequence found (0xfcdf65) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128)
couldn’t execute the
quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId)
VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed:
ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der Transaktion
ignoriert a
t
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/s
ys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128)
couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id =
Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain =
‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = 'ACLEquivalence’
OR Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND
Groups.Instance = ‘1’)
OR
(Groups.Domain = ‘RT::System-Role’ AND Groups.Instance =
‘1’) ) AND
Groups.Ty
pe = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalTyp
e = ‘Group’) ) ’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm

TIA
Gregor Stever


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

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

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

Hello,

we have tried different Mailprogs:

MS Outlook 2000:

No ticket , error as reported

Header:
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C32FF0.74836310"

Netscape:

ticket created

Header:
MIME-Version: 1.0
X-Mailer: Mozilla 4.79 [en] (X11; U; IRIX64 6.5 IP28)
Content-Type: multipart/alternative;
boundary="------------81F5D77429245611A2E70250"

it is a problem parsing mails sended with Outlook.

Regards
Gregor

-----Original Message-----
From: Stever, Gregor [mailto:gst@volke.de]
Sent: Wednesday, June 11, 2003 9:27 AM
To: 'rt-users@lists.fsck.com’
Subject: RE: [rt-users] HTML-encoded mails with umlaute

Hello,

i have updated to 3.0.3pre3 but we still get the an error, if
we receive html-mail with an umlaut in the messagebody
(BTW:umlaute only in the subject works):

Postfix returns:

RT server error. The RT server which handled your email did
not behave as
expected. It said:

System error

error: Can’t locate object method “fetchall_arrayref” via package
"Class::ReturnValue" at
/usr/sys/rt_3.0.3pre3/lib/RT/Principal_Overlay.pm
line 269.

context: …
265:
266: # have a look at role groups, if there are any
267: $or_check_roles.
268: " ) ";
269: my $acl =
$self->_Handle->SimpleQuery($query)->fetchall_arrayref({});
270:
271:
272: my $time = time();
273: foreach my $obj (@{$args{'Objects

Log:

Jun 11 09:16:41 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 11 09:16:41 se-nuke RT: DBD::Pg::st execute failed:
ERROR: Invalid
UNICODE
character sequence found (0xfc3c2f) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410. (/usr/sys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: RT::Handle=HASH(0x9b56674)
couldn’t execute the
quer
y ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers,
Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId)
VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: DBD::Pg::st execute failed:
ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der Transaktion
ignoriert a
t /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 410.
(/usr/s
ys/rt_3.0.3pre3/lib/RT.pm:235)
Jun 11 09:16:41 se-nuke RT: RT::Handle=HASH(0x9b56674)
couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id =
Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain =
‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = ‘ACLEquivalence’ OR
Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND
Groups.Instance = 1)
OR (
Groups.Domain = ‘RT::System-Role’ AND Groups.Instance = 1) ) AND
Groups.Type =
ACL.PrincipalType AND Groups.id = Principals.id AND
Principals.PrincipalType =
‘Group’) ) ’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
lin
e
Jun 11 09:16:41 se-nuke RT: Transaction not committed.
Usually indicates a
softw
are fault. Data loss may have occurred
(/usr/sys/rt_3.0.3pre3/bin/webmux.pl:121)

Thank You
Gregor

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Tuesday, June 10, 2003 7:49 PM
To: Stever, Gregor
Cc: 'rt-users@lists.fsck.com’
Subject: Re: [rt-users] HTML-encoded mails with umlaute

I suspect this bug is actually due to iso-8859-1 characters being
illegally introduced into the message headers by your mail client.
We actually discovered that bug in internal testing last week.
3.0.3pre3 is likely to be out within 24 hours with a fix for
this issue.

-j

Hello,

installing 3.0.3pre2 on Postgres works without any Problems and
emails with german special characters (umlaute) are converted if
they send as text, but we still get an error by sending
HTML-encoded mails with these german characters:

Jun 10 16:45:02 se-nuke RT: Converting ‘iso-8859-1’ to 'utf-8’
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed:
ERROR: Invalid
UNICODE
character sequence found (0xfcdf65) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/Searc
hBuilder/Handle.pm line 410.
(/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)

Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128)
couldn’t execute the
quer
y 'INSERT INTO Attachments (Subject, ContentType,
Filename, Headers,

Creator, Pa
rent, Created, ContentEncoding, Content, TransactionId)
VALUES (?, ?, ?, ?,
?, ?
, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm li
ne 417. (/usr/sys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: DBD::Pg::st execute failed:
ERROR: aktuelle
Transak
tion wurde abgebrochen, Abfragen werden bis zum Ende der
Transaktion

ignoriert a
t
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 410.

(/usr/s
ys/rt_3.0.3pre2/lib/RT.pm:229)
Jun 10 16:45:03 se-nuke RT: RT::Handle=HASH(0x9cb0128)
couldn’t execute the
quer
y 'SELECT DISTINCT ACL.RightName, ACL.ObjectType, ACL.ObjectId,
CachedGroupMembe
rs.MemberId FROM ACL, Groups, Principals, CachedGroupMembers WHERE
Principals.D
isabled = 0 AND CachedGroupMembers.Disabled = 0 AND
Principals.id =

Groups.id A
ND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId =
1 AND ( (ACL.ObjectType = ‘RT::Queue’ AND ACL.ObjectId = 1) OR
(ACL.ObjectType
= ‘RT::System’ AND ACL.ObjectId = 1)) AND ( ( ACL.PrincipalId =
Principals.id A
ND ACL.PrincipalType = ‘Group’ AND (Groups.Domain =
‘SystemInternal’ OR
Groups.D
omain = ‘UserDefined’ OR Groups.Domain = 'ACLEquivalence’
OR Groups.Domain =
‘Pe
rsonal’)) OR ( ((Groups.Domain = ‘RT::Queue-Role’ AND
Groups.Instance = ‘1’)
OR
(Groups.Domain = ‘RT::System-Role’ AND Groups.Instance =
‘1’) ) AND
Groups.Ty
pe = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalTyp
e = ‘Group’) ) ’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm

TIA
Gregor Stever


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

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


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


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

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm