title: Zend Framework transactions (Zend_db_adapter)
body: <p>I have a problem with transactions</p>
  
  <pre><code>$backendB = new BackendBanner();//BackendBanner and ImageBanner extends Zend_Db_Table_Abstract
  $backendB-&gt;getAdapter()-&gt;beginTransaction(); // starting transaction
  
  try {
        $backendB-&gt;getAdapter()-&gt;insert('module_adv_banner',$data);
        $lastID = $backendB-&gt;getAdapter()-&gt;lastInsertId();
        $imageBanner = new ImageBanner();
        $imageBanner-&gt;getAdapter()-&gt;insert('module_adv_filebanner',$imgdata);
        $imageBanner-&gt;getAdapter()-&gt;commit();
  } catch (Exception $e) {
        $backendB-&gt;getAdapter()-&gt;rollBack();
        echo $e-&gt;getMessage();
  }
  </code></pre>
  
  <p>When this controller action executed, I have an SQL error in second insert operator:</p>
  
  <pre><code>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id_banner1' in 'field list'
  </code></pre>
  
  <p>But rollback is not working, first insert query executed successfully and row inserted to the table.</p>
  
  <p>What do I do wrong? </p>