Last modified: 2004-11-21 22:34:45 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 616 - Subcategories are only partially sorted (multiple "runs")
Subcategories are only partially sorted (multiple "runs")
Product: MediaWiki
Classification: Unclassified
Categories (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2004-10-01 08:46 UTC by Mormegil
Modified: 2004-11-21 22:34 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Mormegil 2004-10-01 08:46:09 UTC
On the abovementioned category page, the subcategories are sorted only partially. I.e. the list of initial letters looks like "A,B,C,D,E,F,I,A,B,E,M,N,P,S,U,V,Z,Ř,L,N,P,R,S,T,Č,Š". That is, three separate runs in the list.

Wild (!) guesses of the problem cause:
* on some pages, [[Category:Evropa]] is used, on other [[Kategorie:Evropa]].
* diacritics (Ř, Č, Š)

(Note: Our Special:Version reports 1.3.5+, which is not in the above list.)
Comment 1 Antoine "hashar" Musso (WMF) 2004-11-09 15:12:50 UTC
This is a known problem with MySQL. See bug #164.

*** This bug has been marked as a duplicate of 164 ***
Comment 2 JeLuF 2004-11-09 20:30:47 UTC
The "multiple runs" are caused by problems with the sortkeys in older revisions
of the
MediaWiki software. The DB has now been cleaned up using

  update categorylinks set cl_sortkey= substring(cl_sortkey,11) where cl_sortkey
like 'Kategorie:%';

New entries should have the correct sortkey.

The sorting of non-latin characters is indeed a mysql localization issue.
Comment 3 Mormegil 2004-11-09 20:57:51 UTC
My bugreport did not reference the MySQL sorting issue (which is known to me,
and I take it as not critical, although somewhat unpleasant). So that this bug
is indeed not a duplicate of #164.
But because JeLuF solved the problem, all is fine now. :-)
Thanks to JeLuF.
Comment 4 Byrial Jensen 2004-11-21 22:34:45 UTC
We also have this problem in several categories in the Danish Wikipedia. See
<> for an example. According to
JeLuf's comment, it can fixed by a simple database command. Who should be asked
to kindly do that?

Note You need to log in before you can comment on or make changes to this bug.