Hi there,
today i've encountered a curious behaviour using CI transactions, calling a series of update queryies.
The strange thing is that the transaction not rollback when one of queryies return a sql error, (like an unexcistent field in a table), the other queryies before the one that is throwing the error are executed normally.
The only thing i see is a sql error on screen.
my code is similar to this:
$this->db->trans_start();
$this->db->update(...);
$this->db->update(...);
$this->db->update(...);
$this->db->trans_complete();
echo ($this->db->trans_status === false) ? 'Rollback' : 'Ok';
Thank you
Someone knows why it not rollback as expected?