Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f15I2Rx44109 for ; Mon, 5 Feb 2001 13:02:28 -0500 (EST) (envelope-from mitch@venux.net) Received: from windows (mdmmi096064.voyager.net [216.93.96.64]) by icebox.venux.net (Postfix) with SMTP id 365B126209 for ; Mon, 5 Feb 2001 13:13:07 -0500 (EST) Message-ID: <014c01c08f9d$bdefca20$0200000a@windows> From: "Mitch Vincent" To: References: <4.3.2.7.2.20010205084023.036ddee8@rccd.cc.ca.us> <4.3.2.7.2.20010205094402.036d8ea0@rccd.cc.ca.us> Subject: Crazy PHP-> PostgreSQL errors Date: Mon, 5 Feb 2001 13:02:02 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/4 X-Sequence-Number: 143 Warning: 11 is not a valid PostgreSQL result resource in /usr/site/php/classes/db_pgsql.inc on line 62 Ok, this is a bit nasty.. All of the sudden I'm getting all kinds of the above errors in my PHP code (code that's worked forever).. It happens on both PG 7.0.2, 7.0.3 and 7.1 Beta 4 with both Apache 1.3.14 and 1.3.17.. It recently started happening on one of our production servers when it was taken to PHP 4.0.4pl1 from 4.0.3. I'm not positive where it started happening with my development server as the application effected hasn't been worked on for a while.. Between my development server and our effected production server we're using two totally different PgSQL classes for database access and both have been stable for a long, long time so I'm pretty sure it's not out PHP code... It doesn't appear that the backend is crashing.. I get no message that it exited abnormally, I swear it's like I'm calling pg_close() somewhere (but I'm not).. I'm at a loss as to how to debug this, it _appears_ to be PHP 4.0.4pl1 that's doing something crazy but I'll be damned if I can see what it is.. Before it was limited to my development server but after going to PHP 4.0.4pl1 on a production server this started to show up everywhere.. Any ideas/comments/insights would be appreciated! -Mitch