This is the full trace...<br><br>[Sun Jan 10 23:51:58 2010] [info]: <<a href="mailto:rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com">rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com</a>> #8/129 - Scrip 3 On Create Autoreply To Requestors (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)<br>
[Sun Jan 10 23:51:59 2010] [info]: <<a href="mailto:rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com">rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com</a>> sent To: <a href="mailto:echavez@yv-consulting.com.ve">echavez@yv-consulting.com.ve</a> (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:331)<br>
[Sun Jan 10 23:51:59 2010] [warning]: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc361<br>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". at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)<br>
[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<br>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb89f54c)', 'INSERT INTO Attachments (Subject, Filename, ContentType, Head...', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'undef', 'text/plain', 'Content-Type: text/plain; charset="utf-8"<br>
Subject: Respuesta ...', 1, '', 35, ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357<br> DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb89f54c)', 'Attachments', 'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'Filename', 'undef', 'ContentType', 'text/plain', 'Headers', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 66<br>
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0xb89f54c)', 'Attachments', 'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'ContentType', 'text/plain', 'Filename', 'undef', 'Headers', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293<br>
DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0xc8c6d5c)', 'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'Filename', 'undef', 'ContentType', 'text/plain', 'Headers', 'Content-Type: text/plain; charset="utf-8"<br>
Subject: Respuesta ...', ...) called at /opt/rt/bin/../lib/RT/Record.pm line 289<br> RT::Record::Create('RT::Attachment=HASH(0xc8c6d5c)', 'TransactionId', 130, 'ContentType', 'text/plain', 'ContentEncoding', 'none', 'Parent', 35, ...) called at /opt/rt/bin/../lib/RT/Attachment_Overlay.pm line 178<br>
RT::Attachment::Create('RT::Attachment=HASH(0xc8c6d5c)', 'TransactionId', 130, 'Parent', 35, 'Attachment', 'MIME::Entity=HASH(0xc8bbaa8)') called at /opt/rt/bin/../lib/RT/Attachment_Overlay.pm line 158<br>
RT::Attachment::Create('RT::Attachment=HASH(0xc8b5a34)', 'TransactionId', 130, 'Attachment', 'MIME::Entity=HASH(0xc8b9238)') called at /opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 514<br>
RT::Transaction::_Attach('RT::Transaction=HASH(0xc8bba30)', 'MIME::Entity=HASH(0xc8b9238)') called at /opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 154<br> RT::Transaction::Create('RT::Transaction=HASH(0xc8bba30)', 'Ticket', 8, 'Type', 'EmailRecord', 'Data', '<<a href="mailto:rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com">rt-3.8.7-17334-1263167518-937.8-3-0@yv-consulting.com</a>>', 'MIMEObj', 'MIME::Entity=HASH(0xc8b9238)', ...) called at /opt/rt/bin/../lib/RT/Action/SendEmail.pm line 543<br>
RT::Action::SendEmail::RecordOutgoingMailTransaction('RT::Action::Autoreply=HASH(0xc8b0fe4)', 'MIME::Entity=HASH(0xc8b9238)') called at /opt/rt/bin/../lib/RT/Action/SendEmail.pm line 138<br> RT::Action::SendEmail::Commit('RT::Action::Autoreply=HASH(0xc8b0fe4)') called at /opt/rt/bin/../lib/RT/ScripAction_Overlay.pm line 238<br>
RT::ScripAction::Commit('RT::ScripAction=HASH(0xc89f030)') called at /opt/rt/bin/../lib/RT/Scrip_Overlay.pm line 464<br> eval {...} called at /opt/rt/bin/../lib/RT/Scrip_Overlay.pm line 463<br> RT::Scrip::Commit('RT::Scrip=HASH(0xc89e658)', 'TicketObj', 'RT::Ticket=HASH(0xc89e8b0)', 'TransactionObj', 'RT::Transaction=HASH(0xc89e820)') called at /opt/rt/bin/../lib/RT/Scrips_Overlay.pm line 196<br>
RT::Scrips::Commit('RT::Scrips=HASH(0xc88cb28)') called at /opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 188<br> RT::Transaction::Create('RT::Transaction=HASH(0xc86a624)', 'ObjectId', 8, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'Create', ...) called at /opt/rt/bin/../lib/RT/Record.pm line 1457<br>
RT::Record::_NewTransaction('RT::Ticket=HASH(0xbcbb388)', 'Type', 'Create', 'TimeTaken', 0, 'MIMEObj', 'MIME::Entity=HASH(0xbcb8e80)', 'CommitScrips', 1, ...) called at /opt/rt/bin/../lib/RT/Ticket_Overlay.pm line 656<br>
RT::Ticket::Create('RT::Ticket=HASH(0xbcbb388)', 'Queue', 4, 'Subject', 'Prueba', 'Requestor', 'ARRAY(0xa8c65dc)', 'Cc', 'ARRAY(0xa8c65c4)', ...) called at /opt/rt/bin/../lib/RT/Interface/Email.pm line 1444<br>
RT::Interface::Email::Gateway('HASH(0xc532500)') called at /opt/rt/share/html/REST/1.0/NoAuth/mail-gateway line 61<br> HTML::Mason::Commands::__ANON__('SessionType', 'REST', 'action', 'correspond', 'queue', 'Soporte [App/Web Server]', 'message', 'Delivered-To: <a href="http://soporte.as">soporte.as</a>@<a href="http://yv-consulting.com.ve">yv-consulting.com.ve</a>\x{a}Received: from ...') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135<br>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbcb7b6c)', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'Soporte [App/Web Server]', 'message', 'Delivered-To: <a href="http://soporte.as">soporte.as</a>@<a href="http://yv-consulting.com.ve">yv-consulting.com.ve</a>\x{a}Received: from ...', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279<br>
eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274<br> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'Soporte [App/Web Server]', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473<br>
eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473<br> eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425<br> HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0xbe7efe8)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168<br>
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0xbe7efe8)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825<br> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xc510d20)', 'Apache2::RequestRec=SCALAR(0xbcc0ff8)') called at /opt/rt/bin/<a href="http://webmux.pl">webmux.pl</a> line 166<br>
eval {...} called at /opt/rt/bin/<a href="http://webmux.pl">webmux.pl</a> line 166<br> RT::Mason::handler('Apache2::RequestRec=SCALAR(0xbcc0ff8)') called at -e line 0<br> eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)<br>
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc361<br>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/bin/../lib/RT/Attachment_Overlay.pm:191)<br>
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc361<br>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/bin/../lib/RT/Attachment_Overlay.pm:164)<br>
[Sun Jan 10 23:51:59 2010] [info]: <<a href="mailto:rt-3.8.7-17334-1263167518-968.8-4-0@yv-consulting.com">rt-3.8.7-17334-1263167518-968.8-4-0@yv-consulting.com</a>> #8/129 - Scrip 4 On Create Notify AdminCcs (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)<br>
[Sun Jan 10 23:51:59 2010] [info]: <<a href="mailto:rt-3.8.7-17334-1263167518-968.8-4-0@yv-consulting.com">rt-3.8.7-17334-1263167518-968.8-4-0@yv-consulting.com</a>> No recipients found. Not sending. (/opt/rt/bin/../lib/RT/Interface/Email.pm:342)<br>
[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)<br>[Sun Jan 10 23:51:59 2010] [crit]: HasRight called with no valid object (/opt/rt/bin/../lib/RT/Principal_Overlay.pm:322)<br>
<br>Regards,<br><br>EC<br><br><div class="gmail_quote">2010/1/11 Eliezer E Chávez <span dir="ltr"><<a href="mailto:echavez@yv-consulting.com.ve">echavez@yv-consulting.com.ve</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Sorry for the misunderstanding, but i'm a support consultant too, so, i dislike others selling me... :-)<br><br>Ok, as a clarification, and in spanish:<br><br>Creé una plantilla de autorespuesta en español, pero cuando intento crear un nuevo ticket y RT intenta guardar el mensaje en la base de datos se queja de los caracteres latinos (á, é, ñ, etc...)<br>
<br>Cómo hago para corregir eso, defino la base de datos en ISO-8859-1 (LATIN1) ó como hago para decirle a RT como enviar la codificación a PostgreSQL.<br><br>Saludos y mis disculpas de nuevo.<br><br>EC<br><br><br><div class="gmail_quote">
<div class="im">
2010/1/11 Luis E. <span dir="ltr"><<a href="mailto:lem@itverx.com.ve" target="_blank">lem@itverx.com.ve</a>></span><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On Mon, 2010-01-11 at 07:24 -0430, Eliezer E Chávez wrote:<div><div></div><div class="h5"><br>
> Hi Luis:<br>
><br>
> Disregarding the fact that you're selling me support in this list,<br>
</div></div></div><div><div></div><div class="h5">> [...]<br>
<br>
Sorry, you're wrong. I answered in a *private* message, in spanish BTW,<br>
because you mentioned in your message that you're from Venezuela and<br>
that your English had room for improvement.<br>
<br>
In that private message, I pointed some things to look at and yes, let<br>
you know that we offer professional services that might be of interest.<br>
Again, this was outside the regular list traffic.<br>
<br>
As an exercise, think about who violated etiquette by posting a private<br>
message on a public forum now.<br>
<div><br>
> I already know that the problem is that i've created an autoresponse<br>
> template in spanish with ascii characters that are not recognized in<br>
> unicode format.<br>
<br>
</div>Good. That paragraph does not mean what you think it does. A text<br>
composed entirely of ASCII characters, is valid UTF-8 (UTF-8 and Unicode<br>
are not synonyms, ASCII is just one of many possible encodings).<br>
<br>
Your problem seems to be related to a chain of encoding/decoding<br>
operations in which at least one of them is interpreting a string<br>
assuming the wrong encoding.<br>
<div><br>
> What i want to know is how i solve this issue in PostgreSQL, cuz in<br>
> Oracle 10gR2 dosn't happen...<br>
<br>
</div>Your problem is not with PostgreSQL, which is doing the right thing.<br>
You're feeding it a string of badly encoded UTF-8. Check your<br>
environment and make sure you're doing everything with UTF-8 so that the<br>
encodings are consistent. IOW, follow the advice you Cc-ed to the list.<br>
<br>
Best regards.<br>
<br>
-lem<br>
<br>
</div></div></blockquote></div><br>
</blockquote></div><br>