A possible reason why database transactions may not work in CodeIgniter with MySQL

For CodeIgniter transactions to work in MySQL, make sure that the database engine is InnoDB or BDB, both of which are transactional as opposed to MyISAM which is more common but a non-transactional engine.

This is clearly mentioned in the CodeIgniter documentation but easy to miss if you are not paying attention.

Advertisement