Hi list, I'm trying to install MediaWiki -1.4.3 and during installation I'm getting the following collation errors :( Logging table has correct title encoding. Initialising "MediaWiki" namespace... A database error has occurred Query: SELECT cur_title,cur_is_new,cur_user_text FROM `cur` WHERE cur_namespace=8 AND cur_title IN('1movedto2','1movedto2_redir'...'Yourvariant','Zhconversiontable') Function: Error: 1271 Illegal mix of collations for operation ' IN ' (localhost) Backtrace: GlobalFunctions.php line 507 calls wfBacktrace() Database.php line 383 calls wfDebugDieBacktrace() Database.php line 333 calls DatabaseMysql::reportQueryError() InitialiseMessages.inc line 150 calls DatabaseMysql::query() InitialiseMessages.inc line 78 calls initialiseMessagesReal() updaters.inc line 205 calls initialiseMessages() index.php line 539 calls do_all_updates() I've even gone to the measure of creating the `wikidb` manually: mysql> CREATE DATABASE wikidb DEFAULT CHARACTER SET Latin1 COLLATE Latin1_bin; and then running the install script. We are using PHP 5.0.1 and MySQL 4.0.18, any ideas would be greatly appreciated. TIA Jason __________ Jason Lane (Development) ONSPEED "Faster Internet" Direct: +44 (0)20 7952 4035 General: +44 (0)8707 585 859 Fax: +44 (0)870 705 1393 http://www.onspeed.com PLEASE NOTE ONSPEED IS NOT LIABLE FOR ANY DAMAGES, MALFUNCTION, OR LOSS OF DATA, CAUSED AS A RESULT OF FOLLOWING ADVICE ENCLOSED IN THIS EMAIL. ANY CHANGES SHOULD BE CARRIED OUT AT YOUR OWN RISK. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. The opinions expressed in this mail are those of the author and do not necessarily represent the views of the company. If you have received this email in error please notify service(a)onspeed.com.