On Thu, Jan 28, 2010 at 11:55:40AM +0100, Nehmer Torben wrote: > > we are running RT 3.8.7 (from Debian Packages) together with PostgreSQL > 8.4.1 in a German > environment.
There are some patches in 3.8-trunk (the merge of the
another_utf8_rework branch) that should resolve this issue.
-kevin
>
> Unfortunalety, we cannot create tickets from the Web Interface (both Quick
> Create an Full
> Create) when the subject contains one of our German Special Characters
> like "oe" and the
> Content is emtpy:
>
>
>
>
>
> As soon as I add something into the content area, things work as expected.
> The same behavior
> can be observed in the regular Ticket screen.
>
>
>
> The RT Log shows this, the text in curly Brackets {} are the translations
> of the error
> messages from Postgres into English. Note, that the F6 Character code "oe"
> in ISO-8859-1 and
> consorts, which is the single-byte encoding in use here when Unicode is
> not used.
>
>
>
> [Thu Jan 28 10:49:24 2010] [warning]: DBD::Pg::st execute failed: FEHLER:
> ungueltige
> Byte-Sequenz fuer Kodierung >>UTF8<<: 0xf6f6f60a {ERROR: Invalid
> Byte-Sequence for Encoding
> "UTF-8"}
>
> HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit
> der Kodierung
> uebereinstimmt, 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:509) {This error can also
> occur if the
> Byte-Sequence does not match with the encoding expected by the server, set
> through
> "client_encoding"}
>
> [Thu Jan 28 10:49:24 2010] [warning]: RT::Handle=HASH(0x4cc00e8) couldn't
> execute the query
> 'INSERT INTO Attachments (ContentType, Parent, Subject, Headers, Creator,
> MessageId, Created,
> TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
>
> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x4cc00e8)',
> 'INSERT INTO
> Attachments (ContentType, Parent, Subject, Header...', 'text/plain', 0,
> 'Test <F6><F6><F6>',
> 'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity
> 5.427)\x{a}S...', 22, '',
> '2010-01-28 10:49:24', ...) called at
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 357
>
> DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x4cc00e8)',
> 'Attachments',
> 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test <F6><F6><F6>',
> 'Headers', ...)
> called at /usr/share/perl5/DBIx/SearchBuilder/Handle/Pg.pm line 66
>
> DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x4cc00e8)',
> 'Attachments',
> 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test <F6><F6><F6>',
> 'Headers', ...)
> called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1293
>
> DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x2c16a10)',
> 'ContentType',
> 'text/plain', 'Parent', 0, 'Subject', 'Test
>
> <F6><F6><F6>', 'Headers', 'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools
> 5.427 (Entity
> 5.427)\x{a}S...', ...) called at
> /usr/share/request-tracker3.8/lib/RT/Record.pm line 289
>
> RT::Record::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId',
> 188101, 'Parent', 0,
> 'ContentType', 'text/plain', 'Headers', 'MIME-Version: 1.0\x{a}X-Mailer:
> MIME-tools 5.427
> (Entity 5.427)\x{a}S...', ...) called at
> /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 143
>
> RT::Attachment::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId',
> 188101,
> 'Attachment', 'MIME::Entity=HASH(0x592b468)') called at
> /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 514
>
> RT::Transaction::_Attach('RT::Transaction=HASH(0x2c10e30)',
> 'MIME::Entity=HASH(0x592b468)')
> called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line
> 154
>
> RT::Transaction::Create('RT::Transaction=HASH(0x2c10e30)', 'ObjectId',
> 10150, 'ObjectType',
> 'RT::Ticket', 'TimeTaken', '', 'Type', 'Create', ...) called at
> /usr/share/request-tracker3.8/lib/RT/Record.pm line 1457
>
> RT::Record::_NewTransaction('RT::Ticket=HASH(0x5929540)', 'Type',
> 'Create', 'TimeTaken', '',
> 'MIMEObj', 'MIME::Entity=HASH(0x592b468)', 'CommitScrips', 1, ...) called
> at
> /usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 656
>
> RT::Ticket::Create('RT::Ticket=HASH(0x5929540)', 'TimeEstimated', '',
> 'Status', 'new',
> 'Queue', 'RequestTracker', 'AdminCc', '', ...) called at
> /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 982
>
> HTML::Mason::Commands::CreateTicket('Attachments', undef, 'TimeEstimated',
> '', 'Status',
> 'new', 'new-DependsOn', '', 'Queue', ...) called at
> /usr/local/share/request-tracker3.8/html/Ticket/Display.html line 117
>
> If you need any more information, please let me know.
>
>
>
> Thanks in advance,
> 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
> [1][email protected]
> [2]www.cancom.de
>
> CANCOM Deutschland GmbH
> Sitz der Gesellschaft: Jettingen-Scheppach
> HRB 10653 Memmingen
> Geschaeftsfuehrer: Paul Holdschik, Christian Linder
>
> Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und
> ausschliesslich fuer den
> Gebrauch durch den Empfaenger bestimmt!
> This e-mail and any files transmitted with it are confidential intended
> solely for the use of
> the addressee!
>
>
>
> References
>
> Visible links
> 1. mailto:[email protected]
> 2. http://www.cancom.de/
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [email protected]
>
> 2010 RT Training Sessions!
> San Francisco, CA, USA - Feb 22 & 23
> Dublin, Ireland - Mar 15 & 16
> Boston, MA, USA - April 5 & 6
> Washington DC, USA - Oct 25 & 26
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
pgpW1oAXeo2FK.pgp
Description: PGP signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
