Code Igniter database transactions

[eluser]gtech[/eluser]
[quote author="kirilisa" date="1208763923"]

The freezing is definitely annoying, but what really flips me out is the second thing, how when using trans_start and trans_complete it will in fact update the table if you reload, even though it has crashed with an error. Do you observe this behavior as well?

is that with db_debug ON or OFF? I DO NOT SEE THIS BEHAVIOUR, however with db_debug on you may be nesting transactions (as the first ones not complete) and that is not supported in MYSQL hence the odd behavior (that is a pure guess)

When I first ran into this problem I did a bunch of hunting on the forums and found a fair number of transaction related posts, eg:
http://ellislab.com/forums/viewthread/68368/
http://codeigniter.com/bug_tracker/bug/4339/
http://codeigniter.com/bug_tracker/bug/4299/ (which I see you posted on)

The first one looks like the guy was using the mysqli driver which I have never used but when he used the more common mysql driver it worked (maybe he/she was using the wrong driver for the database).
the other two bugs look the same, and maybe its an oversite, but if you have two transactions in the same request and the first transaction rollsback so will the second.. not a disaster, but annoying when you doing automated testing and have many transactions that rollback within one page request


So it is clear that the whole transaction thing really does need some looking at. I hope that they will get around to it in the next version of CI. I posted this same error in the bug Report forums some weeks ago but unfortunately got no response so I'm not sure how else to submit it.

I must admit I been through the same process and sometimes nobody replies it can be frustrating and is my only real grip with CI, however to stick up for CI a bit as I do like it, db_debug needs to be set to FALSE before you even notice bug 4299 which in my oppinion is not a critical bug/feture request.. just annoying. And apart from that bug (which is v easy to fix) I have never had any other problems with transactions.

I do agree however it does not inspire confidence to someone who has not used the CI transactions code before and it would be nice if at least this problem was documented
[/quote]