First of all, thanks for this, looks very promising.
First thing I did was change the config to suit my mysql table name conventions, which is to always use “id” as the id column, not prefixed in anyway way…
Anyway, so I do
$this->flexi_auth->insert_user('email@example.com', '', 'password', array(), FALSE, TRUE);
to get a username in and got the following error:
Error Number: 1052
Column 'id' in where clause is ambiguous
SELECT `email`, `activation_token` FROM (`user_accounts`) LEFT JOIN `user_groups` ON `user_accounts`.`group_id` = `user_groups`.`id` WHERE `id` = 4 GROUP BY `id`
Line Number: 163
Looks like your query is not specifying the table name in the group by clause.
Anyway simple fix on flexi_auth_lite_model.php line: #152