[rt-users] HTML-encoded mails with umlaute

Stever, Gregor gst at volke.de
Wed Jun 11 04:18:37 EDT 2003 

Hello,

we have tried different Mailprogs:

MS Outlook 2000:

No ticket , error as reported 

Header:
	Date: Wed, 11 Jun 2003 09:17:22 +0200
	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)
	Subject: test 5 text + html
	Content-Type: multipart/alternative;
boundary="------------81F5D77429245611A2E70250"


it is a problem parsing mails sended with Outlook.

Regards
Gregor


> -----Original Message-----
> From: Stever, Gregor [mailto:gst at volke.de]
> Sent: Wednesday, June 11, 2003 9:27 AM
> To: 'rt-users at 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 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.
> 
> _______________________________________________
> 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

More information about the rt-users mailing list