why my transaction doesn't work

[eluser]InsiteFX[/eluser]
Because you are mixing the two different types of transactions!

Auto and Manual.

Code:

// Auto
$this->db->trans_start();
// your queries
$this->db->trans_complete();

if ($this->db->trans_status() === FALSE)
{
    // generate an error... or use the log_message() function to log your error
}

// Manual
$this->db->trans_begin();
// your queries

if ($this->db->trans_status() === FALSE)
{
    $this->db->trans_rollback();
}
else
{
    $this->db->trans_commit();
}