Daily Articles: January 19, 2017

Solved – Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the way GROUP BY behaved in order to be SQL99 compliant (where in previous versions it was not). There is a good overview of the changes here. Unfortunately, this affects some core queries that Craft uses when fetching elements. The good news is that this has been…

Read More

January 19th, 2017 Amazon EC2, Databases, Linux, MySQL, PHP, SolveIt, Tutorials, Ubuntu