SQL Mode requirement not documented

[crossan007]

SQL mode must not contain ONLY_FULL_GROUP_BY

[crossan007]

It seems that the Vagrant SQL is 5.5.46, which works fine, but 5.7.16 changes the way GROUP BY clauses work: http://craftcms.stackexchange.com/questions/12084/getting-this-sql-error-group-by-incompatible-with-sql-mode-only-full-group-by

one solution is to set the global sql mode

SET GLOBAL sql_mode = '';

[crossan007]

doctrine/orm#5622

[crossan007]

http://stackoverflow.com/questions/23921117/disable-only-full-group-by/37508414#37508414

[crossan007]

20
down vote
Adding only one mode to sql_mode without removing existing ones:

SET sql_mode=(SELECT CONCAT(@@sql_mode,',<mode_to_add>'));
Removing only a specific mode from sql_mode without removing others:

SET sql_mode=(SELECT REPLACE(@@sql_mode,'<mode_to_remove>',''));
In your case, if you want to remove only ONLY_FULL_GROUP_BY mode, then use below command:

SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));
Reference: http://johnemb.blogspot.com/2014/09/adding-or-removing-individual-sql-modes.html

[crossan007]

This Sort of relates to https://github.com/ChurchCRM/VagrantBox/issues/5 - We don't get the error in testing because we're testing with old software.

[crossan007]

I think this is here: propelorm/Propel2#1129

[crossan007]

See #2380