[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Bawolff (Brian Wolff) changed: What|Removed |Added Target Milestone|1.22.0 release |Future release --- Comment #80 from Bawolff (Brian Wolff) --- Remove milestone 1.22 - Given that this has somewhat stalled due to lack of time on the part of interested parties, seems unlikely it could possibly make it to 1.22. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #79 from Quim Gil --- I'm delisting this project from https://www.mediawiki.org/wiki/Mentorship_programs/Possible_projects#Automatic_category_redirects since it looks like you are almost there. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #78 from Bawolff (Brian Wolff) --- (In reply to comment #77) > (In reply to comment #76) > > If I ever have free time again (read: probably not for a while), I offer to > > help Tyler address some of the issues with the patch. > > That would be great. I don't have much free time myself, although once I do > I'll definitely work on it. yeah, somebody should make a graph of number of commits to mediawiki by volunteers vs when school semester starts. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #77 from Tyler Romeo --- (In reply to comment #76) > If I ever have free time again (read: probably not for a while), I offer to > help Tyler address some of the issues with the patch. That would be great. I don't have much free time myself, although once I do I'll definitely work on it. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #76 from Bawolff (Brian Wolff) --- If I ever have free time again (read: probably not for a while), I offer to help Tyler address some of the issues with the patch. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #75 from Andre Klapper --- Tyler: The patch received a -1, do you plan to rework it? -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Andre Klapper changed: What|Removed |Added Keywords|patch-in-gerrit | Status|REOPENED|PATCH_TO_REVIEW -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Andre Klapper changed: What|Removed |Added Keywords|patch, patch-reviewed | -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Tyler Romeo changed: What|Removed |Added Keywords||patch-in-gerrit Assignee|wikibugs-l@lists.wikimedia. |tylerro...@gmail.com |org | Target Milestone|--- |1.22.0 release -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #74 from Gerrit Notification Bot --- Related URL: https://gerrit.wikimedia.org/r/65176 (Gerrit Change I29a629a514f9568d0ee4d967c516dfd599dc11ba) -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #73 from Quim Gil --- Just a note to say that Andre Saboia has submitted a GSoC proposal related to this report: https://www.mediawiki.org/wiki/User:Anboia/Automatic_category_redirects -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #72 from Tyler Romeo --- (In reply to comment #71) > I havent tested this, but I would guess that unless it is doing something > very > fancy with merging indecies, this would cause very large scans of the > categorylinks table. (Since it wouldn't be able to skip to only results in > the > relavent category). filesort isnt the only way that a db query can be > inefficient. Hmm, you're right. Now that I realize it, this would require scanning the entire cl_sortkey index (I think). -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #71 from Bawolff (Brian Wolff) --- I havent tested this, but I would guess that unless it is doing something very fancy with merging indecies, this would cause very large scans of the categorylinks table. (Since it wouldn't be able to skip to only results in the relavent category). filesort isnt the only way that a db query can be inefficient. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #70 from Tyler Romeo --- Success! So the issue is that the cl_sortkey index on categorylinks puts the cl_to column before the cl_sortkey column, so when you add the "cl_to IN ...", it can no longer use the index to sort by cl_sortkey (from the ORDER BY clause). After adding the following index: ALTER TABLE `categorylinks` ADD UNIQUE `cl_newsort` ( `cl_type`, `cl_sortkey`, `cl_to`, `cl_from` ) And then running the following query: EXPLAIN EXTENDED SELECT `cl_from` FROM `categorylinks` INNER JOIN `page` ON `page_id` = `cl_from` LEFT JOIN `category` ON `cat_title` = `page_title` AND `page_namespace` = 14 WHERE `cl_type` = 'page' AND `cl_to` IN ( 'Foo', 'Test' ) ORDER BY cl_sortkey I finally got no more filesort. (I was even able to get rid of the FORCE INDEX usage.) If somebody could please check this and make sure I'm still sane, and that MySQL isn't just inventing things to trick my mind, that'd be great. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #69 from Tyler Romeo --- Hmm, damn databases. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311
--- Comment #68 from Bawolff (Brian Wolff) ---
Re comment 66:
If I have more than a single category in the IN condition when doing that, I
get a filesort:
mysql> describe SELECT /* CategoryViewer::doCategoryQuery Bawolff */
page_id,page_title,page_namespace,page_len,page_is_redirect,cl_sortkey,cat_id,cat_title,cat_subcats,cat_pages,cat_files,cl_sortkey_prefix,cl_collation
FROM `page` INNER JOIN `categorylinks` FORCE INDEX (cl_sortkey) ON ((cl_from =
page_id) AND cl_to in ('Foo', 'se') and cl_type = 'page') LEFT JOIN `category`
ON ((cat_title = page_title) AND page_namespace = '14') ORDER BY cl_sortkey
LIMIT 2\G
*** 1. row ***
id: 1
select_type: SIMPLE
table: categorylinks
type: range
possible_keys: cl_sortkey
key: cl_sortkey
key_len: 258
ref: NULL
rows: 559
Extra: Using where; Using filesort
*** 2. row ***
id: 1
select_type: SIMPLE
table: page
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: wikidb.categorylinks.cl_from
rows: 1
Extra:
*** 3. row ***
id: 1
select_type: SIMPLE
table: category
type: eq_ref
possible_keys: cat_title
key: cat_title
key_len: 257
ref: wikidb.page.page_title
rows: 1
Extra:
3 rows in set (0.00 sec)
--
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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #67 from Quim Gil --- Just a note to say that Liangent has applied to GSoC with a proposal related to this report. Good luck! https://www.mediawiki.org/wiki/User:Liangent/cat-redir -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311
Tyler Romeo changed:
What|Removed |Added
CC||tylerro...@gmail.com
--- Comment #66 from Tyler Romeo ---
The more you know...
The current query for getting category members is:
SELECT ...
FROM `page`
INNER JOIN `categorylinks`
FORCE INDEX (cl_sortkey)
ON ((cl_from = page_id))
LEFT JOIN `category`
ON ((cat_title = page_title) AND page_namespace = '14')
WHERE cl_to = 'Test' AND cl_type = 'page'
ORDER BY cl_sortkey
LIMIT 201
And, true enough, if you change the cl_to check from a comparison to an IN
operator, it triggers a filesort. *However*, if you instead move the contents
of the WHERE clause into the INNER JOIN condition, then the filesort
disappears. The resulting query is:
SELECT ...
FROM `page`
INNER JOIN `categorylinks`
FORCE INDEX (cl_sortkey)
ON ((cl_from = page_id) AND (cl_to IN ('Test')) AND (cl_type = 'page'))
LEFT JOIN `category`
ON ((cat_title = page_title) AND page_namespace = '14')
ORDER BY cl_sortkey
LIMIT 201
Now I'm not too much of an expert on databases, but theoretically this should
produce the exact same results (since it's an INNER JOIN) but still be
efficient (because the cl_sortkey index includes the cl_from and cl_to
columns).
This would eliminate the need for any new columns and whatnot.
--
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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Benjamin Chen changed: What|Removed |Added CC||bencmqw...@gmail.com -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #65 from Quim Gil --- Ok, you're in: https://www.mediawiki.org/wiki/Summer_of_Code_2013#Automatic_category_redirects Thank you and good luck! -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #64 from Bawolff (Brian Wolff) --- (In reply to comment #63) > Question: > > Is there a potential mentor willing to help potential students interested in > this project? Yes me :) > > Is there a reasonable support from the MediaWiki core maintainers to > incorporate this feature if it's developed and meets the quality criteria? > I think so. Would require schema changes which is the only bit that could potentially be sticky. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Quim Gil changed: What|Removed |Added CC||q...@wikimedia.org --- Comment #63 from Quim Gil --- This feature request is being proposed at http://www.mediawiki.org/wiki/Mentorship_programs/Possible_projects#Automatic_category_redirects and I'm considering whether to add it or not to https://www.mediawiki.org/wiki/Summer_of_Code_2013#Project_ideas Question: Is there a potential mentor willing to help potential students interested in this project? Is there a reasonable support from the MediaWiki core maintainers to incorporate this feature if it's developed and meets the quality criteria? Without these qualifications in place we can't even consider the proposal for GSOC 2013. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Waldir changed: What|Removed |Added CC||wal...@email.com -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Nemo changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=5346 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Timeshifter changed: What|Removed |Added Blocks|5346| -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Meno25 changed: What|Removed |Added Version|1.17|unspecified -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Bugmeister Bot changed: What|Removed |Added Priority|Highest |Low CC|garba...@seznam.cz | -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Jan Kucera (Kozuch) changed: What|Removed |Added Priority|Low |Highest CC||garba...@seznam.cz --- Comment #63 from Jan Kucera (Kozuch) 2011-12-30 15:44:11 UTC --- Because of votes rasing importance/priority according to following scheme: 15+ votes - highest 5-15 votes - high Community must have a voice within development. Regards, Kozuch http://en.wikipedia.org/wiki/User:Kozuch -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Bug 3311 depends on bug 167, which changed state. Bug 167 Summary: Use a dedicated interface for adding interwiki/category links, not wikitext https://bugzilla.wikimedia.org/show_bug.cgi?id=167 What|Old Value |New Value Status|RESOLVED|REOPENED Resolution|FIXED | -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Bug 3311 depends on bug 167, which changed state. Bug 167 Summary: Use a dedicated interface for adding interwiki/category links, not wikitext https://bugzilla.wikimedia.org/show_bug.cgi?id=167 What|Old Value |New Value Status|REOPENED|RESOLVED Resolution||FIXED -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Sumana Harihareswara changed: What|Removed |Added Keywords||performance, reviewed CC||suma...@panix.com --- Comment #62 from Sumana Harihareswara 2011-11-09 04:15:15 UTC --- Adding the keywords that seem right -- if the patches still need reviewing, please change "reviewed" to "need-review". -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Bawolff changed: What|Removed |Added CC||lamb...@orange.fr --- Comment #61 from Bawolff 2011-11-08 21:13:23 UTC --- *** Bug 32262 has been marked as a duplicate of this 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. 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #59 from jida...@jidanni.org 2010-04-01 04:40:51 UTC --- (In reply to comment #58) > visit Category:1&redirect=no ! I meant Category;C1&redirect=no. The redirect=no part is not something the average user will know to try. So the category entry is effectively lost in this sense. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 jida...@jidanni.org changed: What|Removed |Added Version|unspecified |1.17-svn --- Comment #58 from jida...@jidanni.org 2010-04-01 04:38:15 UTC --- Sorry my following observation is probably noted above, but I didn't check. On [[Page A]] put "[[Category:C1]]". Now on [[Category:C1]] put "#REDIRECT [[Category:C2]]". Note how Page A is not listed on Category:C2. Instead the only way to hunt down Page A in the categories is to visit Category:1&redirect=no ! -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #57 from Le Chat 2009-11-17 12:34:08 UTC --- Hello, is anyone still working on this? Any progress lately? It all seemed to be going so well at one point... -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Russell Blau changed: What|Removed |Added Blocks||17571 -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #56 from ipatrol 2009-07-11 21:37:34 UTC --- I think that the best solution is you place [[A]] into [[Category:Foo]] and Foo redirects to Bar so you see [[A]] in [[Category:Bar]] and clicking on the catlink to Foo leads you to Bar. For commons they can have "co-categories" where a member of one co-category is visible in all other co-categories. This can be done by having all the categories have [[;Category:Fu]] [[;Category:Fuz]] [[;Category:Faz]] [[;Category:(...)]] -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311
--- Comment #55 from Aryeh Gregor 2009-05-24
13:56:46 UTC ---
cl_to_original or such, an unredirected variant of cl_to. Then if a redirect
chain changes, you could do UPDATE categorylinks SET
cl_to='New_redirect_target' WHERE cl_to_original IN ('Original_category1',
'Original_category2');. You'd want an index on cl_to_original, of course, so
this is a pretty heavyweight addition to the table.
--
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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #54 from Platonides 2009-05-22 22:55:58 UTC --- That's probably the way to go. What would be that column? -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #53 from Aryeh Gregor 2009-05-22 19:19:18 UTC --- Or adding an extra column to categorylinks. That seems like a better idea, unless un-redirecting is expected to be very rare. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #52 from Platonides 2009-05-22 18:02:37 UTC --- Making a "normal" Category a category can be done straight away, but unredirecting a category requires reparsing all category members. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #51 from Aryeh Gregor 2009-05-19 14:09:09 UTC --- Templates with categories don't cause immediate updates because those updates require reparsing of large numbers of pages. Category redirects don't, I don't see any reason why they should need the job queue. Except for really giant categories, maybe, where you'd want to batch the updates to not lag the slaves. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #50 from Roan Kattouw 2009-05-19 13:49:18 UTC --- (In reply to comment #49) > I don't think it was ever envisaged that the tables would be updated > automatically (I didn't think that was desirable anyway, since inappropriate > redirects of large categories, and subsequent reversions, would cause lots of > extra processing, of the sort that doesn't seem to happen when e.g. templates > with categories get updated). But if you say it can be done, then we'll wait > in > eager anticipation... > Templates with categories don't cause immediate updates because those updates are put in the job queue and executed later. Presumably, updating for category redirect changes would also use the job queue. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #49 from Le Chat 2009-05-19 12:34:36 UTC --- I don't think it was ever envisaged that the tables would be updated automatically (I didn't think that was desirable anyway, since inappropriate redirects of large categories, and subsequent reversions, would cause lots of extra processing, of the sort that doesn't seem to happen when e.g. templates with categories get updated). But if you say it can be done, then we'll wait in eager anticipation... -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #48 from Tim Starling 2009-05-19 11:47:17 UTC --- (In reply to comment #47) > Why has this potentially helpful change been reverted? It seemed to be working > well; the only problem was bug 17571, which surely can't be difficult to fix. > We know that the tables don't get updated straight away when a category is > changed to/from a redirect, and I presume we wouldn't want them to. Bots would > handle emptying existing categories when they get redirected, exactly as they > do now. The tables indeed were not updated straight away, in fact they were not updated at all, ever. You'd have to have a bot go through and edit every page in the category, every time the redirect status or redirect target changed. It's possible to do these updates immediately, with negligible performance loss, and to retire the bots. But it would be much more difficult to implement that feature if the categorylinks table was significantly polluted with spurious links from r46706. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #47 from Le Chat 2009-05-19 09:50:26 UTC --- Why has this potentially helpful change been reverted? It seemed to be working well; the only problem was bug 17571, which surely can't be difficult to fix. We know that the tables don't get updated straight away when a category is changed to/from a redirect, and I presume we wouldn't want them to. Bots would handle emptying existing categories when they get redirected, exactly as they do now. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Tim Starling changed: What|Removed |Added CC||tstarl...@wikimedia.org Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #46 from Tim Starling 2009-05-19 08:06:31 UTC --- Reverted, see CodeReview r46706. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 ipatrol changed: What|Removed |Added CC||ipatrol6...@yahoo.com --- Comment #45 from ipatrol 2009-04-03 22:10:44 UTC --- It has been decided that the change will be made in the next mediawiki full release ( http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/RELEASE-NOTES?view=markup ) , so just be patient.☺ -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #44 from Le Chat 2009-02-19 17:01:25 UTC --- OK, it is live, thanks. There still seems to be a slight problem, though, in that you can't get a list of members of the redirected category specifically. I've raised this in a new bug (bug:17571). -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #43 from Le Chat 2009-02-18 15:01:37 UTC --- Don't like to sound impatient, but when can we expect this fix to actually come live? -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #42 from Le Chat 2009-02-12 12:47:45 UTC --- I'm glad this is going to be solved soon, but there is the problem of potential exploitation by vandals. I've filed a new bug (bug 17461) to address this. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Platonides changed: What|Removed |Added CC||platoni...@gmail.com Status|REOPENED|RESOLVED Resolution||FIXED --- Comment #41 from Platonides 2009-02-07 17:05:40 UTC --- Wikipedia is still on r46424, see Special:Version. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Le Chat changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #40 from Le Chat 2009-02-07 17:02:04 UTC --- This seems not to be working (at least, I just tried it on English Wikipedia and it didn't work - I don't know if it's supposed to be live there yet). -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Philip Tzou changed: What|Removed |Added CC||philip@gmail.com Status|NEW |RESOLVED Resolution||FIXED --- Comment #39 from Philip Tzou 2009-02-03 02:27:34 UTC --- may fixed in r46706. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 Aryeh Gregor changed: What|Removed |Added CC||simetrical+wikib...@gmail.co ||m --- Comment #38 from Aryeh Gregor 2008-12-13 23:10:36 UTC --- (In reply to comment #37) > I didn't find a "vote" > feature, as the Mozilla db has. Bottom right, "Vote for this bug" (Ctrl-F for "vote" would have found it). > I don't understand the difference > to bug 710, which is supposedly fixed. Bug 710 is about redirects to a category working when you navigate directly to the page, the same way they work for other pages. Prior to that bug's resolution, I guess "#REDIRECT [[:Category:XYZ]]" would do nothing, or be buggy or something (it was before my time). This is about redirects actually including one category's contents in another. -- 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 3311] Automatic category redirects
https://bugzilla.wikimedia.org/show_bug.cgi?id=3311 --- Comment #37 from Sebastian Helm 2008-12-13 21:42:28 UTC --- Just came here from http://en.wikipedia.org/wiki/Wikipedia_talk:Categories_for_discussion#Category_redirects and wanted to add a vote for this bug. Disclaimer: It's a long time that I last was here, and I didn't find a "vote" feature, as the Mozilla db has. Also, I didn't spend much time to understand the discussion of this and related bugs, and I don't understand the difference to bug 710, which is supposedly fixed. -- 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
