I don't know how this error appears. I have many controllers that has the same logic but only in some this error appear. Example:

I'm deleting a photo from gallery in which goes order by field 'position'. If I'm deleting the last, there is no problem. When I'm deleting other I must decrement position of all photos after. So if the photo delete link is clicked, there is invoked this action:

[CODE] public function deleteAction() { $id = $this->getRequest()->getParam('id'); $photos = new Photos();

    $where = $photos->getAdapter()->quoteInto('id = ?', $id);
    $photo = $photos->fetchRow($where);

    $position = $photo->position;

    $count = $photos->fetchAll()->count();

    if($position == $count)
    {
        $where = $photos->getAdapter()->quoteInto('id = ?', $id);
        $photos->delete($where);
    }
    else
    {
        $where = $photos->getAdapter()->quoteInto('id = ?', $id);
        $photos->delete($where);

        for($i = $position + 1; $i <= $count; $i++)

        {

            $where = $photos->getAdapter()->quoteInto('position = '.$i);

            $data = array();

            $data['position'] = $i - 1;

            $photos->update($data, $where);

        }
    }

    $this->_redirect('admin/prodgallery');
}

[/CODE]

And it is producting this error:

[CODE] Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound' in /home/httpd/html/shop/library/Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /home/httpd/html/shop/library/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/httpd/html/shop/library/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array) #2 /home/httpd/html/shop/library/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array) #3 /home/httpd/html/shop/library/Zend/Db/Table/Abstract.php(1185): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 /home/httpd/html/shop/library/Zend/Db/Table/Abstract.php(1040): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 /home/httpd/html/shop/application/controllers/AdminController.php(423): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #6 /home/httpd/html/shop/library/Zend/Controller/Action.php(502): AdminCon in /home/httpd/html/shop/library/Zend/Db/Statement/Pdo.php on line 238 [/CODE]

I was searching a lot to solve this. I've found many simmilar errors but in cases where a strange stirngs were binded. In my case we talk about simple numbers...