Code Igniter database transactions

[eluser]gtech[/eluser]
Just comment out the call to display error.. don't rollback in the query function as you will rollback before your transaction is completed... eg you have two queries in a transaction- the 1st one fails and your 'fix' will rollback before the second query is called.

what the code does is set _trans_Status TRUE when you first load your page and then it is set to FALSE if an error happens on a query.. If the flag is FALSE when the trans_complete function is called it will rollback, if it TRUE it will be commited

so just comment out

Code:

//return $this->display_error(array("Error Number: $errno",$errmsg,$sql));

and I reckon that will fix transactions if db_debug is set to TRUE.. however I just recommend setting the flag to FALSE in the config file.. it just saves messing around, I just don't think its designed to run with debug on.