• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[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.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.