Warning: pg_fetch_row(): ...

--=-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"

Re: Warning: pg_fetch_row(): ...

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
>


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Warning: pg_fetch_row(): ...

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
------------------------------------------------------------ -----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org