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
D:\www\MyDirco\src\library\Zend\Db\Statement\Pdo.php:238 Stack trace:
#0 D:\www\MyDirco\src\library\Zend\Db\Statement.php(283):
Zend_Db_Statement_Pdo->_execute(Array) #1
D:\www\MyDirco\src\library\Zend\Db\Adapter\Abstract.php(430):
Zend_Db_Statement->execute(Array) #2
D:\www\MyDirco\src\library\Zend\Db\Adapter\Pdo\Abstract.php(230):
Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 D:\www\MyDirco\src\library\Zend\Db\Table\Abstract.php(1330):
Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4
D:\www\MyDirco\src\library\Zend\Db\Table\Abstract.php(1158):
Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5
D:\www\MyDirco\src\application\models\User.php(108):
Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #6
D:\www\MyD in D:\www\MyDirco\src\library\Zend\Db\Statement\Pdo.php on
line 238
On Fri, Dec 19, 2008 at 11:34 AM, till <klimpong@gmail.com> wrote:
> On Fri, Dec 19, 2008 at 11:29 AM, Thomas VEQUAUD
> <thomas.vequaud@gmail.com> wrote:
>> Ok sorry for the waist of time, I found the answer in the zend
>> framework manual, here :
>> http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.connecting.parameters.example2
>>
>> So, I modified the index.php (see below) but I still have the same
>> query syntax error... Am I stupid or I just didn't sleep enough this
>> night?!?!
>
> I don't think so! :-) Well, maybe lack of sleep. ;-))
>
> But can you share the exact error with the list?
>
> Code looks alright when I look at it, but I don't have your schema to
> replicate it, nor do I have postgresql. So providing the error message
> might be helpful for others, so they can help you.
没有评论:
发表评论