diff options
| author | Peter Zhang <peter@innocraft.com> | 2021-12-20 06:41:32 +0300 |
|---|---|---|
| committer | Peter Zhang <peter@innocraft.com> | 2021-12-20 06:41:32 +0300 |
| commit | 71ad61f59750d613eccc8f6fe1eca586a61763d2 (patch) | |
| tree | 2e1aa83638ea28b02b99356df1f865a3854a4bc1 | |
| parent | 36f83c1468d3ba7bb74a1a755c804f4df21ad78e (diff) | |
Update Archiver.php
update columns query
| -rw-r--r-- | plugins/PagePerformance/Archiver.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/PagePerformance/Archiver.php b/plugins/PagePerformance/Archiver.php index 5b12cac165..b7622c73ec 100644 --- a/plugins/PagePerformance/Archiver.php +++ b/plugins/PagePerformance/Archiver.php @@ -54,7 +54,7 @@ class Archiver extends \Piwik\Plugin\Archiver $column = $dimension->getColumnName(); $selects[] = "sum($table.$column) as {$column}_total"; $selects[] = "sum(if($table.$column is null, 0, 1)) as {$column}_hits"; - $totalColumns[] = "$table.$column"; + $totalColumns[] = "IFNULL($table.$column,0)"; $hitsColumns[] = "if($table.$column is null, 0, 1)"; } |