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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T2616, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 616 - Subcategories are only partially sorted (multiple "runs")
Subcategories are only partially sorted (multiple "runs")
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Categories (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://cs.wikipedia.org/wiki/Kategori...
:
Depends on:
Blocks:
  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: ---


Attachments

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
<http://da.wikipedia.org/wiki/Kategori:Danskere> 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.


Navigation
Links