title: ONLY_FULL_GROUP_BY not set but still have Error 1140
body: <p>I am finalizing the implementation of my website but now I have a problem that occurs online that I have not locally.</p>
  
  <p>I get this error:</p>
  
  <pre><code>failed: Mixing of GROUP columns (MIN (), MAX (), COUNT (), ...) with no GROUP columns is illegal if there is no GROUP BY clause
  </code></pre>
  
  <p>result of a SQL query</p>
  
  <p>I searched in lot of forums on the net, most users advise to change the query that I can not / do not want, or they say it was probably in the sql-mode: enabled <code>ONLY_FULL_GROUP_BY</code> of the server</p>
  
  <p>My sql-mode is empty on my server online (I can see with the query <code>select @@sql_mode;</code>)
  More to be sure, I put <code>sql_mode='' in my.cnf</code>.</p>
  
  <p>But the problem remains.</p>
  
  <p>Is this due to my version of mysql 5.0.44 on my server online and locally 5.1.32 (which I do not have this bug ...)?</p>