https://bugzilla.wikimedia.org/show_bug.cgi?id=44326
Web browser: ---
Bug ID: 44326
Summary: categorymembers sortkey in the api contains gibberish
Product: MediaWiki
Version: 1.21-git
Hardware: All
URL: https://commons.wikimedia.org/w/api.php?action=query&l
ist=categorymembers&cmtitle=Category:Windmills_in_the_
Netherlands&cmprop=title|ids|sortkey|timestamp
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: API
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: maar...@mdammers.nl
CC: an...@molens.org, bjor...@wikimedia.org,
bryan.tongm...@gmail.com, roan.katt...@gmail.com,
s...@reedyboy.net, wikibugs-l@lists.wikimedia.org
Classification: Unclassified
Mobile Platform: ---
Output from the api:
<?xml version="1.0"?>
<api>
<query>
<categorymembers>
<cm pageid="6221951" ns="14" title="Category:Windmills in the Netherlands
by century"
sortkey="2043454e545552590a57494e444d494c4c5320494e20544845204e45544845524c414e44532042592043454e54555259"
timestamp="2009-03-13T16:44:53Z" />
<cm pageid="17450828" ns="14" title="Category:Demolished windmills in the
Netherlands"
sortkey="2044454d4f4c49534845442057494e444d494c4c530a44454d4f4c49534845442057494e444d494c4c5320494e20544845204e45544845524c414e4453"
timestamp="2011-11-23T04:14:02Z" />
<cm pageid="6185506" ns="14" title="Category:Windmills in the Netherlands
by type"
sortkey="20545950450a57494e444d494c4c5320494e20544845204e45544845524c414e44532042592054595045"
timestamp="2009-03-09T20:38:57Z" />
<cm pageid="2631136" ns="14" title="Category:Windmills in Drenthe"
sortkey="4452454e5448450a57494e444d494c4c5320494e204452454e544845"
timestamp="2009-02-06T12:12:46Z" />
<cm pageid="2647481" ns="14" title="Category:Windmills in Friesland"
sortkey="46524945534c414e440a57494e444d494c4c5320494e2046524945534c414e44"
timestamp="2009-02-06T12:13:41Z" />
<cm pageid="2647401" ns="14" title="Category:Windmills in Gelderland"
sortkey="47454c4445524c414e440a57494e444d494c4c5320494e2047454c4445524c414e44"
timestamp="2009-02-06T12:13:59Z" />
<cm pageid="5982816" ns="14" title="Category:Windmills in Groningen
(province)"
sortkey="47524f4e494e47454e0a57494e444d494c4c5320494e2047524f4e494e47454e202850524f56494e434529"
timestamp="2009-02-18T07:51:37Z" />
<cm pageid="7748299" ns="14" title="Category:Windmills in Limburg
(Netherlands)"
sortkey="4c494d4255524720284e45544845524c414e4453290a57494e444d494c4c5320494e204c494d4255524720284e45544845524c414e445329"
timestamp="2009-09-06T16:52:00Z" />
<cm pageid="2630802" ns="14" title="Category:Windmills in North Brabant"
sortkey="4e4f5254482042524142414e540a57494e444d494c4c5320494e204e4f5254482042524142414e54"
timestamp="2009-02-06T12:14:57Z" />
<cm pageid="2632000" ns="14" title="Category:Windmills in North Holland"
sortkey="4e4f52544820484f4c4c414e440a57494e444d494c4c5320494e204e4f52544820484f4c4c414e44"
timestamp="2009-02-06T12:15:19Z" />
</categorymembers>
</query>
<query-continue>
<categorymembers
cmcontinue="subcat|4f564552494a5353454c0a57494e444d494c4c5320494e204f564552494a5353454c|2647489"
/>
</query-continue>
</api>
Expected:
mysql> SELECT cl_sortkey_prefix FROM categorylinks WHERE
cl_to='Windmills_in_the_Netherlands' LIMIT 10;
+-----------------------+
| cl_sortkey_prefix |
+-----------------------+
| Century |
| Demolished windmills |
| Type |
| Drenthe |
| Friesland |
| Gelderland |
| Groningen |
| Limburg (Netherlands) |
| North Brabant |
| North Holland |
+-----------------------+
10 rows in set (0.00 sec)
I know this used to work because my intersection bot uses this information to
sort out some categories. This is now broken.
--
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
