On Sun, Apr 12, 2009 at 1:24 PM, srayner02 <srayner02@googlemail.com> wrote:
>
> I am completely new to Zend Framework, so please forgive my ignorance :-)
>
> Following the Quickstart tutorial, i am trying to adapt it to use a firebird
> database as opposed to SQLite.
>
> I have PHP_Interbase module loaded, and have added the ZendX firebird
> database adaptor.
>
> However i am getting a Firebird prepare error -104 unexpected end of
> command.
> This is my stack trace;
>
> #0 C:\www\Quickstart\library\Zend\Db\Statement.php(109):
> ZendX_Db_Statement_Firebird->_prepare('SELECT "guestbo...')
> #1 C:\www\Quickstart\library\ZendX\Db\Adapter\Firebird.php(341):
> Zend_Db_Statement->__construct(Object(ZendX_Db_Adapter_Firebird), 'SELECT
> "guestbo...')
> #2 C:\www\Quickstart\library\Zend\Db\Adapter\Abstract.php(432):
> ZendX_Db_Adapter_Firebird->prepare('SELECT "guestbo...')
> #3 C:\www\Quickstart\library\Zend\Db\Table\Abstract.php(1330):
> Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select))
> #4 C:\www\Quickstart\library\Zend\Db\Table\Abstract.php(1158):
> Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
> #5 C:\www\Quickstart\application\models\GuestBook.php(71):
> Zend_Db_Table_Abstract->fetchAll('1')
> #6 C:\www\Quickstart\application\controllers\GuestbookController.php(33):
> Model_GuestBook->fetchEntries()
> #7 C:\www\Quickstart\library\Zend\Controller\Action.php(503):
> GuestbookController->indexAction()
> #8 C:\www\Quickstart\library\Zend\Controller\Dispatcher\Standard.php(285):
> Zend_Controller_Action->dispatch('indexAction')
> #9 C:\www\Quickstart\library\Zend\Controller\Front.php(934):
> Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http),
> Object(Zend_Controller_Response_Http))
> #10 C:\www\Quickstart\public\index.php(48):
> Zend_Controller_Front->dispatch()
> #11 {main}
>
> Looking at the stack trace does it appear that i have everything in the
> right place?
> I'm just not sure how to proceed in diagnosing the problem.
>
> Any help much appreciated. (Let me know if i should post more info).
>
> Steve
Just guessing, but unexpected end of command generally means that the
terminator wasn't "understood", so e.g. if you defined a stored
procedure and the server doesn't recognize the terminator, it'll error
out with this. I'm not too familiar with Firebird, but I'm guessing
your SQL code uses a terminator (e.g. ";") that the server currently
doesn't recognize as one.
HTH,
Till
没有评论:
发表评论