Very queer errors with Postgres/PHP
| From: | Jeff MacDonald | Date: | Fri, 17 Nov 2000 02:19:06 +0000 |
| Subject: | Very queer errors with Postgres/PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4492@lists.php.net to get a copy of this message | ||
Hi Folks,
I'm running PostgreSQL 7.0.2 and PHP 4.0.2 on FreeBSD
4.1.1 Stable (intel)
I'd debugging an application for a client and here's an example
of a repetitive error he's been reporting..
-------------------
Warning: PostgreSQL query failed: ERROR: Attribute 't' not found in
/home/vhosts/mmfreedomclub.com/php-global/conf.php on line 25
Warning: Supplied argument is not a valid PostgreSQL result resource in
/home/vhosts/mmfreedomclub.com/php-global/conf.php on line 26
Warning: PostgreSQL query failed: ERROR: Attribute 't' not found in
/home/vhosts/mmfreedomclub.com/php-global/conf.php on line 52
Warning: Supplied argument is not a valid PostgreSQL result resource in
/home/vhosts/mmfreedomclub.com/php-global/conf.php on line 53
------------------
but.. here's the said lines in each file..
line 25
$select = pg_exec($dbh,"SELECT password FROM members WHERE member_id = $user");
line 26
if (pg_numrows($select) == 0) { return 0; }
line 52
$cp = pg_exec($dbh,"SELECT payed FROM members WHERE member_id = $mid");
line 53
if (pg_result($cp,0,0) == 'f') {
-------------------
Weird eh ?
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose