[eluser]Nom4d3[/eluser]
I always used my querys like this:
Code:
$this->db->where('O.dope_login', $login);
$this->db->where('O.dope_pass', $pass);
$this->db->where('O.dis_id = D.dis_id');
$query = $this->db->get('dis_operadores AS O, rot_distritos AS D');
I never had any problems. But with 1.7, i got this error:
Code:
A Database Error Occurred
Error Number:
ERROR: missing FROM-clause entry for table "O" LINE 3: WHERE "O"."dope_login" = 'mylogin' ^
SELECT * FROM "dis_operadores" AS O, rot_distritos AS D WHERE "O"."dope_login" = 'mylogin' AND "O"."dope_pass" = 'mypass' AND "O"."dis_id" = D.dis_id
im doing something wrong or this is a new bug? I have a lot of querys with the same problem now :/