[rt-users] HTML-encoded mails with umlaute

[Stever, Gregor]

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 at bestpractical.com]
> Sent: Tuesday, June 10, 2003 7:49 PM
> To: Stever, Gregor
> Cc: 'rt-users at 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
> 
> 
> On 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 at 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.