kippo-graph
kippo-graph copied to clipboard
"Group By clause contains nonaggregated column" php / mysql bug fix / patch
PHP / MYSQL VERSION PATCH:
- Group By statements caused compatibility issues with php7.0 as mysql has made changes to "Group By" syntax ERROR: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column References: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html IMPACT: PHP version 5.3.4 or higher were not compatiable. modified: class/KippoGraph.class.php "nonaggregated columns mysql patch" modified: class/KippoPlayLog.class.php "nonaggregated columns mysql patch" Now operational with php7.0 and latest mysql