Project:Support desk/Sections/Database

__NEWSECTIONLINK__ = MediaWiki Database Support =

Wiki Encoding Problem

 * MediaWiki: 1.11.0
 * PHP: 5.2.3 (cgi-fcgi)
 * MySQL: 5.0.37-community-nt
 * URL: http://wiki.myelectrical.com/

I have had a wiki up and running for a year or so without problems. Recently I have just moved to Dubai and when I first tried the wiki here I received the following error (on some pages only):

''Content Encoding Error (content_encoding_error) Server response could not be decoded using encoding type returned by server. This is typically caused by a Web Site presenting a content encoding header of one type, and then encoding the data differently. For assistance, contact your network support team.''

The wiki was fully functional before I arrived in Dubai (and may still be in other countries). After further investigation I found that the wiki is functional except for certain pages:

http://wiki.myelectrical.com

http://wiki.myelectrical.com/index.php

http://wiki.myelectrical.com/index.php?title=Special:Random

http://wiki.myelectrical.com/index.php?search=iec

etc.

Example working pages are:

http://wiki.myelectrical.com/index.php?title=Main_Page

http://wiki.myelectrical.com/index.php?title=Special:Recentchanges

http://wiki.myelectrical.com/index.php?title=CT_Dimensioning

... most article pages seem to be working

http://wiki.myelectrical.com/index.php?xx (where xx can be a lot of things)

etc.

I've tried quite a lot of things to resolve this without success. Any suggestions/help would be much appreciated.

—62.140.211.130 06:55, 6 February 2008 (UTC)


 * The non-working pages are now working. -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  21:09, 27 February 2008 (UTC)

Peter, the pages are only working in some countries (for example I know they are working in the US). I'm here in the UAE and they are still not working. It appears to be pages that redirect to other pages that do not work (wiki.myelectrical.com and special:random for example). Other mediawiki sites work here in the UAE and I have used the same notebook here and in the US (so firewalls/IE settings would not appear the be the problem).


 * Huh... didn't get that part ok. First of all could you sign your posts with ? My geography knowledge is... well... horrible, so does where ever you are use Latin characters in their language? -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  21:07, 28 February 2008 (UTC)

Sorting of category page

 * MediaWiki: 1.11.0
 * PHP: 5.1.4 (apache2handler)
 * MySQL: 5.0.21-community-nt

On a Category:XX page of my wiki I see page links grouped by first letter, that is OK, but groups themselves (letters) are arranged in random order (page names are non-english!), is it possible to alphabetize them?

—Konstbel 16:55, 7 February 2008 (UTC)


 * The order is imposed by the database, and the order is probably not "random", but byte-wise, instead of alphabetically. You may get better results when using the "experimental utf8" veriation of the database setup, instead of "compatibility mode". This is an option diring installation, i have no idea how to change it later. Also note that "experimental utf8" mode relies on mysql's own utf8 support, which is incomplete. It may work better than "compatibe" (binary) mode for your language, but as soon as you use a character from some ''very' odd language (like, for example, gothic), it will not work at all, producing a fatal error.
 * Sadly, I don't know a good way out of this dilemma, short of waiting for real unicode support in mysql. -- Duesentrieb ⇌ 10:09, 8 February 2008 (UTC)


 * I looked at wiki database, and noticed, that most varchar fields have utf8_bin comparison instead of utf8_general_ci. Is this the reason? I tried to change to utf8_general_ci, but without visible effect :-( --Konstbel 15:13, 12 February 2008 (UTC)


 * Is your Wiki set to the language that you are writing in? And can you give a URL? -PatPeter, [[Image:Tournesol.png|20px]] MediaWiki Support Team  23:29, 28 February 2008 (UTC)

Incorrect UTF-8 chars conversion

 * MediaWiki: 1.11.0
 * PHP: 5.1.4 (apache2handler)
 * MySQL: 5.0.21-community-nt

I suppose, that UTF-8 chars converted to lower/uppercase incorrectly. It makes a really HUGE problems in wiki: the search does not find what I'm looking for, the categories sorted incorrectly (see problem above), the Extension:SearchLog also displays incorrect characters (also see problem above).

Is it possible to fix that?

—Konstbel 10:12, 14 February 2008 (UTC)


 * Searching and sorting are done by the database, and per default, mediawiki tells mysql to treat all data as binary. The reason is that mysql's utf-8 support is broken for some "rare" scripts (those using 4-byte codes), like gothic. You can specify "experimental utf-8 mode" during installation, then unicode collation should apply correctly (but you will get database errors when you try to use "unsupported" characters). I don't know how this can be changed after the wiki has already been installed. I suppose you would have to change the charset/collations on all tables manually. -- Duesentrieb ⇌ 11:54, 14 February 2008 (UTC)


 * Do I need to convert only database or I need also some modifications in wiki code? --Konstbel 09:32, 15 February 2008 (UTC)