Piwik doesn't work with MySQL sql_mode ONLY_FULL_GROUP_BY enabled
|Reported by:||Cybertinus||Owned by:|
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.
Change History (5)
Changed 3 years ago by Cybertinus
comment:1 Changed 3 years ago by vipsoft (robocoder)
- Keywords ONLY_FULL_GROUP_BY failed query removed
- Milestone set to 1.1 - Piwik 1.1
comment:2 Changed 3 years ago by vipsoft (robocoder)
- Resolution set to fixed
- Status changed from new to closed
comment:3 Changed 9 months ago by perel
- Resolution fixed deleted
- Status changed from closed to reopened