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.

Comments

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

    ReplyDelete

Post a Comment

Popular posts from this blog

Hosting Apache Tapestry5.1 on GAE (Google App Engine)

Apache Tapestry PageActivationContext tutorial

MySQL workbench not working on Windows 7