(Oracle) fetchrow error

emptiness · #1 (**permalink**) 03-25-2008, 04:53 PM

ERROR:

Code:

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/library/Zend/Db/Statement/Oracle.php on line 244

The Zend framework add "..*SELECT z2.* FROM ( SELECT ROWNUM AS zend_db_rownum, z1.* FROM ( ) z1 ) z2 WHERE..." ????

Model :

PHP Code:


			
class Albums extends Zend_Db_Table_Abstract
{
    protected $_name = 'ALBUM';
    protected $_primary = 'ID';
}

Function in my controller:

PHP Code:


			
    function deleteAction()
    {

        $this->view->title = "Supprimer l'album";
        
        $album = new Albums();
        if ($this->_request->isPost()) {
            Zend_Loader::loadClass('Zend_Filter_Alpha');
            $filter = new Zend_Filter_Alpha();
            
            $ID = (int)$this->_request->getPost('ID');
            $del = $filter->filter($this->_request->getPost('del'));
            
            if (($del == 'Oui') && ($ID > 0)) {
                $where = 'ID = ' . $ID;
                $rows_affected = $album->delete($where);
            }
        } else {
            
            $ID = (int)$this->_request->getParam('ID');
            if ($ID > 0) {
                // only render if we have an id and can find the album.
                //$this->view->album = $album->fetchRow('ID='.$ID);
                $row = $album->fetchRow($album->select()->where('ID='.$ID));
                
                if ($this->view->album->ID > 0) {
                    // render template automatically
                    return;
                }
            }
        }
        
        // redirect back to the album list unless we have rendered the view
        $this->_redirect('/');        
    }

Its the fetchrow in the ELSE is not working

michael063 · #2 (**permalink**) 03-25-2008, 05:29 PM

Quote:

Originally Posted by emptiness

ERROR:

Code:

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/library/Zend/Db/Statement/Oracle.php on line 244

The Zend framework add "..*SELECT z2.* FROM ( SELECT ROWNUM AS zend_db_rownum, z1.* FROM ( ) z1 ) z2 WHERE..." ????

Model :

PHP Code:


			
class Albums extends Zend_Db_Table_Abstract

{

    protected $_name = 'ALBUM';

    protected $_primary = 'ID';

}

Function in my controller:

PHP Code:


			
    function deleteAction()

    {



        $this->view->title = "Supprimer l'album";

        

        $album = new Albums();

        if ($this->_request->isPost()) {

            Zend_Loader::loadClass('Zend_Filter_Alpha');

            $filter = new Zend_Filter_Alpha();

            

            $ID = (int)$this->_request->getPost('ID');

            $del = $filter->filter($this->_request->getPost('del'));

            

            if (($del == 'Oui') && ($ID > 0)) {

                $where = 'ID = ' . $ID;

                $rows_affected = $album->delete($where);

            }

        } else {

            

            $ID = (int)$this->_request->getParam('ID');

            if ($ID > 0) {

                // only render if we have an id and can find the album.

                //$this->view->album = $album->fetchRow('ID='.$ID);

                $row = $album->fetchRow($album->select()->where('ID='.$ID));

                

                if ($this->view->album->ID > 0) {

                    // render template automatically

                    return;

                }

            }

        }

        

        // redirect back to the album list unless we have rendered the view

        $this->_redirect('/');        

    }

Its the fetchrow in the ELSE is not working

See the work code...(sorry of my bad english, I'm from russia)

Model (Schema required)

Album.php

PHP Code:


			
class Album extends Zend_Db_Table

{

   protected $_name = 'BIS.ALBUM';

   protected $_primary = 'RECID';

   protected $_sequence = false;

}

MusicController.php

PHP Code:


			
function deleteAction()

        {

                $this->view->title = "Delete Album";

                $album = new Album();



                if ($this->_request->isPost()){

                        Zend_Loader::loadClass('Zend_Filter_Alpha');

                        $filter = new Zend_Filter_Alpha();

                        $recid = (int)$this->_request->getPost('recid');

                        $del = $filter->filter($this->_request->getPost('del'));



                        if ($del == 'Yes' && $recid > 0) {

                                $where = 'recid=' . $recid;

                                $rows_affected = $album->delete($where);

                        }

                } else {

                        $recid = (int)$this->_request->getParam('recid');

                        if ($recid > 0) {

                                //only render if we have an id and can find the album

                                $this->view->album = $album->fetchRow('recid=' .$recid);



                  if ($this->view->album->RECID > 0) {

                                        // render template automatically

                                        return;

                                }

                        }

                }



                //redirect back to the album list unless we have rendered the view

                $this->_redirect('/admin/music/index');

        }

work it! of my test example.

emptiness · #3 (**permalink**) 03-25-2008, 06:07 PM

With oracle ??

i have add :

PHP Code:


			
class Albums extends Zend_Db_Table_Abstract
{
    protected $_name = 'SAGA.ALBUM';
    protected $_primary = 'ID';
    protected $_sequence = false; 
    
}

and not work

With a fetchall is ok!!!!!

thanks

michael063 · #4 (**permalink**) 03-26-2008, 06:00 AM

Quote:

Originally Posted by emptiness

With oracle ??

i have add :

PHP Code:


			
class Albums extends Zend_Db_Table_Abstract
{
    protected $_name = 'SAGA.ALBUM';
    protected $_primary = 'ID';
    protected $_sequence = false; 
    
}

and not work

With a fetchall is ok!!!!!

thanks

Yes, I'am use Oracle DB.

Why commented this??

PHP Code:


			
                $this->view->album = $album->fetchRow('ID='.$ID);

In

PHP Code:


			
f ($ID > 0) {
                // only render if we have an id and can find the album.
!!!             //$this->view->album = $album->fetchRow('ID='.$ID);
                $row = $album->fetchRow($album->select()->where('ID='.$ID));

and do it

PHP Code:


			
var_dump($del); var_dump($ID); and $var_dump($row);

emptiness · #5 (**permalink**) 03-26-2008, 12:50 PM

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.....

emptiness · #6 (**permalink**) 03-28-2008, 12:13 PM

Finally, my problem work with zend framework 1.5.1. The error is in zend framework 1.5

thanks

michael063 · #7 (**permalink**) 03-29-2008, 04:06 AM

Quote:

Originally Posted by emptiness

Finally, my problem work with zend framework 1.5.1. The error is in zend framework 1.5

thanks

Congratulations!!!!

me too this bug in my post about Db2 LIMIT/OFFSET, i'am update 1.5.1, and build valide SQL. But my DB2 is not supported this construction (between and e.t.c.).

I realize self Db2Fix class extends Zend_Db_Select

kusipo · #8 (**permalink**) 04-09-2008, 02:39 AM

Quote:

Originally Posted by emptiness

Finally, my problem work with zend framework 1.5.1. The error is in zend framework 1.5

thanks

what is the version u're using right now that solving ur problem?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode