Thread

1. Problems about extracting data with cgi's

   Shterke Seben <shterke@yahoo.com> — 2001-01-03T22:39:40Z

   Hi,
   
     I had installed the rpm's of postgres in a redhat 7,
   the database was created succesfully, but when i tried
   to obtain some data with a cgi done in perl the cgi
   can't obtain the data, i've run already the same cgi
   with the same data and permissions in another machine
   and it runs without any problems, i also noticed that
   in /var/log/httpd/error_log there are some lines like
   this:
   
   [Wed Jan  3 09:34:37 2001] [notice] Apache/1.3.12
   (Unix)  (Red Hat/Linux) mod_ss
   l/2.6.6 OpenSSL/0.9.5a PHP/4.0.4 mod_perl/1.24
   configured -- resuming normal ope
   rations
   PQgetvalue: ERROR! tuple number 0 is out of range
   0..-1
   PQgetvalue: ERROR! tuple number 0 is out of range
   0..-1
   
   i've already checked the postgres status and the
   postmaster seems to be active:
   [root@RedPrue httpd]# /etc/rc.d/init.d/postgresql
   status
   postmaster (pid 779) is running...
   
   
    Can anybody tell me what else should i check or do to
   fix the problem?
   
    Thanks for the attention given to the present,
   
    Shterke S.
   
   
   
   _________________________________________________________
   Do You Yahoo!?
   Obtenga su dirección de correo-e gratis @yahoo.com
   en http://correo.espanol.yahoo.com
   
   

2. Re: Problems about extracting data with cgi's

   Anthony E . Greene <agreene@pobox.com> — 2001-01-04T04:41:19Z

   On Wed, 03 Jan 2001 17:39:40 Shterke Seben wrote:
   >[Wed Jan  3 09:34:37 2001] [notice] Apache/1.3.12
   >(Unix)  (Red Hat/Linux) mod_ss
   >l/2.6.6 OpenSSL/0.9.5a PHP/4.0.4 mod_perl/1.24
   >configured -- resuming normal ope
   >rations
   >PQgetvalue: ERROR! tuple number 0 is out of range
   >0..-1
   >PQgetvalue: ERROR! tuple number 0 is out of range
   >0..-1
   
   Use psql as the user who ran this query and run the the query manually. It's
   likely that there are no rows returned for some reason. The error message
   you got is what happens when you try to getvalue when there are no rows in
   the result object.
   
   -- 
   Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
   PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
   Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
   Linux. The choice of a GNU Generation. <http://www.linux.org/>