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 > -- Verzonden vanaf mijn mobiele apparaat Regards, Huib "Abigor" Laurens Support Free Knowledge: http://wikimediafoundation.org/wiki/Donate _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
