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 <[email protected]> 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 <[email protected]>: >> 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=historysubmit&diff=21561&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 >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
