As mentioned in the forum (http://forum.piwik.org/read.php?2,94529) there is a problem with core/RankingQuery.php.
The fix from matt solves the problem:
--- core/RankingQuery.php (revision 7136)
+++ core/RankingQuery.php (revision )
@@ -288,7 +288,7 @@
{
$labelColumnsOthersSwitch[] = "
CASE
$column
$column
Now archive.php is running fine. But withing the Transitions plugin, there is still an error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column !'' in 'field list'
The same problem exists with a totaly new and clean install of piwik
My setup:
SuSE Linux Enterprise
PHP 5.3.17 with APC
mysql 5.5.28 x64 Community
(In [7293]) Fixes #3453 Compatibility with ANSI_QUOTES
If the ANSI_QUOTES SQL mode is enabled, string literals can be quoted only within single quotes because a string quoted within double quotes is interpreted as an identifier.
(In [7294]) Without debug statement please Refs #3453
There is still a problem with the Transitions plugin:
SQLSTATE[42S22]: Column not found: 1054 Unknown column !'' in 'field list'
I fixed in: http://dev.piwik.org/trac/changeset/7293#file1
have you tried this patch? it works for me
Yes i did exactly the same patch here without success.
After waiting for 2-3 seconds, i get SQLSTATE[42S22]: Column not found: 1054 Unknown column ' ' in 'field list'
OK.. found it.
You need to change this line
WHEN '.Piwik_Common::REFERER_TYPE_CAMPAIGN.' THEN CONCAT(referer_name, " ", referer_keyword)
to
WHEN '.Piwik_Common::REFERER_TYPE_CAMPAIGN.' THEN CONCAT(referer_name, \' \', referer_keyword)
then everything is working fine