diff options
author | sgiehl <stefan@piwik.org> | 2014-11-24 02:06:40 +0300 |
---|---|---|
committer | sgiehl <stefan@piwik.org> | 2014-11-24 02:06:40 +0300 |
commit | fcd486861307b74c75f8ef97cfb9d48befdc3733 (patch) | |
tree | be61586f388af11a2edddd1e3c7048c51c37ae61 /plugins | |
parent | e2ce5cd0bc284f9cef6d337d6689b3d88c72e7e5 (diff) |
fix archiving for old log_visit entries having NULL as os_version
Diffstat (limited to 'plugins')
-rw-r--r-- | plugins/DevicesDetection/Archiver.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/DevicesDetection/Archiver.php b/plugins/DevicesDetection/Archiver.php index e91a1be0fe..0d6f40c062 100644 --- a/plugins/DevicesDetection/Archiver.php +++ b/plugins/DevicesDetection/Archiver.php @@ -26,7 +26,7 @@ class Archiver extends \Piwik\Plugin\Archiver const DEVICE_BRAND_FIELD = "config_device_brand"; const DEVICE_MODEL_FIELD = "config_device_model"; const OS_FIELD = "config_os"; - const OS_VERSION_FIELD = "CONCAT(log_visit.config_os, ';', log_visit.config_os_version)"; + const OS_VERSION_FIELD = "CONCAT(log_visit.config_os, ';', COALESCE(log_visit.config_os_version, ''))"; const BROWSER_FIELD = "config_browser_name"; const BROWSER_ENGINE_FIELD = "config_browser_engine"; const BROWSER_VERSION_DIMENSION = "CONCAT(log_visit.config_browser_name, ';', log_visit.config_browser_version)"; |