[Mediawiki-l] Error in numRows(): Illegal mix of collations

admin Yellowikis yellowikis at gmail.com
Mon Feb 6 11:45:25 UTC 2006

It works fine for us - we have MW running in English with pages in
Japanese, Chinese and Korean. No problems from users and/or editors in
these languages either.
We are on:
    *  MediaWiki: 1.5.5
    * PHP: 4.3.10-16 (apache)
    * MySQL: 4.1.11-Debian_4sarge2-log


On 2/6/06, muyuubyou <muyuubyou at gmail.com> wrote:
> In such case, either the chinese and japanese versions at wikipedia aren't
> using mySQL4, or they're not using only the default installer. Out of the
> box, it doesn't work. Plain and simple. I can know point you to several
> sites having this same problem and I reckon some of them have just jumped to
> alternative wiki packages.
> I'm sure it works out of the box for latin_1 compatible languages (i.e. most
> other than asian languages and a couple exotic others). But this may not be
> enough.
> Google tells me you are one of the programmers, so I kindly ask you to give
> this a look. I would do it myself, but I'm new to mediawiki and it would be
> best if someone with deep understanding of its code and dependencies did it.
> Of course when you have the time.
> I have another little issue: firefox doesn't post chinese/japanese/korean
> name titles properly (mangles encoding) while Opera and IE does. I haven't
> tried mac versions because the woman has the mac on a trip, but opera for
> linux works too. Realistically (and sadly), most visitors will be using IE,
> so maybe it's not too bad. Maybe there are people dedicated to i18n and
> testing? Not sure what this is, but I might research it myself if there
> isn't a known fix somewhere I don't know. For now, I'm just adding pages
> with a compatible browser and mozilla users will be limited to browsing and
> editing for now. Not that the site is public yet, we're just two people
> using it now... it will be under testing for a week or so.
> Please understand the not-so-polite (but also not too rude) tone in my
> previous email, I was very frustrated... I expected to use that time adding
> content instead. During weekdays I'll too darned busy :(
> On 2/5/06, Brion Vibber <brion at pobox.com> wrote:
> >
> > muyuubyou wrote:
> > > Please somebody, warn about mySQL4 being not properly tested in bold
> > font in
> > > the requirements section.
> >
> > We've used MySQL 4 in production for years.
> >
> > -- brion vibber (brion @ pobox.com)
> >
> >
> >
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l at Wikimedia.org
> > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> >
> >
> >
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica

More information about the MediaWiki-l mailing list