title: GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in Codeigniter
body: <p>Codeigniter/MYSQL returns this error</p>
  
  <pre><code>Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'database.segment.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  </code></pre>
  
  <p>How I can fix this? Yesterday works fine.</p>
  
  <p>In the console if I use SET sql_mode = '' before execute the Query works fine but Codeigniter return the same error.</p>
  
  <p>EDIT: Solved</p>
  
  <pre><code>SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_‌​DIVISION_BY_ZERO,NO_‌​AUTO_CREATE_USER,NO_‌​ENGINE_SUBSTITUTION'
  </code></pre>