[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Nemo_bis changed: What|Removed |Added Status|NEW |RESOLVED CC||federicol...@tiscali.it Resolution||DUPLICATE --- Comment #16 from Nemo_bis 2012-01-27 10:30:12 UTC --- *** This bug has been marked as a duplicate of bug 16112 *** -- 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. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Beta16 changed: What|Removed |Added CC||l.rabinelli+bugzilla@gmail. ||com --- Comment #15 from Beta16 2012-01-18 12:03:58 UTC --- Yes. For example in "Category:Biografie" is still present a ghost element. From the dump of 2012-01-09 in categorylinks table I found this entry: (2447501,'Biografie','Stoermer ,Mark August','2010-01-27 19:15:42','','','page') but that page has been deleted. Please run refreshLinks.php on all wikies periodically. -- 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. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 p858snake changed: What|Removed |Added Blocks||16660 -- 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. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Diederik van Liere changed: What|Removed |Added CC||dvanli...@gmail.com --- Comment #14 from Diederik van Liere 2011-12-07 00:10:54 UTC --- Is this still an issue? -- 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. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Dan Collins changed: What|Removed |Added CC||en.wp.s...@gmail.com Component|Special pages |Site requests AssignedTo|roan.katt...@gmail.com |wikibugs-l@lists.wikimedia. ||org Product|MediaWiki |Wikimedia --- Comment #13 from Dan Collins 2011-07-09 01:59:47 UTC --- Since the solution to this bug appears to be running a maintenance script, I'm changing this from MediaWiki->Special Pages to Wikimedia->Site Requests. -- 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. You are the assignee for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 --- Comment #12 from Roan Kattouw 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 --- Comment #11 from MZMcBride 2009-12-12 16:39:42 UTC --- 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 -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Roan Kattouw changed: What|Removed |Added CC||roan.katt...@gmail.com AssignedTo|rhals...@wikimedia.org |roan.katt...@gmail.com --- Comment #10 from Roan Kattouw 2009-12-12 16:15:06 UTC --- Looks like we want refreshLinks to be run on itwiki and enwiki. I will consult with the ops folks on Monday and run the script then if there are no objections from them. Even though refreshLinks is supposed to be safe now, I'd rather not run it against such large wikis on a Saturday. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 MZMcBride changed: What|Removed |Added CC||pub...@mzmcbride.com --- Comment #9 from MZMcBride 2009-12-12 16:10:53 UTC --- Looks like Roan resolved bug 12168. This is still an issue on a lot of wikis. It may make sense to run the refresh script on all of them. If not, I'd like to add en.wiki to this request (or maybe I should file a new bug?). -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 --- Comment #8 from Francesco 2009-09-06 17:14:20 UTC --- There are other ghost categories: # Biografia (2 elementi) # Componenti elettronici (1 elemento) # Sovrani greci (1 elemento) # Campionato di calcio italiano (1 elemento) # Template condizionali (1 elemento) # Album dei Doors (1 elemento) # Specie (uccelli) (1 elemento) -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 15152] Ghost categories in wanted categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=15152 Brion Vibber changed: What|Removed |Added CC||br...@wikimedia.org AssignedTo|has...@free.fr |rhals...@wikimedia.org --- Comment #7 from Brion Vibber 2009-05-28 20:56:26 UTC --- Note that the deletion of ghost entries in refreshLinks.php is now batched and replication-friendly. Possibly merge this issue with bug 12168? -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
