Piwik doesn't work with MySQL sql_mode ONLY_FULL_GROUP_BY enabled #1733
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
Major
Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
worksforme
The issue cannot be reproduced and things work as intended.
Milestone
Hello,
When somebody has configured there MySQL server with sql_mode ONLY_FULL_GROUP_BY enabled, Piwik chrashes all the time with errors that there are columns SELECTed which aren't specified in the GROUP BY.
I've created a small patch which can detect this setting on the MySQL server and configures the connection Piwik uses, to use the default sql_mode in order to make Piwik work like expected.
The text was updated successfully, but these errors were encountered: