From bastiaaw@dds.nl Mon Jul 5 20:19:22 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2D9ABD1B1CE for ; Mon, 5 Jul 2004 17:19:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03094-06 for ; Mon, 5 Jul 2004 20:19:22 +0000 (GMT) Received: from outmx010.isp.belgacom.be (outmx010.isp.belgacom.be [195.238.3.233]) by svr1.postgresql.org (Postfix) with ESMTP id 4BBCBD1B191 for ; Mon, 5 Jul 2004 17:19:19 -0300 (ADT) Received: from outmx010.isp.belgacom.be (localhost [127.0.0.1]) by outmx010.isp.belgacom.be (8.12.11/8.12.11/Skynet-OUT-2.22) with ESMTP id i65KJGct013150 for ; Mon, 5 Jul 2004 22:19:16 +0200 (envelope-from ) Received: from 18-214.242.81.adsl.skynet.be (18-214.242.81.adsl.skynet.be [81.242.214.18]) by outmx010.isp.belgacom.be (8.12.11/8.12.11/Skynet-OUT-2.22) with ESMTP id i65KJF2F013148 for ; Mon, 5 Jul 2004 22:19:15 +0200 (envelope-from ) Subject: Warning: pg_fetch_row(): ... From: Bastiaan Wakkie Reply-To: bastiaan@wakkie.org To: pgsql-php@postgresql.org Content-Type: multipart/alternative; boundary="=-7icJCuBvDKuR/jp5A8hR" Organization: www.wakkie.org Message-Id: <1089059085.22951.111.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4-1.1mdk Date: 05 Jul 2004 22:24:46 +0200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.1 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_FONT_BIG, HTML_IMAGE_ONLY_10, HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: ** X-Archive-Number: 200407/4 X-Sequence-Number: 2829 --=-7icJCuBvDKuR/jp5A8hR Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi All, I just upgraded my PostgreSQL from 7.2 to 7.4.3. Mandrake gave me in the first place a lot of problems so I just recompiled php and postgresql again (php --without-mysql gave even problems!) I got one problem left though: any one familier with this error... "Warning: pg_fetch_row(): Unable to jump to row 0 on PostgreSQL result index 4 in /www/....php on line 17" ... ? I did search on google and found a lot of site having the same problem. Anyone does have a cure for this? Thanks, Bastiaan --=-7icJCuBvDKuR/jp5A8hR Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi All,

I just upgraded my PostgreSQL from 7.2 to 7.4.3. Mandrake gave me in the first place a lot of problems so I just recompiled php and postgresql again (php --without-mysql gave even problems!)

I got one problem left though: any one familier with this error...
    "Warning: pg_fetch_row(): Unable to jump to row 0 on PostgreSQL result index 4 in /www/....php on line 17"
... ?  I did search on google and found a lot of site having the same problem. Anyone does have a cure for this?

Thanks,

Bastiaan
--=-7icJCuBvDKuR/jp5A8hR-- From gmr@ehpg.net Wed Jul 7 19:43:40 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1558CD1B18C for ; Wed, 7 Jul 2004 16:43:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96472-08 for ; Wed, 7 Jul 2004 19:43:32 +0000 (GMT) Received: from tetra.ehpg.net (tetra.ehpg.net [216.218.206.34]) by svr1.postgresql.org (Postfix) with ESMTP id 55E2AD1B220 for ; Wed, 7 Jul 2004 16:43:29 -0300 (ADT) Received: from ([216.141.101.50]) [216.141.101.50]by tetra.ehpg.netwith asmtp(Exim 4.34 #1 (Gentoo Linux 1.4))id 1BiIKH-0000yQ-Vs; Wed, 07 Jul 2004 12:43:30 -0700 Message-ID: <40EC5263.8010404@ehpg.net> Date: Wed, 07 Jul 2004 12:43:31 -0700 From: "Gavin M. Roy" User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: bastiaan@wakkie.org Cc: pgsql-php@postgresql.org Subject: Re: Warning: pg_fetch_row(): ... References: <1089059085.22951.111.camel@localhost.localdomain> In-Reply-To: <1089059085.22951.111.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus-Scanned: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/5 X-Sequence-Number: 2830 This means your query didn't execute correctly, pull your query out and run it in psql to see what the query error is. You can also validate the number of rows your query is returning using pg_NumRows. Gavin Bastiaan Wakkie wrote: > Hi All, > > I just upgraded my PostgreSQL from 7.2 to 7.4.3. Mandrake gave me in > the first place a lot of problems so I just recompiled php and > postgresql again (php --without-mysql gave even problems!) > > I got one problem left though: any one familier with this error... > > "*Warning*: pg_fetch_row(): Unable to jump to row 0 on PostgreSQL result index 4 in */www/....php* on line *17*" > > ... ? I did search on google and found a lot of site having the same > problem. Anyone does have a cure for this? > > Thanks, > Bastiaan > From martin@bugs.unl.edu.ar Wed Jul 7 19:53:31 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8AA8D1B23F for ; Wed, 7 Jul 2004 16:53:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02119-05 for ; Wed, 7 Jul 2004 19:53:31 +0000 (GMT) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id D309BD1B27C for ; Wed, 7 Jul 2004 16:53:28 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 7AF8011E0B; Wed, 7 Jul 2004 16:53:06 -0300 (ART) Received: from bugs.unl.edu.ar ([127.0.0.1]) by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21566-05; Wed, 7 Jul 2004 16:52:46 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 50A4411E2E; Wed, 7 Jul 2004 16:52:46 -0300 (ART) From: Martin Marques To: bastiaan@wakkie.org Subject: Re: Warning: pg_fetch_row(): ... Date: Wed, 7 Jul 2004 16:52:43 -0300 User-Agent: KMail/1.6.2 Cc: pgsql-php@postgresql.org References: <1089059085.22951.111.camel@localhost.localdomain> In-Reply-To: <1089059085.22951.111.camel@localhost.localdomain> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <200407071652.43518.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at unl.edu.ar X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/6 X-Sequence-Number: 2831 El Lun 05 Jul 2004 17:24, Bastiaan Wakkie escribi=F3: > Hi All, > > I just upgraded my PostgreSQL from 7.2 to 7.4.3. Mandrake gave me in the > first place a lot of problems so I just recompiled php and postgresql > again (php --without-mysql gave even problems!) > > I got one problem left though: any one familier with this error... > > "Warning: pg_fetch_row(): Unable to jump to row 0 on PostgreSQL result > index 4 in /www/....php on line 17" > > ... ? I did search on google and found a lot of site having the same > problem. Anyone does have a cure for this? It's a warning, not an error, so why bother? Anyway pg_fetch_row() will ret= urn=20 false, because there are no more rows left to fetch (in your case, you have= =20 no rows at all). --=20 16:50:03 up 2 days, 8:27, 1 user, load average: 1.31, 1.18, 1.40 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------