[rt-users] RT dump import errors on postgresql 7.4

mixo mixo at coza.net.za
Fri Dec 19 07:44:28 EST 2003


mixo wrote:

>
> ++++++++++++++++++++++++++++++++++++++
> [Thu Dec 18 05:54:29 2003] [warning]: DBD::Pg::st execute failed: 
> ERROR:  unterminated quoted string at or near "'ÿØÿà" at character 368 
> at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
> (/opt/rt3/lib/RT.pm:247)
> [Thu Dec 18 05:54:29 2003] [warning]: RT::Handle=HASH(0x8b71290) 
> couldn't execute the query 'INSERT INTO Attachments
> (ContentType, Parent, id, Subject, Filename, Headers, Creator, 
> Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, 
> ?, ?, ?, ?, ?, ?, ?)' at 
> /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
> (/opt/rt3/lib/RT.pm:247)
> [Thu Dec 18 05:54:29 2003] [warning]: Couldn't create attachment 
> HASH(0x8c17f3c) $VAR1 = {
> ++++++++++++++++++++++++++++++++++++++ 

This message appears for all JPEGS. For other binary attachments a 
similar problem occurs.
It seems that the problem is that the attachment is not escaped in the 
query. Am I headed
in the right direction?




More information about the rt-users mailing list