Welcome Guest, Not a member yet? Register   Sign In
CI 1.6, Small bug in database class
#1

[eluser]Unknown[/eluser]
The orderby() function seems forgot to add table prefix to the sql query string.
For example, all my database table has a prefix t2:
Code:
$this->db->join('users', 'messages.user_id = users.id', 'left outer');                                                              
  $this->db->orderby('messages.id', 'desc');                                                                                      
  $query = $this->db->get('messages');
Got the following error:
Quote: An Error Was Encountered
Error Number: 1054
Unknown column 'loginlogs.id' in 'order clause'
SELECT * FROM (`t2_messages`) LEFT OUTER JOIN `t2_users` ON t2_messages.user_id = t2_users.id ORDER BY messages.id
#2

[eluser]Seppo[/eluser]
You are right, bnut it seems to be fixed for 1.6.1 =)
#3

[eluser]Derek Allard[/eluser]
Yeah, sorry piratas... I did miss some of these. Take a look at 1.6.1 - is this addressed for you?




Theme © iAndrew 2016 - Forum software by © MyBB