Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 5389
Status: resolved
Priority: 0/
Queue: DBD-Pg
People
Owner: Nobody in particular
Requestors: valier_j [...] epita.fr
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.31
Fixed in: 1.32

History Show all quoted text
  Thu Feb 19 12:45:59 2004 Guest - Ticket created
Subject: $dbh->quote Problem
There seeems to be a bug with the quote method in the 1.31_2 version of DBD-Pg. I'm using amavisd-new which store information in an SQL Database (a Postgresql one for me). For some of the mail that I store in this database I have the folloowing error: DBD::Pg::st execute failed: ERROR: parser: unterminated quoted string at or near " ' ' Here is the request I do: $sth->execute($id_maillog,$dbh->quote($header),$dbh->quote($body));
  Thu Feb 19 12:46:12 2004 Guest - Ticket #5390: Ticket created
Subject: $dbh->quote Problem
There seems to be a bug with the quote method in the 1.31_2 version of DBD-Pg. I'm using amavisd-new which store information in an SQL Database (a Postgresql one for me). For some of the mail that I store in this database I have the folloowing error: DBD::Pg::st execute failed: ERROR: parser: unterminated quoted string at or near " ' ' Here is the request I do: $sth->execute($id_maillog,$dbh->quote($header),$dbh->quote($body));
  Thu Feb 19 12:52:23 2004 rlippan [...] remotelinux.com - Correspondence added
[guest - Thu Feb 19 12:45:59 2004]: Show quoted text
> There seeems to be a bug with the quote method in the 1.31_2 version > of DBD-Pg. > I'm using amavisd-new which store information in an SQL Database (a > Postgresql one for me). For some of the mail that I store in this > database I have the folloowing error: > DBD::Pg::st execute failed: ERROR: parser: unterminated quoted string > at or near " ' ' > Here is the request I do: > $sth->execute($id_maillog,$dbh->quote($header),$dbh->quote($body));
I need some more to go on. Please send the output of a DBI->trace(9) on a message that causes the problem, or some sample text that causes the problem.
  Thu Feb 19 13:16:45 2004 rlippan [...] remotelinux.com - Correspondence added
[jean-christophe.valiere@oxalide.com - Thu Feb 19 13:10:47 2004]: Show quoted text
> >
> My server a in production, so I'v passed them back to version 1.22. > I'll update my Pre-Prod server to send more information.
FYI, the _x releases of DBD::Pg are beta releases. 1.31 is the last stable release. But at this point, it is probably better to wait for 1.32 before upgrading.
  Fri Jun 18 00:55:25 2004 dwheeler [...] cpan.org - Status changed from 'new' to 'resolved'
  Fri Jun 18 00:55:25 2004 dwheeler [...] cpan.org - Correspondence added
Not enough data given to be sure, but should be fixed in 1.32.
  Fri Jun 18 00:55:38 2004 dwheeler [...] cpan.org - Fixed in 1.32 added
  Fri Jun 18 00:56:39 2004 dwheeler [...] cpan.org - Ticket #5390: Status changed from 'new' to 'resolved'
  Fri Jun 17 13:16:46 2005 dbd-pg [...] perl.org - Ticket #5390: Ticket deleted
  Fri Jun 17 13:16:47 2005 dbd-pg [...] perl.org - Ticket #5390: Ticket 5390 MergedInto ticket 5389.
  Fri Jun 17 13:18:32 2005 dbd-pg [...] perl.org - Broken in 1.31 added