Skip to content

Instantly share code, notes, and snippets.

@ryanscherler
Created May 9, 2017 17:04
Show Gist options
  • Save ryanscherler/b68a8ceda3c6a6bd28f7177fd8565ff1 to your computer and use it in GitHub Desktop.
Save ryanscherler/b68a8ceda3c6a6bd28f7177fd8565ff1 to your computer and use it in GitHub Desktop.
Craft 2: remove the ONLY_FULL_GROUP_BY option from sql_mode. That will change GROUP BY behavior back to its pre-MySQL 5.7.5 behavior.
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment