[rt-users] Some unicode trouble with rt3.0.2pre6 and postgresql

[Marcus Ramberg]

Hey. 
I'm having some charset trouble with rt3.0.2pre6 and postgresql.
In general, international characters seems to work, but during testing I forwarded an email into the rt system, and got the following errors:

[Thu May 22 08:59:51 2003] [debug]: Converting 'iso-8859-1' to 'utf-8' (/opt/rt3/lib/RT/I18N.pm:211)
[Thu May 22 08:59:52 2003] [warning]: DBD::Pg::st execute failed: ERROR:  Invalid UNICODE character sequence found (0xe56e65) at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 386.
 (/opt/rt3/lib/RT.pm:226)
[Thu May 22 08:59:52 2003] [warning]: RT::Handle=HASH(0x840278c) couldn't execute the query 'INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 393.
 (/opt/rt3/lib/RT.pm:226)
[Thu May 22 08:59:52 2003] [warning]: DBD::Pg::st execute failed: ERROR:  current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 386.
 (/opt/rt3/lib/RT.pm:226)


This results in a ticket being created without a queue... Even if there *was* invalid unicode characters in the mail, this seems to be a bug? (This is with the latest DBIx::SearchBuilder)

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