Code Igniter database transactions

[eluser]gtech[/eluser]
OK,

my db defaults to innodb so excuse the table create example.

I have to say that running my test on windoze XP I do not see the same behavior, with db_debug set to TRUE my db table continually rolls back after every refresh.. but reading the code I am expecting it to fail..

line 303 of DB_driver.php will call display_error if db_debug is turned on
line 1143 of DB_driver.php is exit; which will terminate the script if db_debug is on and that is maybe why we are seeing different behaviours on different OS's.

but from what you are saying kirilisa is that when db_debug is FALSE it works as expected.

I think then the documentation should say that transactions only work if db_debug is set to FALSE
OR
this is a bug/feature request: don't display the error if its in a transaction.

If it makes you feel better kirilisa I have 25 db tables with about 10 different functions for each table, and about 50% of those are in transactions (the ones with multiple updates/inserts). I have written automated tests for all of these functions and they test rollback by inserting rouge values I then select the data back out of the db to test it.. with db_debug set to FALSE all my test run passed. with db_debug set to TRUE it will obviously halt at the first error. I have tested this with WINDOWSXP, SUSE & UBUNTU LINUX and have had no problems with db_debug set to FALSE, and using 1.4 - 1.6 of CI, and each model is tested within one request (about 100 tests within each request).

stevefink - can you let us know if setting db_debug to FALSE fixes your problem, if so then I can/you can/anyone can open a thread in the bugs forum linking to this thread