v 1.3.3 grocery CRUD - an automatic Codeigniter CRUD

[eluser]web-johnny[/eluser]
[quote author="tieungao" date="1303136089"]The error still there.

Look into error, i see that :

In the application/models/ion_auth_model.php have this line :

Code:

$this->db->select(array(
                $this->tables['users'].'.*',
                $this->tables['groups'].'.name AS '. $this->db->protect_identifiers('group'),
                $this->tables['groups'].'.description AS '. $this->db->protect_identifiers('group_description')
                   ));

Don't know why the function protect_identifiers not work like normal, so

Code:

$this->db->protect_identifiers('group')

output : group and this is reserver word for mysql.

That's very strange. I've also posted this issue on the IonAuth thread to see if Ben have

any suggestion.

Cheers.[/quote]

I think I found what the error is. Codeigniter active record automatically uses protect_identifiers so to your select is used two times! try to do this I think it will solve your problem.

Code:

$this->db->select(array(
                $this->tables['users'].'.*',
                $this->tables['groups'].'.name AS '. 'group',
                $this->tables['groups'].'.description AS '. 'group_description'
                   ));

And is secure there is not problem in this.