Syntax error or access violation: 1055


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?


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?

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

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.