From 8b13fa81f1f520a8fbf23216558dac5f4942fa37 Mon Sep 17 00:00:00 2001 From: Alexandre Emsenhuber Date: Thu, 22 Oct 2009 15:51:01 +0000 Subject: [PATCH] * (bug 21006) maintenance/updateArticleCount.php now works again on PostgreSQL --- RELEASE-NOTES | 1 + maintenance/updateArticleCount.php | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index fc3a38dd7c..02b4b19174 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -585,6 +585,7 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN * (bug 20268) Fixed row count estimation on SQLite backend * (bug 20275) Fixed LIKE queries on SQLite backend * (bug 21234) Moving subpages of titles containing \\ now works properly +* (bug 21006) maintenance/updateArticleCount.php now works again on PostgreSQL == API changes in 1.16 == diff --git a/maintenance/updateArticleCount.php b/maintenance/updateArticleCount.php index d2776e58ba..e68184581f 100644 --- a/maintenance/updateArticleCount.php +++ b/maintenance/updateArticleCount.php @@ -77,7 +77,7 @@ class UpdateArticleCount extends Maintenance { private function makeSql( $dbr ) { list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' ); $nsset = $this->makeNsSet(); - return "SELECT COUNT(DISTINCT page_namespace, page_title) AS pagecount " . + return "SELECT COUNT(DISTINCT page_id) AS pagecount " . "FROM $page, $pagelinks " . "WHERE pl_from=page_id and page_namespace IN ( $nsset ) " . "AND page_is_redirect = 0 AND page_len > 0"; -- 2.20.1