Mailing List Archive: Wikipedia: Wikitech

Re: Illegal mix of collations after upgrade to 1.14

Index | Next | Previous | View Threaded

aran at organicdesign

Mar 11, 2009, 5:28 PM

Post #1 of 3 (1055 views)
Permalink

Re: Illegal mix of collations after upgrade to 1.14

Hi I've tried upgrading my 1.11 to 1.14 and get this "illegal mix of
collations" error. I went through the normal upgrade procedure first but
this failed, so I then tried exporting as XML and importing into a
completely fresh 1.14 install, and still I get the error!

I've found that by setting $wgDBmysql5 to false things seem to work ok,
but is this really a good solution? I'd like everything to be running up
to date, not in some backward compatibility mode... does anyone have any
idea how to fix the problem properly?

_______________________________________________
Wikitech-l mailing list
Wikitech-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Platonides at gmail

Mar 12, 2009, 8:11 AM

Post #2 of 3 (983 views)
Permalink

Re: Illegal mix of collations after upgrade to 1.14 [In reply to]

Aran wrote:
> I've found that by setting $wgDBmysql5 to false things seem to work ok,
> but is this really a good solution? I'd like everything to be running up
> to date, not in some backward compatibility mode... does anyone have any
> idea how to fix the problem properly?

It's not a backwards compatibility mode. It's just a different
configuration. In fact, Wikimedia servers are working with mysql 4.0! :)

_______________________________________________
Wikitech-l mailing list
Wikitech-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

daniel at brightbyte

Mar 12, 2009, 8:32 AM

Post #3 of 3 (959 views)
Permalink

Re: Illegal mix of collations after upgrade to 1.14 [In reply to]

Platonides schrieb:
> Aran wrote:
>> I've found that by setting $wgDBmysql5 to false things seem to work ok,
>> but is this really a good solution? I'd like everything to be running up
>> to date, not in some backward compatibility mode... does anyone have any
>> idea how to fix the problem properly?
>
> It's not a backwards compatibility mode. It's just a different
> configuration. In fact, Wikimedia servers are working with mysql 4.0! :)

Well, it *is* called compatibility mode. I suspect because it works with old
versions of mysql. In any case, the "experimental" modes should be fixed if
broken. But they *are* experimental. So it's no surpriese if they are broken.

-- daniel

_______________________________________________
Wikitech-l mailing list
Wikitech-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads