ADOdb, MySQL, and Transactions

Annika Backstrom
in misc, on 23 July 2008. It is tagged #Personal, #ADOdb, #PHP, and #Programming.

![][]I was just bit by some assumptions I made with ADOdb, MySQL 5, and transaction support. I've been using Smart Transactions with success on other systems, but during my current project I noticed the SQL commands were being processed without respecting my FailTrans() call.

Turns out I was using a storage engine that did not support transactions. While InnoDB is ACID-compliant, MyISAM has no support for transactions. Whoops. A few ALTER TABLEs later and I'm back in business.