[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