X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Forphans.php;h=7acf6d8279dc41496cd06f3b040b251f2128e454;hb=107ee818cfd738db3bf1be86a52773e3e7760c0f;hp=945df325606aed9e53d6e95fcb30a0bd23df409e;hpb=e5879da149afe183ce889ef6f4158086c9b4735f;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/orphans.php b/maintenance/orphans.php index 945df32560..7acf6d8279 100644 --- a/maintenance/orphans.php +++ b/maintenance/orphans.php @@ -82,16 +82,18 @@ class Orphans extends Maintenance { } $commentQuery = $commentStore->getJoin( 'rev_comment' ); + $actorQuery = ActorMigration::newMigration()->getJoin( 'rev_user' ); $this->output( "Checking for orphan revision table entries... " . "(this may take a while on a large wiki)\n" ); $result = $dbw->select( - [ 'revision', 'page' ] + $commentQuery['tables'], - [ 'rev_id', 'rev_page', 'rev_timestamp', 'rev_user_text' ] + $commentQuery['fields'], + [ 'revision', 'page' ] + $commentQuery['tables'] + $actorQuery['tables'], + [ 'rev_id', 'rev_page', 'rev_timestamp' ] + $commentQuery['fields'] + $actorQuery['fields'], [ 'page_id' => null ], __METHOD__, [], [ 'page' => [ 'LEFT JOIN', [ 'rev_page=page_id' ] ] ] + $commentQuery['joins'] + + $actorQuery['joins'] ); $orphans = $result->numRows(); if ( $orphans > 0 ) {