flexi auth - A user authentication library for CodeIgniter

[eluser]devha[/eluser]
[quote author="haseydesign" date="1369824914"]@devha

Is the error coming from a function where you are stating your own SQL SELECT statement, or is it from using flexi auth library function with default parameters?

Which function is it that is causing the problem?
[/quote]
Im using standard flexi auth function get_user_by_id(), and my flexi auth setup is pretty much standard stuff, only some configuration changes (and table columns renamed).

print_r($this->flexi_auth->get_user_by_id()->row(), true)

Outputs:

DEBUG - 2013-05-29 20:07:48 --> stdClass Object
(
[id] => 2
[group_fk] => 2
[email] => [email protected]
[username] => demo
[password] => *removed*
[ip_address] => ::1
[salt] => tHBJJFpYcw
[activation_token] => a24d49bc6a256580a84fef6b14f90891b163b544
[forgotten_password_token] =>
[forgotten_password_expire] => 0000-00-00 00:00:00
[update_email_token] =>
[update_email] =>
[active] => 1
[suspend] => 0
[fail_login_attempts] => 0
[fail_login_ip_address] =>
[date_fail_login_ban] => 0000-00-00 00:00:00
[date_last_login] => 2013-05-29 20:06:00
[date_added] => 2013-05-23 22:03:24
[name] => Public
[desc] => Public User
[admin] => 0
)

Id is incorrect, it should be 1, now it is user group id.

I think the root of the issue is that the flexi auth gets data from user account and user group tables, both tables have column named id. Now when this data is merged to one object, user account id gets overwritten by user group id as they both have the same identifier.