insert_id not working

[eluser]Aken[/eluser]
[quote author="Fred Riley" date="1359107068"]I do call insert_id() after the insert operation, in a view after the controller to add a new user record is run.[/quote]

1) Don't call stuff like this in the view. Your controllers and models work the logic, then send it to the views for display only.

2) When I say after, I mean immediately after. E.g.:

Code:

$this->db->insert('table', $data);
$id = $this->db->insert_id();

If you don't do that, you run the risk of something else changing the result.

[quote author="Fred Riley" date="1359107068"]The call to insert_id() worked fine in a previous application I developed in CI 1.7, identical code, which is why I was so surprised that it falls over in my latest app. The user table being inserted into does have an auto-increment primary key.[/quote]

Considering how different 2.1.3 is from 1.7.x, you can't rely on everything being exactly the same.