title: Codeigniter Database Error 1055 - isn't in GROUP BY
body: <pre><code>$query = $this-&gt;db-&gt;group_by('hs_tktno');
  $query = $this-&gt;db-&gt;where('hs_toid', $id);
  $query = $this-&gt;db-&gt;order_by('hs_id', &quot;desc&quot;);
  $query = $this-&gt;db-&gt;get('table');
  $data[&quot;list&quot;] =  $query-&gt;result();
  </code></pre>
  <p>Im Getting the following error when i try to excute the above code
  any ideas?</p>
  <blockquote>
  <p>Error Number: 1055</p>
  <p>'dbname.table.hs_id' isn't in GROUP BY</p>
  <p>SELECT * FROM (<code>table</code>) WHERE <code>hs_status</code> = '0' GROUP BY <code>hs_tktno</code></p>
  </blockquote>