[rt-users] Umlaute in attachment filename RT 3.8.1

[Givano]

Hello Everybody!

when I try to create a new ticket in any queue and attach a doc file
ööäädfasdf.doc I am getting "Ticket could not be created due to an internal
error" message, in the log file following output is coming:

[Mon Mar 30 15:21:17 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/bin/../lib/RT/I18N.pm:416)
[Mon Mar 30 15:21:17 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/bin/../lib/RT/I18N.pm:416)
[Mon Mar 30 15:21:17 2009] [debug]: About to think about scrips for
transaction #40891 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:163)
[Mon Mar 30 15:21:17 2009] [debug]: About to think about scrips for
transaction #40892 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:163)
[Mon Mar 30 15:21:17 2009] [debug]: About to think about scrips for
transaction #40893 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:163)
[Mon Mar 30 15:21:17 2009] [debug]: About to think about scrips for
transaction #40894 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:163)
[Mon Mar 30 15:21:18 2009] [debug]: Max size is 10000000
(/opt/rt3/bin/../lib/RT/Record.pm:743)
[Mon Mar 30 15:21:18 2009] [warning]: DBD::Pg::st execute failed: ERROR:
invalid byte sequence for encoding "UTF8": 0xf6f6e4e4
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
(/usr/lo
cal/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Mon Mar 30 15:21:18 2009] [warning]: RT::Handle=HASH(0xa1f0b3c) couldn't
execute the query 'INSERT INTO Attachments (Subject, Filename, ContentType,
Headers
, Creator, MessageId, Parent, Created, Content, ContentEncoding,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/local/share/perl/5.8.8/DBIx
/SearchBuilder/Handle.pm line 518
  DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa1f0b3c)',
'INSERT INTO Attachments (Subject, Filename, ContentType, Head...',
'\x{c3}\x{
b6}\x{c3}\x{b6}\x{c3}\x{a4}\x{c3}\x{a4}dfasdf.doc',
'<F6><F6><E4><E4>dfasdf.doc', 'application/msword', 'Subject:
\x{c3}\x{b6}\x{c3}\x{b6}\x{c3}\x{a4}\x{c3}\
x{a4}dfasdf.doc\x{a}MIME-Version: 1.0\x{a}Content-Type: a...', 132, '',
26479, ...) called at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 3
53

.........skipped......

[Mon Mar 30 15:21:18 2009] [crit]: Attachment insert failed: ERROR: invalid
byte sequence for encoding "UTF8": 0xf6f6e4e4
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
(/opt/rt
3/bin/../lib/RT/Attachment_Overlay.pm:191)
[Mon Mar 30 15:21:18 2009] [crit]: Attachment insert failed: ERROR: invalid
byte sequence for encoding "UTF8": 0xf6f6e4e4
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
(/opt/rt
3/bin/../lib/RT/Attachment_Overlay.pm:164)
[Mon Mar 30 15:21:18 2009] [debug]: About to think about scrips for
transaction #40895 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:163)
[Mon Mar 30 15:21:18 2009] [debug]: About to prepare scrips for transaction
#40895 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:167)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xac75134) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [err]: RT::Scrips=HASH(0xafa1674) couldn't load
ticket 2443 (/opt/rt3/bin/../lib/RT/Scrips_Overlay.pm:291)
[Mon Mar 30 15:21:18 2009] [debug]: Found 10 scrips for TransactionCreate
stage with applicable type(s) Create
(/opt/rt3/bin/../lib/RT/Scrips_Overlay.pm:370)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 15 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xa8b25d8) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [info]: Scrip 24 has NOT been applied, since it
is deactivated for Queue (/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:374)
[Mon Mar 30 15:21:18 2009] [info]: Scrip 25 has NOT been applied, since it
is deactivated for Queue (/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:374)
[Mon Mar 30 15:21:18 2009] [info]: Scrip 26 has NOT been applied, since it
is deactivated for Queue (/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:374)
[Mon Mar 30 15:21:18 2009] [info]: Scrip 23 has NOT been applied, since it
is deactivated for Queue (/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:374)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 3 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xadd4afc) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 4 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xac77ec8) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 18 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xaa987b8) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 19 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xadadb38) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: Scrip 2 has been applied, since it is
not deactivated for Queue
(/opt/rt3/bin/../local/lib/RT/Scrip_Overlay.pm:378)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xac77b98) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xadaa0b4) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:18 2009] [crit]: HasRight called with no valid object
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322)
[Mon Mar 30 15:21:18 2009] [debug]: About to commit scrips for transaction
#40895 (/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm:176)
[Mon Mar 30 15:21:18 2009] [debug]: RT::Ticket=HASH(0xadd71b0) tried to load
a bogus ticket: 2443 (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:172)
[Mon Mar 30 15:21:19 2009] [error]: Ticket couldn't be created:
(/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:667)
[Mon Mar 30 15:21:19 2009] [error]: WebRT: Ticket could not be created due
to an internal error (/opt/rt3/share/html/Elements/Error:82)

When I try to attach the same doc file named with cyrillic characters like
вфывафыва.doc it works without any problems. When I mix umlauts with
cyrillic it also works. And it also works when I attach the same file in
reply or comment or jumbo form.

My configuration: RT 3.8.1, running on Debian Etch with Postgres 8.1.15,
Perl 5.8.8

Anyone knows how to solve this problem?

Thanks in advance,

Ivan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090330/72e110e7/attachment.htm>