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
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.