From ac2204390e61ccedbeb4b9b40d2b23ca2afcd25c Mon Sep 17 00:00:00 2001 From: Antoine Musso Date: Tue, 9 Aug 2005 10:32:11 +0000 Subject: [PATCH] limitResult use 3 parameters since ORACLE changes --- maintenance/convertLinks.inc | 3 ++- maintenance/rebuildrecentchanges.inc | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/maintenance/convertLinks.inc b/maintenance/convertLinks.inc index fe523da9b3..9f3d03ef84 100644 --- a/maintenance/convertLinks.inc +++ b/maintenance/convertLinks.inc @@ -102,7 +102,8 @@ function convertLinks() { performanceLog( "rows inserted vs seconds elapsed:\n" ); for ($rowOffset = $initialRowOffset; $rowOffset < $numRows; $rowOffset += $linksConvInsertInterval) { - $sqlRead = "SELECT * FROM $links ".$dbw->limitResult($linksConvInsertInterval,$rowOffset); + $sqlRead = "SELECT * FROM $links "; + $sqlRead = $dbw->limitResult($sqlRead, $linksConvInsertInterval,$rowOffset); $res = $dbw->query($sqlRead); if ( $noKeys ) { $sqlWrite = array("INSERT INTO $links_temp (l_from,l_to) VALUES "); diff --git a/maintenance/rebuildrecentchanges.inc b/maintenance/rebuildrecentchanges.inc index 888588fa57..4c23901a66 100644 --- a/maintenance/rebuildrecentchanges.inc +++ b/maintenance/rebuildrecentchanges.inc @@ -49,7 +49,8 @@ function rebuildRecentChangesTablePass1() $dbw->query( $sql ); $sql = "SELECT rc_timestamp FROM $recentchanges " . - "ORDER BY rc_timestamp DESC" . $dbw->limitResult( 1, 5000 ); + "ORDER BY rc_timestamp DESC"; + $sql = $dbw->limitResult($sql, 1, 5000 ); $res = $dbw->query( $sql ); $obj = $dbw->fetchObject( $res ); if( $obj ) { -- 2.20.1