Hi Huib,
I wouldn't be surprised ;-)
But at which point should I have done that, and how?
Thanks for your reply!
Hans
On Wed, 8 Dec 2010 14:42:13 +0100, Huib Laurens <sterkebak(a)gmail.com>
wrote:
Hi,
I guess you forgot to change the latin into utf.
Older mediawiki versions used latin as languages in the database, new
versions use utf-8 when you didn't change it it will cause errors
like
this
2010/12/8, Hans <hans(a)antheii.nl>nl>:
> Hi,
>
> I am migrating our wiki to another server, and upgrading the
> Mediawiki
> version in the process (from 1.13.3 to 1.16.0)
>
> But at some pages I now get the following error message;
>
> --------
> A database query syntax error has occurred. This may indicate a bug
> in
> the software. The last attempted database query was:
> (SQL query hidden)
> from within function "LinkHolderArray::replaceInternal". Database
> returned error "1271: Illegal mix of collations for operation ' IN
> '
> (localhost)".
> --------
>
> I have already determined this has to do with some characters being
> in
> article titles/wiki links (the Czech 'č' for instance, see
>
>
http://wiki.scramble.nl/index.php?title=Fokker_F.XVIII&action=historysu…)oldid=14823).
> Having the same characters in the main text is not an issue
> (compare
> [[Česká Letecká Společnost|ČLS]] which doesn't work, with [[Ceská
> Letecká Spolecnost|ČLS]] which does).
> What surprised me, was that the error also occurred when I tried to
> preview this page, at which point there there is no database query
> (yet)
> I would imagine. But I may be wrong on that :-)
>
> So it seems it has something to do with the character sets used,
> but as
> my expertise on that is rather basic, I have not a clue what
> exactly.
>
> What did I do so far;
> - dumped the databases on the old server with mysqldump
> - installed MW 1.16.0 on the new server
> - imported the database dump on the new server (completely,
> dropping
> the 'newly created tables' from last step first)
> - ran the update.php script
> - uploaded the images directories (OK, this has nothing to do with
> above issue, just being complete ;-) )
> - installed the current versions of all extensions we used on the
> old
> server
>
> Could anybody tell what I did wrong, or point me to a solution? I
> would
> like being able to use those characters, as is the case on our old
> server.
>
> Thanks in advance!
>
> Regards,
>
> Hans
>
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>