(bug 20275) Fixed LIKE queries on SQLite backend

[lhc/web/wiklou.git] / maintenance / deleteSelfExternals.php

diff --git a/maintenance/deleteSelfExternals.php b/maintenance/deleteSelfExternals.php
index e2e9789..7beda5d 100644 (file)
--- a/maintenance/deleteSelfExternals.php
+++ b/maintenance/deleteSelfExternals.php
@@ -7,8 +7,8 @@ $db = wfGetDB(DB_MASTER);
 while (1) {
        wfWaitForSlaves( 2 );
        $db->commit();
-       $encServer = $db->escapeLike( $wgServer );
-       $q="DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to LIKE '$encServer/%' LIMIT 1000\n";
+       $q = $db->limitResult( "DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to" 
+               . $db->buildLike( $wgServer . '/', $db->anyString() ), 1000 );
        print "Deleting a batch\n";
        $db->query($q);
        if (!$db->affectedRows()) exit(0);