https://bugzilla.wikimedia.org/show_bug.cgi?id=71086
--- Comment #8 from Aaron Schulz <[email protected]> --- (In reply to Brad Jorsch from comment #7) > (In reply to Aaron Schulz from comment #3) > > As for the duplicates already there, I guess the cache can just be > > cleared/rebuilt. > > Do we have a script for that, or is it more along the lines of "use sql.php > to delete all the rows then maintenance/updateSpecialPages.php with --only > to rebuild it"? That it. I just deleted the excess rows on enwiki manually in eval.php: $dbw=wfGetDB(DB_MASTER); $res = $dbw->query("SELECT qcc_title FROM querycachetwo WHERE qcc_type='activeusers' AND qcc_namespace = 2 GROUP BY qcc_title HAVING COUNT(*) > 1"); $titles = array(); foreach ( $res as $row ) { $titles[] = $row->qcc_title; } $dbw->delete( 'querycachetwo', array( 'qcc_type' => 'activeusers', 'qcc_title' => $titles ) ); -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
