Page 1 of 1

PGsql error

Posted: Fri Nov 14, 2008 8:18 pm
by swraman
This error really has taken it out of me. I have no idea what it means, I have never worked with pgsql before and now I have to :(

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" LINE 1: INSERT INTO tr_projects () VALUES () ^ in...

Then I get some "Notice: Undefined variable" Notices and

Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in...

Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in

Call to a member function GetNumRows() on a non-object in...

:banghead:

Anyone have any idea whats going on? Or do I need to post the code here? Or even..what the error is talking about? because I have no idea.

Thanks

Re: PGsql error

Posted: Fri Nov 14, 2008 8:51 pm
by Eran
Pay attention to the notices - you might have some undefined variables..
Probably those involved in creating the query, which seems to be devoid of values. And yes, posting some (relevant) code would be helpful