From 30cd7bd6e85b18cd8dbb09cddad7009684b5db00 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 31 Aug 2016 09:17:27 +0200 Subject: [PATCH] Must be id to have NULL counted, too. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Roland Häder --- libs/lib_updates.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/libs/lib_updates.php b/libs/lib_updates.php index 94e4f4b..fd34fcc 100644 --- a/libs/lib_updates.php +++ b/libs/lib_updates.php @@ -94,7 +94,7 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] . // View for request methods 8 => array( 'CREATE VIEW `view_most_request_methods` AS - SELECT SQL_CALC_FOUND_ROWS COUNT(`request_method`) AS `total_rows`, `request_method` + SELECT SQL_CALC_FOUND_ROWS COUNT(`id`) AS `total_rows`, `request_method` FROM `ctracker_data` GROUP BY `request_method`' ), -- 2.39.2