flexi auth - A user authentication library for CodeIgniter

[eluser]AJReading[/eluser]
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

Code:

$this->flexi_auth->insert_user('[email protected]', '', 'password', array(), FALSE, TRUE);

to get a username in and got the following error:

Code:

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

Code:

$this->db->group_by(.$this->auth->tbl_col_user_account['id']);

to

Code:

$this->db->group_by($this->auth->tbl_user_account.'.'.$this->auth->tbl_col_user_account['id']);