Code Igniter database transactions

[eluser]kirilisa[/eluser]
Yeek!

When I change my test example to use trans_start/trans_complete instead of trans_being/trans_rollback/trans_commit, the DB freezing stops but it updates the table inappropriately on the second reload, just like yours does!!

And I still get intermittent freezing problems, for instance when I switch back and forth between your method and mine in my controller, combined with changing my valid SQL statement with every reload so that the update will happen with every reload.

This *can't* be by design. What am I missing?

EDIT: I can't waste any more time trying to figure this out. I've just trying dumping some echo statements in mysql_driver.php to see if/when it's rolling back, committing, etc. - I can't work it out. I don't understand why it is committing on bad transactions when using trans_start and trans_complete. For now I'm just going to have to trust that everything will work ou when db_debug is FALSE...

I really wish there were some way of asking Derek this stuff, as transactions are fundamental and just seem scarily buggy.