* @todo More efficient cleanup of text records
*/
-require_once( "Maintenance.php" );
+require_once( dirname(__FILE__) . '/Maintenance.php' );
class DeleteOrphanedRevisions extends Maintenance {
public function __construct() {
$report = $this->hasOption('report');
$dbw = wfGetDB( DB_MASTER );
- $dbw->immediateBegin();
- list( $page, $revision ) = $dbw->tableNames( 'page', 'revision' );
+ $dbw->begin();
+ list( $page, $revision ) = $dbw->tableNamesN( 'page', 'revision' );
# Find all the orphaned revisions
$this->output( "Checking for orphaned revisions..." );
$res = $dbw->query( $sql, 'deleteOrphanedRevisions' );
# Stash 'em all up for deletion (if needed)
- while( $row = $dbw->fetchObject( $res ) )
+ $revisions = array();
+ foreach( $res as $row )
$revisions[] = $row->rev_id;
$dbw->freeResult( $res );
$count = count( $revisions );
# Nothing to do?
if( $report || $count == 0 ) {
- $dbw->immediateCommit();
+ $dbw->commit();
exit(0);
}
$this->output( "done.\n" );
# Close the transaction and call the script to purge unused text records
- $dbw->immediateCommit();
+ $dbw->commit();
$this->purgeRedundantText( true );
}