[PHPLIB] Postgres closes the channel; missing semicolon? From: Peter H. Lemieux (phl <email protected>)
Date: 02/29/00

I persistently get errors using PHPLIB 6.1 and PostgreSQL 6.4.2 like the
following:

Database error: Invalid SQL: select val from active_sessions where sid =
'f7a87f43986541c11df15faa96ddbe79' and name = 'Poe_Session'
PostgreSQL Error: 1 (PQexec() -- Request was sent to backend, but backend
closed
the channel before responding. This probably means the backend terminated
abnormally
before or while processing the request. )
Session halted.

The only thing I see wrong is the lack of a ";" at the end of the SQL
query.
I've added the line:
         $Query_String.=";";
to the query() function in db_pgsql.inc to append a semicolon. A few tests
suggest this is the source of the problem, but it's too soon to tell.
Otherwise,
PHPLIB works fine. A quick look at the db_pgsql.inc code in PHPLIB-7
indicates
that it also leaves off the semicolon.

I've searched the mailing list archive in vain for evidence that anyone but
me
has this problem.

PS: I'd appreciate direct replies as I don't keep up with the mailing list.

Thanks!

Peter
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.