• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
possible DB glitch in 1.7

#1
[eluser]Jevedor[/eluser]
I just recently tried updating my CI 1.6.3 to 1.7 and ran into an issue that was not documented in the update guide.

I have a good number of sql scripts that run on my site and any of them that used "AS" became broken after installing the the 1.7 database library.

Here is an example of some code that worked in 1.6.3 but no longer does in 1.7


$this->CI->db->select('a.*, b.page_name AS parent_name');
$this->CI->db->from('pages AS a');
$this->CI->db->join('pages AS b', 'a.parent_id = b.page_id', 'left');
$this->CI->db->where('a.display_status', 'Y');
$this->CI->db->orderby('a.parent_id, a.sort_order');

$this->navigation = $this->CI->db->get();

Has something been deprecated that I am not aware of or Am I doing something incorrectly?

For now i will continue to use 1.6.3 as it still works but I would like to be able to use all of 1.7. Any help would be appreciated.


Messages In This Thread
possible DB glitch in 1.7 - by El Forum - 11-25-2008, 03:58 PM
possible DB glitch in 1.7 - by El Forum - 11-25-2008, 06:46 PM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:23 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:51 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:52 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:53 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 09:00 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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