Skip Menu |

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

Report information
The Basics
Id: 14318
Status: resolved
Priority: 0/
Queue: DBD-PgPP
People
Owner: Nobody in particular
Requestors: probello [...] promia.com
Cc:
AdminCc:
Bug Information
Severity: Critical
Broken in: 0.05
Fixed in: 0.06

History Show all quoted text
  Thu Aug 25 15:47:53 2005 Guest - Ticket created
Subject: array has 1 fields, should have 4 at /usr/lib/perl5/site_perl/5.8.3/DBD/PgPP.pm line 409
distro file DBD-PgPP-0.05.tar.gz This is perl, v5.8.3 built for i586-linux-thread-multi Linux suse2 2.6.5-7.97-smp #1 SMP Fri Jul 2 14:21:59 UTC 2004 i686 i686 i386 GNU/Linux the following snipet works for 1 tupple then breaks with error message below my $sql="select nid,name,community,ip from asset_nodes,asset_host_nodes,asset_snmp_auth where (nnid=nid) and (snmpid=snmp_id)"; my $sth=$dbd->prepare($sql); $sth->execute(); while (my $row=$sth->fetchrow_hashref){ <--- breaks on this line on 2nd pass Error message: array has 1 fields, should have 4 at /usr/lib/perl5/site_perl/5.8.3/DBD/PgPP.pm line 409
  Sun Aug 28 11:55:42 2005 Guest - Correspondence added
From: worel (worel at miit.ru)
found this too :( FreeBSD 4.10 This is perl, v5.8.5 built for i386-freebsd package DBD::PgPP; $VERSION = '0.05'; my $dbh = DBI->connect("dbi:PgPP:dbname=library;host=localhost", "postgres", "zzz", {RaiseError => '0', AutoCommit => 0}); my $zsth = $dbh->prepare("SELECT DISTINCT ON (booksonhold.rid) booksonhold.rid FROM booksonhold LEFT JOIN blocked_readers ON booksonhold.rid = blocked_readers.rid WHERE EXTRACT(EPOCH FROM booksonhold.holdfor) < (EXTRACT(EPOCH FROM now())) AND blocked_readers.rid IS NULL"); $zsth->execute(); while ((my $rid) = $zsth->fetchrow_array) { $str = "SELECT 1 as one, 2 as two"; $dbh->do($str); } died at $dbh->do($str) with error: _set_fbav(ARRAY(0x83c61bc)): array has 2 fields, should have 1 at /usr/local/perl5.8.5/lib/site_perl/5.8.5/DBD/PgPP.pm line 409. i could slove this problem only by using another connection for other requests :(((
  Tue Feb 24 08:13:52 2009 cpan [...] aaroncrane.co.uk - Correspondence added
These issues are believed to be fixed in DBD::PgPP 0.06. Please reopen this ticket if you can still reproduce the problem in that version. Apologies for the absurdly long delay. -- Aaron Crane
  Tue Feb 24 08:13:53 2009 The RT System itself - Status changed from 'new' to 'open'
  Tue Feb 24 08:13:53 2009 cpan [...] aaroncrane.co.uk - Status changed from 'open' to 'resolved'
  Tue Feb 24 17:33:55 2009 cpan [...] aaroncrane.co.uk - Fixed in 0.06 added