Welcome Guest, Not a member yet? Register   Sign In
[2.1.1] Active Record quotes marks issues
#11

[eluser]Unknown[/eluser]
I've had the same issue - existing applications have all crashed with the 2.1.1 update using this query syntax in MySQL:

Code:
$this->db->where('myfield >', $val);
$query = $this->db->get('mytable');
#12

[eluser]Unknown[/eluser]
I think similar problem for me... This piece of code returns me a syntax error after upgrade to 2.1.1

Code:
$this->db->join('news_lang', 'news_lang.id_data=news.id AND news_lang.lang = "en"');

Someone has a solution? or should we wait a new update for fix?

Thanks
#13

[eluser]Matalina[/eluser]
[quote author="InsiteFX" date="1339615976"]
Code:
->where("table1.t1_id = table2.t1_id")
// should be
->where("table1.t1_id =", "table2.t1_id")
[/quote]

You can do it the first way.

Quote:Custom string:
You can write your own clauses manually:

$where = "name='Joe' AND status='boss' OR status='active'";

$this->db->where($where);
#14

[eluser]Nom4d3[/eluser]
Well... I don't want to spend hours changing my code in all my systems because of a bug. I will stay on 2.1.0 for now.

#15

[eluser]Nom4d3[/eluser]
They just release a fix for this bug.

https://github.com/EllisLab/CodeIgniter/...nt-6328949

Just re-download 2.1.1.
#16

[eluser]skunkbad[/eluser]
I updated Community Auth last night, and everything seems fine. I didn't do a full test of all parts of the application, but ran the installer and played around with a few pages.




Theme © iAndrew 2016 - Forum software by © MyBB