[rt-users] Problems with rt 3.8.7/postgresql 8.4.2 encoding

[Eynat Nir Mishor]

Have a look at a thread from last month in rt-devel mailing list:
http://www.gossamer-threads.com/lists/rt/devel/90355 

Sounds similar, though different.

 

Eynat

 

From: Eliezer E Chávez [mailto:eliezer.chavez at gmail.com] 
Sent: Monday, 11 January 2010 5:34 AM
To: RT Users
Subject: [rt-users] Problems with rt 3.8.7/postgresql 8.4.2 encoding

 

Guys:

I found myself with the following error (i live in Venezuela, so we expect
certain characters like á é í ó ú ñ in mail):

[Sun Jan 10 23:51:58 2010] [info]:
<rt-3.8.7-17334-1263167518-937.8-3-0 at yv-consulting.com> #8/129 - Scrip 3 On
Create Autoreply To Requestors
(/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)
[Sun Jan 10 23:51:59 2010] [info]:
<rt-3.8.7-17334-1263167518-937.8-3-0 at yv-consulting.com> sent  To:
echavez at yv-consulting.com.ve (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:331)
[Sun Jan 10 23:51:59 2010] [warning]: DBD::Pg::st execute failed: ERROR:
invalid byte sequence for encoding "UTF8": 0xc361
[Sun Jan 10 23:51:59 2010] [warning]: RT::Handle=HASH(0xb89f54c) couldn't
execute the query 'INSERT INTO Attachments (Subject, Filename, ContentType,
Headers, Creator, MessageId, Parent, Created, Content, ContentEncoding,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR:  invalid
byte sequence for encoding "UTF8": 0xc361
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR:  invalid
byte sequence for encoding "UTF8": 0xc361
[Sun Jan 10 23:51:59 2010] [info]:
<rt-3.8.7-17334-1263167518-968.8-4-0 at yv-consulting.com> #8/129 - Scrip 4 On
Create Notify AdminCcs (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)
[Sun Jan 10 23:51:59 2010] [info]:
<rt-3.8.7-17334-1263167518-968.8-4-0 at yv-consulting.com> No recipients found.
Not sending. (/opt/rt/bin/../lib/RT/Interface/Email.pm:342)
[Sun Jan 10 23:51:59 2010] [info]: Ticket 8 created in queue 'Soporte
[App/Web Server]' by echavez (/opt/rt/bin/../lib/RT/Ticket_Overlay.pm:667)
[Sun Jan 10 23:51:59 2010] [crit]: HasRight called with no valid object
(/opt/rt/bin/../lib/RT/Principal_Overlay.pm:322)

Somebody could pls help me?

Best Regards!!!!

EC

P.D. Sorry my losey english!

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