From 71ad61f59750d613eccc8f6fe1eca586a61763d2 Mon Sep 17 00:00:00 2001 From: Peter Zhang Date: Mon, 20 Dec 2021 16:41:32 +1300 Subject: Update Archiver.php update columns query --- plugins/PagePerformance/Archiver.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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)"; } -- cgit v1.2.3