mysql queries with "Group By" don't work out of the box

[vrdriver]

Hi.
After working on a web app for many years, of which has been functioning well in various production and dev environments with no changes to the mysql config, I came across a problem yesterday where I couldn't perform a query because I had the "Group By" statement in the query. See here for more details.

I solved the problem by editing /etc/mysql/mysql.conf.d/mysqld.cnf

I added the following line to the bottom of the config file.

[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

The only reason I make this suggestion, is scotch-box is said to work straight out of the box, and I figured that there are plenty of queries that use "Group By". Anyway just a thought.