Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

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

Closed
anonymous-piwik-user opened this Issue · 5 comments

4 participants

@anonymous-piwik-user

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-piwik-user

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

@robocoder
Collaborator

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

@robocoder
Collaborator

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

@thaeli

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
Owner

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

@anonymous-piwik-user anonymous-piwik-user added this to the Piwik 1.1 milestone
@mattab mattab added the R: worksforme label
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.