Welcome Guest, Not a member yet? Register   Sign In
Codeigniter Database Transactions
#4

[eluser]ciKD[/eluser]
[quote author="Twisted1919" date="1269824196"]
In the user guide says that if i do :
Code:
$this->db->trans_start(true);
My action will be rolled back, bc that's test mode but it didn't happened , it just updated and deleted the needed records .
[/quote]

Have the same problem with CI 1.7.2 and MySQL 5.1.43

First I thought I had found the problem, because my table was MyISAM and the docs say:
Quote:In MySQL, you'll need to be running InnoDB or BDB table types rather than the more common MyISAM.
Have changed the table type to InnoDB as decribed here
Code:
ALTER TABLE mytable ENGINE=InnoDB;
Change worked fine, phpMyAdmin shows it as Type InnoDB, but when I tried again, still no rollback if testmode is used. It just updates the table as if there would be no transaction used at all.

Can anybody else (besides Twisted1919) confirm this?


Messages In This Thread
Codeigniter Database Transactions - by El Forum - 03-28-2010, 01:44 PM
Codeigniter Database Transactions - by El Forum - 03-28-2010, 01:48 PM
Codeigniter Database Transactions - by El Forum - 03-28-2010, 01:56 PM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 07:06 AM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 08:29 AM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 08:39 AM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 08:59 AM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 01:45 PM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 02:03 PM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 05:24 PM
Codeigniter Database Transactions - by El Forum - 04-05-2010, 05:46 PM
Codeigniter Database Transactions - by El Forum - 04-20-2010, 11:43 AM



Theme © iAndrew 2016 - Forum software by © MyBB