Welcome Guest, Not a member yet? Register   Sign In
Active Record not putting the FROM clause into its SQL
#1

[eluser]SP1966[/eluser]
Trying to use the ion_auth library and I'm getting this error upon trying to login:


Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `0` = '[email protected]admin.com' LIMIT 1' at line 2

SELECT `username`, `email`, `id`, `password`, `active`, `last_login` WHERE `0` = '[email protected]admin.com' LIMIT 1

Here is the Active Record code from ion_auth that is throwing the error:

$query = $this->db->select($this->identity_column . ', username, email, id, password, active, last_login')
->where($this->identity_column, $this->db->escape_str($identity))
->limit(1)
->get($this->tables['users']);


Any idea what I've messed up for this to be happening?


Messages In This Thread
Active Record not putting the FROM clause into its SQL - by El Forum - 08-15-2012, 08:15 PM
Active Record not putting the FROM clause into its SQL - by El Forum - 08-15-2012, 08:18 PM
Active Record not putting the FROM clause into its SQL - by El Forum - 08-15-2012, 08:22 PM
Active Record not putting the FROM clause into its SQL - by El Forum - 08-16-2012, 01:22 PM



Theme © iAndrew 2016 - Forum software by © MyBB