From 6e02a95227c4ef194ff2299a823aaa51aa9a223c Mon Sep 17 00:00:00 2001 From: Brian Wolff Date: Wed, 25 Feb 2015 18:23:46 -0400 Subject: [PATCH] Exclude null rows from Special:MediaStatistics The commons db has a random null row in the image table, adding a non-sensical row to this report. Bug: T74535 Change-Id: Ie290e588af56aee7d5303954202f7923b64d2272 --- includes/specials/SpecialMediaStatistics.php | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/includes/specials/SpecialMediaStatistics.php b/includes/specials/SpecialMediaStatistics.php index 1056cdaea7..b62de5d28e 100644 --- a/includes/specials/SpecialMediaStatistics.php +++ b/includes/specials/SpecialMediaStatistics.php @@ -73,6 +73,10 @@ class MediaStatisticsPage extends QueryPage { 'namespace' => NS_MEDIA, /* needs to be something */ 'value' => '1' ), + 'conds' => array( + // WMF has a random null row in the db + 'img_media_type IS NOT NULL' + ), 'options' => array( 'GROUP BY' => array( 'img_media_type', -- 2.20.1