[Mediawiki-l] Illegal mix of collations error

Platonides Platonides at gmail.com
Mon Sep 29 21:54:32 UTC 2008


AUSTIN RICHARD JEREM wrote:
> 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 "Database::safeQuery".
> MySQL returned error "1267:
> Illegal mix of collations (latin1_bin,IMPLICIT) and
> (utf8_general_ci,COERCIBLE) for operation '=' (localhost)".

You have one table in latin1_bin and another in utf8_general_ci. Then 
mediawiki tries to compare them. Perhaps there's a problem in the 
install script.
I'm sure a case like this was broght before on this list.




More information about the MediaWiki-l mailing list