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.