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('username@gmail.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`
Filename: /home/supplementdb.co.uk/htdocs/dev/models/flexi_auth_lite_model.php
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
$this->db->group_by(.$this->auth->tbl_col_user_account['id']);
to
$this->db->group_by($this->auth->tbl_user_account.'.'.$this->auth->tbl_col_user_account['id']);
. Cheers