id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 12889 mysql error jbeck2@… Stuart Auchterlonie "[0] => SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.program.endtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055] see: http://stackoverflow.com/questions/34115174/i-am-getting-an-error-in-mysql-related-to-only-full-group-by-when-executing-a-qu where it says: (#18) you can turn of the warning as explained in the other answers or you can understand what's happening and fix it. As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY which means when you are grouping rows and then selecting something out of that groups, you need to explicitly say which row should that selection be made from. Mysql needs to know which row in the group you're looking for, which gives you two options Mysql needs to know which row in the group you're looking for, which gives you two options You can also add the column you want to the group statement group by rect.color, rect.value which can be what you want in some cases otherwise would return duplicate results with the same color which you may not want you could also use aggregate functions of mysql to indicate which row you are looking for inside the groups like AVG() MIN() MAX() complete list" Bug Report - General closed minor unknown Plugin - MythWeb Unspecified medium Duplicate mysql ONLY_FULL_GROUP_BY 0