Last modified: 2007-08-08 17:25:56 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 10771 - Every category page doesn't sort article Bulgarian (cyrillic) names correctly
Every category page doesn't sort article Bulgarian (cyrillic) names correctly
Status: RESOLVED DUPLICATE of bug 164
Product: MediaWiki
Classification: Unclassified
Categories (Other open bugs)
PC All
: High major (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2007-08-02 00:35 UTC by nav
Modified: 2007-08-08 17:25 UTC (History)
0 users

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


Description nav 2007-08-02 00:35:01 UTC

I've set Bulgarian language as default. When I open some category page, the articles are not sorted correctly at all. The Special:Categories page too.

The current order is: АНСУХЩМПИЖЗБГД  (only those letters have articles at the moment)

But it should be: АбвГДеЖЗИйклМНоПрСтУфХцчшЩъьюя    (low case letters are those for which there is NOT any article at the moment)

My DB is utf8 (charset, collation)

I've noticed  that mw_categorylinks.cl_sortkey has collation utf8_bin and changed it to utf8_general_ci, but nothing changed

Here are the sql queries for Category:Статии page (Статии = „Articles“)

SET /* Database::open */ sql_mode = ''
/* Article::pageData */ SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `mw_page` WHERE page_namespace = '14' AND page_title = 'Статии' LIMIT 1

SELECT /* Title::loadRestrictions */ * FROM `mw_page_restrictions` WHERE pr_page = '33'
/* Title::loadRestrictionsFromRow */ SELECT page_restrictions FROM `mw_page` WHERE page_id = '33' LIMIT 1

SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM `mw_objectcache` WHERE keyname='some_db-mw_:pcache:idhash:33-0!1!0!!bg!2!edit=0'

SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM `mw_objectcache` WHERE keyname='some_db-mw_:messages-hash'

SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM `mw_objectcache` WHERE keyname='some_db-mw_:messages'

UPDATE /* */ `mw_page` SET page_counter = page_counter + 1 WHERE page_id = 33
/* CategoryViewer::doCategoryQuery */ SELECT page_title,page_namespace,page_len,page_is_redirect,cl_sortkey FROM `mw_page`,`mw_categorylinks` FORCE INDEX (cl_sortkey) WHERE (1 = 1) AND (cl_from = page_id) AND cl_to = 'Статии' ORDER BY cl_sortkey LIMIT 201
/* SiteStatsUpdate::doUpdate */ SELECT * FROM `mw_site_stats` LIMIT 1

/* SiteStatsUpdate::doUpdate */ UPDATE `mw_site_stats` SET ss_total_views=ss_total_views+1 LIMIT 1
/* Job::pop */ SELECT * FROM `mw_job` WHERE job_id >= 0 ORDER BY job_id LIMIT 1
SELECT /* LinkBatch::doQuery */ page_id, page_namespace, page_title FROM `mw_page` WHERE (page_namespace=2 AND page_title='') OR (page_namespace=3 AND page_title='') OR (page_namespace=15 AND page_title='Статии')
/* User::checkNewtalk */ SELECT user_ip FROM `mw_user_newtalk` WHERE user_ip = '' LIMIT 1

If there is some way to correct this please tell me.

Thank you
Comment 1 nav 2007-08-02 11:50:59 UTC
PHP 5.x
MySQL 5.0.41-community-nt / XP
but also tested it on Linux Debian mySQL 5

Perhaps every language could define in the language class some order which could be then updated in the DB? 
This way different letter orders could be applied as the customer wants.
Comment 2 Brion Vibber 2007-08-08 17:25:56 UTC

*** This bug has been marked as a duplicate of bug 164 ***

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