From 438d64e01e9f385b29acd89da4debc705f1125a2 Mon Sep 17 00:00:00 2001 From: mattpiwik Date: Wed, 24 Oct 2012 04:43:38 +0000 Subject: 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. git-svn-id: http://dev.piwik.org/svn/trunk@7293 59fd770c-687e-43c8-a1e3-f5a4ff64c105 --- plugins/Transitions/Transitions.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'plugins/Transitions') diff --git a/plugins/Transitions/Transitions.php b/plugins/Transitions/Transitions.php index 3b6db46876..2487522e82 100644 --- a/plugins/Transitions/Transitions.php +++ b/plugins/Transitions/Transitions.php @@ -84,7 +84,7 @@ class Piwik_Transitions extends Piwik_Plugin $rankingQuery->addLabelColumn('referrer_data'); $select = ' CASE referer_type - WHEN '.Piwik_Common::REFERER_TYPE_DIRECT_ENTRY.' THEN "" + WHEN '.Piwik_Common::REFERER_TYPE_DIRECT_ENTRY.' THEN \'\' WHEN '.Piwik_Common::REFERER_TYPE_SEARCH_ENGINE.' THEN referer_keyword WHEN '.Piwik_Common::REFERER_TYPE_WEBSITE.' THEN referer_url WHEN '.Piwik_Common::REFERER_TYPE_CAMPAIGN.' THEN CONCAT(referer_name, " ", referer_keyword) -- cgit v1.2.3