Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Piwik doesn't work with MySQL sql_mode ONLY_FULL_GROUP_BY enabled #1733

Closed
anonymous-matomo-user opened this issue Sep 26, 2010 · 5 comments
Closed
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

Comments

@anonymous-matomo-user
Copy link

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.

@anonymous-matomo-user
Copy link
Author

Attachment: This patch detects ONLY_FULL_GROUP_BY and disables it.
strict_mode.patch

@robocoder
Copy link
Contributor

I'd rather fix whatever SQL query is causing the error.

@robocoder
Copy link
Contributor

(In [3185]) fixes #1733 - add non-aggregated columns to GROUP BY clause

@thaeli
Copy link

thaeli commented Mar 26, 2013

I am seeing this issue again in Piwik 1.11.1 and MariaDB 5.5.30 with ONLY_FULL_GROUP_BY enabled. Removing the ONLY_FULL_GROUP_BY option from sql_mode made Piwik work properly again.

@mattab
Copy link
Member

mattab commented Mar 27, 2013

Can you create a new bug for your problem and post the full error message and more information.

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 1.1 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
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.
Projects
None yet
Development

No branches or pull requests

4 participants