Re: Bug #726: PHP/PG ERROR: parser: parse error at or near ","

Stephan:
Thanks for the tip, as it helped me find the error. And it has been
solved.

Bugs List:
You might want to remove this report. It was a PEBCAK 100%. I feel
pretty stupid about the whole thing (and my head hurts from the banging
against the wall).

Thanks for the quick response, though, it's greatly appreciated.

Paul Redd-LaFlamme

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)com]
Sent: Wednesday, July 31, 2002 12:00 PM
To: predd-laflamme(at)strata-g(dot)com; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Bug #726: PHP/PG ERROR: parser: parse error at or
near ","

On Wed, 31 Jul 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Paul Redd-LaFlamme (predd-laflamme(at)strata-g(dot)com) reports a bug with a
severity of 1
> The lower the number the more severe it is.
>
> Short Description
> PHP/PG ERROR: parser: parse error at or near ","
>
> Long Description
> The SQL statement
> INSERT INTO users (user_name, comp_id, password) VALUES
('Yuk',8,'Yuk');
>
> works fine when typed directly into the postgres shell, but yields the
error
>
> ERROR: parser: parse error at or near ","
>
> when, and only when the '8' is inserted into the string in PHP by any
means.
>

> In other words, the SQL statement provided works fine when hardcoded,
> but fails every single time (making my application useless) when the
> integer insert value is inserted into the PHP statement by any means.

Try turning on query logging to see what sql statement the backend
thinks
it's getting.