From 07db3afa801a6be7b3c730ee35477cd28f5487ec Mon Sep 17 00:00:00 2001 From: Peter Zhang Date: Mon, 20 Dec 2021 16:51:09 +1300 Subject: Revert "Update Archiver.php" This reverts commit 71ad61f59750d613eccc8f6fe1eca586a61763d2. --- 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 b7622c73ec..5b12cac165 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[] = "IFNULL($table.$column,0)"; + $totalColumns[] = "$table.$column"; $hitsColumns[] = "if($table.$column is null, 0, 1)"; } -- cgit v1.2.3