MySQL [Error Code: 1055. 'yourschema.yourtable.yourcolumn' isn't in GROUP BY] error

I recently used this very nice online wizard tool to generate a MySQL configuration file for a dedicated server. The thing is that I enabled the option "SQL Strict Mode" which generated many helpful constraints but one, which was "ONLY_FULL_GROUP_BY".

I don't think many people would like to have this constraint but I know I didn't.

Just open your my.cnf file, remove that constraint and restart your server.


  1. Thanks! This solved a problem I'd been working on for the last two days.


Post a Comment

Popular posts from this blog

Testing SOAP services using pingdom