From b8f14ea7ba0eab57b8f0e6d828c39889dc693836 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 2 May 2007 00:20:28 +0000 Subject: [PATCH] Add items back to group by clause: breaks all other databases except MySQL :) If short list truly needed, consider $this->mDb->implicitGroupby() --- includes/SpecialProtectedpages.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialProtectedpages.php b/includes/SpecialProtectedpages.php index d66fe4e5b5..40143e55ed 100644 --- a/includes/SpecialProtectedpages.php +++ b/includes/SpecialProtectedpages.php @@ -248,7 +248,7 @@ class ProtectedPagesPager extends AlphabeticPager { 'tables' => array( 'page_restrictions', 'page' ), 'fields' => 'max(pr_id) AS pr_id,page_namespace,page_title,page_len,pr_type,pr_level,pr_expiry', 'conds' => $conds, - 'options' => array( 'GROUP BY' => 'page_namespace,page_title,pr_type' ), + 'options' => array( 'GROUP BY' => 'page_namespace,page_title,page_len,pr_type,pr_level,pr_expiry' ), ); } -- 2.20.1