https://bugzilla.wikimedia.org/show_bug.cgi?id=15152
--- Comment #12 from Roan Kattouw <[email protected]> 2009-12-12 20:48:05 UTC --- (In reply to comment #11) > It's an issue on other wikis as well. Using the Toolserver's copy of the > databases: > > mysql> SELECT c.* FROM categorylinks c > -> LEFT JOIN page ON cl_from = page_id > -> WHERE page_id IS NULL AND cl_from > 0; > > -- dewiki_p > 379 rows > > -- frwiki_p > 188 rows > > -- enwiki_p > 3842 rows > > -- ruwiki_p > 154 rows > I've used the same query (omitting cl_from > 0) to track down and delete ghost entries on dewiki, frwiki, enwiki, ruwiki and itwiki. This is not a substitute for running refreshLinks of course, but that takes a long time on such large wikis. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
