You can work around the problem, set within the /etc/my.cnf:
Thereafter restart the MySQL service.
The best way of identifying what the sql_mode string should be is to log on to mysql and execute:
You can then take that string, removing the ONLY_FULL_GROUP_BY part and place the remainder into /etc/my.cnf on the db instance.
Please see following links for further details: