CODEWITHSUNDEEP
phpzend-frameworktransactions
Akhmed
Akhmed

Reputation: 1179

Zend Framework transactions (Zend_db_adapter)

I have a problem with transactions

$backendB = new BackendBanner();//BackendBanner and ImageBanner extends Zend_Db_Table_Abstract
$backendB->getAdapter()->beginTransaction(); // starting transaction

try {
      $backendB->getAdapter()->insert('module_adv_banner',$data);
      $lastID = $backendB->getAdapter()->lastInsertId();
      $imageBanner = new ImageBanner();
      $imageBanner->getAdapter()->insert('module_adv_filebanner',$imgdata);
      $imageBanner->getAdapter()->commit();
} catch (Exception $e) {
      $backendB->getAdapter()->rollBack();
      echo $e->getMessage();
}

When this controller action executed, I have an SQL error in second insert operator:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id_banner1' in 'field list'

But rollback is not working, first insert query executed successfully and row inserted to the table.

What do I do wrong?

Upvotes: 2

Views: 2158

Answers (1)

zerkms
zerkms

Reputation: 254926

The issue is that you use MyISAM that doesn't support transactions

Upvotes: 6

Related Questions