View Single Post
  #5 (permalink)  
Old 03-26-2008, 12:50 PM
emptiness emptiness is offline
Junior Member
 
Join Date: Mar 2008
Posts: 4
Default

Do you use the Zend Framework 1.5 ??

The comment is a test but with another line it change nothing.

In $ID is correct:

Fatal error: Uncaught exception 'Zend_Db_Statement_Oracle_Exception' with message '933 ORA-00933: SQL command not properly ended SELECT "ALBUM".* FROM "ALBUM" WHERE ("ID" = 41) *SELECT z2.* FROM ( SELECT ROWNUM AS zend_db_rownum, z1.* FROM ( ) z1 ) z2 WHERE z2.zend_db_rownum BETWEEN 1 AND 1' in /var/www/ZendFramework/library/Zend/Db/Statement/Oracle.php:244 Stack trace: #0 /var/www/ZendFramework/library/Zend/Db/Statement.php(283): Zend_Db_Statement_Oracle->_execute(Array) #1 /var/www/ZendFramework/library/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array) #2 /var/www/ZendFramework/library/Zend/Db/Table/Abstract.php(1185): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select)) #3 /var/www/ZendFramework/library/Zend/Db/Table/Abstract.php(1082): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #4 /var/www/ZendFramework/library/Zend/Db/Table/Row/Abstract.php(692): Zend_Db_Table_Abstract- in /var/www/ZendFramework/libary/Zend/Db/Statement/Oracle.php on line 244


$del is null
$row is null

because the error is in the else in fechrow
No continue for print the form


In debug:

In Abstract.php the function query

$stmt = $this->prepare($sql);
the $sql is:

Code:
SELECT "ALBUM".* FROM "SAGA"."ALBUM" WHERE (ID=17) SELECT z2.*
            FROM (
                SELECT ROWNUM AS zend_db_rownum, z1.*
                FROM (
                    
                ) z1
            ) z2
            WHERE z2.zend_db_rownum BETWEEN 1 AND 1

In oracle.php

$retval = @oci_execute($this->_stmt,$this->_adapter->_getExecuteMode());

return false and error........ and go exception.....
Reply With Quote