insert_id not working

[eluser]Fred Riley[/eluser]
Thanks to all for the replies. I do call insert_id() after the insert operation, in a view after the controller to add a new user record is run. This is using ion-auth - the user fills in a registration form, on submit that form runs a controller to insert a user, then calls a view to tell the user that s/he's registered ok and showing them their details. The row is definitely inserted because I see it in the table, and affected_rows() returns 1.

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.

It's all a bit of a mystery, but maybe it's an ion-auth thing. I'll have to check it after the weekend.

Fred