diff options
author | mattpiwik <matthieu.aubry@gmail.com> | 2012-10-24 08:43:38 +0400 |
---|---|---|
committer | mattpiwik <matthieu.aubry@gmail.com> | 2012-10-24 08:43:38 +0400 |
commit | 438d64e01e9f385b29acd89da4debc705f1125a2 (patch) | |
tree | b1c1b1d6a3ffffc966405c44e6906bca1c5184d7 /plugins/Transitions | |
parent | f27e248230999ef888f7b828d47a7854941b7e53 (diff) |
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
Diffstat (limited to 'plugins/Transitions')
-rw-r--r-- | plugins/Transitions/Transitions.php | 2 |
1 files changed, 1 insertions, 1 deletions
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) |