From d94145ce51b65c87b5f468eb04452d8c8dadb260 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 19 Mar 2007 14:57:57 +0000 Subject: [PATCH] Attempt at fixing 9103: needs testing on mysql site with many protected pages, as mysql is funny about group by stuff. --- includes/SpecialProtectedpages.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/SpecialProtectedpages.php b/includes/SpecialProtectedpages.php index d4a5e0d7d5..f89355a110 100644 --- a/includes/SpecialProtectedpages.php +++ b/includes/SpecialProtectedpages.php @@ -114,9 +114,9 @@ class ProtectedPagesPager extends ReverseChronologicalPager { $conds[] = 'page_id=pr_page'; return array( 'tables' => array( 'page_restrictions', 'page' ), - 'fields' => 'page_id, ' . $this->mDb->tableName( 'page_restrictions' ) . '.*, page_title,page_namespace', + 'fields' => 'max(pr_id) AS pr_id,page_namespace,page_title,pr_level,pr_expiry', 'conds' => $conds, - 'options' => array( 'GROUP BY' => 'page_id' ), + 'options' => array( 'GROUP BY' => 'page_namespace,page_title,pr_level,pr_expiry' ), ); } -- 2.20.1