From 7cd868cb70d55d95b3d73d3f7f5f55d4dddf7870 Mon Sep 17 00:00:00 2001 From: Alex Z Date: Mon, 15 Jun 2009 03:05:28 +0000 Subject: [PATCH] (bug 19160) Use DISTINCT instead of DISTINCTROW for compatibility with postgresql --- RELEASE-NOTES | 1 + maintenance/purgeOldText.inc | 4 ++-- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index ce426775fa..f308804e2d 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -184,6 +184,7 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN * (bug 19112) Preferences now respects $wgUseExternalEditor, $wgExternalDiffEngine * (bug 18173) MediaWiki now fails when unable to determine a client IP * (bug 19170) Special:Version should follow the content language direction +* (bug 19160) maintenance/purgeOldText.inc is now compatible with PostgreSQL == API changes in 1.16 == diff --git a/maintenance/purgeOldText.inc b/maintenance/purgeOldText.inc index e41c374db2..0bd5f2ebd3 100644 --- a/maintenance/purgeOldText.inc +++ b/maintenance/purgeOldText.inc @@ -20,7 +20,7 @@ function PurgeRedundantText( $delete = false ) { # Get "active" text records from the revisions table echo( "Searching for active text records in revisions table..." ); - $res = $dbw->query( "SELECT DISTINCTROW rev_text_id FROM $tbl_rev" ); + $res = $dbw->query( "SELECT DISTINCT rev_text_id FROM $tbl_rev" ); while( $row = $dbw->fetchObject( $res ) ) { $cur[] = $row->rev_text_id; } @@ -28,7 +28,7 @@ function PurgeRedundantText( $delete = false ) { # Get "active" text records from the archive table echo( "Searching for active text records in archive table..." ); - $res = $dbw->query( "SELECT DISTINCTROW ar_text_id FROM $tbl_arc" ); + $res = $dbw->query( "SELECT DISTINCT ar_text_id FROM $tbl_arc" ); while( $row = $dbw->fetchObject( $res ) ) { $cur[] = $row->ar_text_id; } -- 2.20.1