Syntax error or access violation: 1055

Support & Bugs
1

Hi,

after installing version 1.5 and putting the trackingcode into the html code
the following error message is displayed in most of the widgets :

SQLSTATE[42000]: Syntax error or access violation: 1055 ‘sub.idsite’ isn’t in GROUP BY

or similar messages.

Does somebody know, how to solve this problem?

Thx

2

I can’t change the mysql configuration globally,
so I found a solution, but it’s not very useful.

Piwik has a problem with mysql databases that are configured with ‘ONLY_FULL_GROUP_BY’.

BUG #1733

By adding the following code in core/Piwik.php on line 1873

Piwik_Exec( “SET SESSION sql_mode=’’” );

the error message disappears.

Thanks to Anton for this hint:
SQL Errors with 0.5.5

But I wonder, why the BUG still exist.
It should be solved with Piwik 1.1

Maybe I have overlooked some configuration possibilities?

3

If you can supply the exact error message, I’ll take another look. (I couldn’t find an instance where we used sub.idsite.)

4

The error still exists in 1.9.2.

But I found out, that the error message will be displayed, if the SQL session is opened with sql_mode = STRICT_ALL_TABLES. Maybe it helps you.