<thomas.vequaud@gmail.com> wrote:
> lol thank you, I feel better!
>
> Yep, you're right... Here is the stack trace :
> Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with
> message 'SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or
> near "." LINE 2: INNER JOIN "is" ON us.user_id = is.user_id ^' in
I think the us.user_id or is.user_id has to be quoted as well and it
doesn't look like it's quoted. I'm not an expert when it comes to
postgresql but I suppose they have reserved words as well (that's
somewhere I suggest you research first) and I think there is your
conflict. ;-)
You double check the above and run the query in phppgadmin and see how
it escapes it, or if it complains right away.
Another idea is that the syntax is slightly off.
Try this style:
SELECT * FROM foo INNER JOIN bar ON (foo.foo = bar.bar)
Just a wild guess though.
Till
没有评论:
发表评论