[rt-users] Bug: File Upload with Postgres and Special Characters in Filename

Nehmer Torben torben.nehmer at cancom.de
Fri Apr 30 05:25:23 EDT 2010 

Hello everyone,

I have a problem with our RT installation here: It is an RT 3.8.7 install with Postgres as database backend.

When uploading a file through the web frontend which contains special characters (like "Polizeipräsidium"), RT silently (!) fails to upload the file. The log message shows, that appearantly some characterset conversions are missing in this case.

The basic translation of the error message is about: "Invalid Byte-Sequence for encoding UTF8. This error can occur alos, if the byte sequence does not match the encoding expected by the server and set in the client_encoding.

I would appreciate any help in how to fix this.

 [Fri Apr 30 09:15:21 2010] [crit]: Apache2::RequestIO::rflush: (103) Software caused connection abort at /usr/share/perl5/HTML/Mason/ApacheH
andler.pm line 1026 (/usr/share/request-tracker3.8/libexec/webmux.pl:168)
[Fri Apr 30 09:15:33 2010] [warning]: DBD::Pg::st execute failed: FEHLER:  ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369
HINT:  Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch
»client_encoding« bestimmt wird. at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:5
09)
[Fri Apr 30 09:15:33 2010] [warning]: RT::Handle=HASH(0x44765d0) couldn't execute the query 'INSERT INTO Attachments (Subject, Filename, Con
tentType, Headers, Creator, MessageId, Parent, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' a
t /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x44765d0)', 'INSERT INTO Attachments (Subject, Filename, ContentType, Hea
d...', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'application/vnd.ms-excel', 'MIME-Version: 1.0\x{
a}Subject: Polizeipr\x{e4}sidiums Mittelfranken.xl...', 22, '', 185867, ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 35
7
        DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x44765d0)', 'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls'
, 'Filename', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'ContentType', 'application/vnd.ms-excel', 'Headers', ...) called at /usr/share/perl
5/DBIx/SearchBuilder/Handle/Pg.pm line 66
        DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x44765d0)', 'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.
xls', 'ContentType', 'application/vnd.ms-excel', 'Filename', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Headers', ...) called at /usr/share/
perl5/DBIx/SearchBuilder/Record.pm line 1293
        DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x5664d40)', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Filename
', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'ContentType', 'application/vnd.ms-excel', 'Headers', 'MIME-Version: 1.0\x{a}Subject: Polizeipr
\x{e4}sidiums Mittelfranken.xl...', ...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 289
        RT::Record::Create('RT::Attachment=HASH(0x5664d40)', 'TransactionId', 252488, 'ContentType', 'application/vnd.ms-excel', 'ContentEnc
oding', 'base64', 'Parent', 185867, ...) called at /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 178
        RT::Attachment::Create('RT::Attachment=HASH(0x5664d40)', 'TransactionId', 252488, 'Parent', 185867, 'Attachment', 'MIME::Entity=HASH(0x5743be8)') called at /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 158
        RT::Attachment::Create('RT::Attachment=HASH(0x54038a0)', 'TransactionId', 252488, 'Attachment', 'MIME::Entity=HASH(0x5041010)') called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 514
        RT::Transaction::_Attach('RT::Transaction=HASH(0x54101e8)', 'MIME::Entity=HASH(0x5041010)') called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 154
        RT::Transaction::Create('RT::Transaction=HASH(0x54101e8)', 'ObjectId', 13698, 'ObjectType', 'RT::Ticket', 'TimeTaken', '', 'Type', 'Correspond', ...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 1457
        RT::Record::_NewTransaction('RT::Ticket=HASH(0x3f150b8)', 'Type', 'Correspond', 'Data', 'No Subject', 'TimeTaken', '', 'MIMEObj', 'MIME::Entity=HASH(0x5041010)', ...) called at /usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 2175
        RT::Ticket::_RecordNote('RT::Ticket=HASH(0x3f150b8)', 'BccMessageTo', '', 'CcMessageTo', '', 'NoteType', 'Correspond', 'TimeTaken', '', ...) called at /usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 2087
        RT::Ticket::Correspond('RT::Ticket=HASH(0x3f150b8)', 'BccMessageTo', '', 'CcMessageTo', '', 'MIMEObj', 'MIME::Entity=HASH(0x5041010)', 'TimeTaken', '', ...) called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 1147
        HTML::Mason::Commands::ProcessUpdateMessage('ARGSRef', 'HASH(0x51fcb78)', 'Actions', 'ARRAY(0x520ac88)', 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)') called at /usr/local/share/request-tracker3.8/html/Ticket/Display.html line 145
        HTML::Mason::Commands::__ANON__('TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5212f48)', 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
        eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
        HTML::Mason::Request::comp(undef, undef, 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', ...) called at /usr/share/request-tracker3.8/html/Ticket/Update.html line 261
        HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5054f68)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
        eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
        HTML::Mason::Request::comp(undef, undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 320
        RT::Interface::Web::ShowRequestedPage('HASH(0x4f3a358)') called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 224
        RT::Interface::Web::HandleRequest('HASH(0x4f3a358)') called at /usr/share/request-tracker3.8/html/autohandler line 53
        HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4f3a7f0)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1297
        eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
        HTML::Mason::Request::comp(undef, undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 481
        eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 481
        eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 433
        HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x575a4d0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
        HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x575a4d0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
        HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x4cc17f8)', 'Apache2::RequestRec=SCALAR(0x5772ad8)') called at /usr/share/request-tracker3.8/libexec/webmux.pl line 166
        eval {...} called at /usr/share/request-tracker3.8/libexec/webmux.pl line 166
        RT::Mason::handler('Apache2::RequestRec=SCALAR(0x5772ad8)') called at -e line 0
        eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47)
[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER:  ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369
HINT:  Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. (/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:191)
[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER:  ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369
HINT:  Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. (/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:164)
Mit freundlichen Grüßen,
Torben Nehmer
-------
Torben Nehmer
Diplom Informatiker (FH)
Business System Developer
CANCOM Deutschland GmbH
Messerschmittstr. 20
89343 Scheppach
Germany
Tel.: +49 8225 - 996-1118
Fax: +49 8225 - 996-41118
torben.nehmer at cancom.de<mailto:torben.nehmer at cancom.de>
www.cancom.de<http://www.cancom.de>
CANCOM Deutschland GmbH
Sitz der Gesellschaft: Jettingen-Scheppach
HRB 10653 Memmingen
Geschäftsführer: Paul Holdschik, Christian Linder
Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt!
This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100430/ff67d56d/attachment.htm>

More information about the rt-users mailing list