PGsql error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

PGsql error

Post 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
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: PGsql error

Post 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
Post Reply