Page MenuHomePhabricator

Illegal mix of collations for operation
Closed, ResolvedPublic

Description

Author: david.mach

Description:
During installation is the installation script stopped due this error:

Checking environment...
PHP 5.0.3: ok
PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title)
Have XML / Latin1-UTF-8 conversion support.
PHP is configured with no memory_limit.
Have zlib support; enabling output compression.
Turck MMCache not installed, can't use object caching functions
Found GD graphics library built-in, image thumbnailing will be enabled if you enable
uploads.
Installation directory: C:\Dokumenty\Projekty\localhost\mediawiki
Script URI path: /mediawiki
Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it
manually.
Connected as root (automatic)
Connected to database... 4.1.9-nt; enabling MySQL 4 enhancements
Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it
manually.
Created database mediawiki
Creating tables... done.
Initializing data...
Granting user permissions...
Created sysop account WikiAdmin.
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','Monobook.css','Monobook.js','About','Aboutpage','About
site','Accesskey-compareselectedversions','Accesskey-minoredit', ...
TRUNCATED ..., 'Zhconversiontable')
Function:
Error: 1271 Illegal mix of collations for operation ' IN ' (localhost)

Backtrace:
Database.php line 345 calls wfDebugDieBacktrace()
Database.php line 297 calls DatabaseMysql::reportQueryError()
InitialiseMessages.inc line 150 calls DatabaseMysql::query()
InitialiseMessages.inc line 78 calls initialiseMessagesReal()
index.php line 584 calls initialiseMessages()


Version: 1.4.x
Severity: normal
OS: Windows XP
Platform: PC

Details

Reference
bz1896

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:18 PM
bzimport set Reference to bz1896.
bzimport added a subscriber: Unknown Object (MLST).

Removing blocker tag as this seems to be a rare condition and does not prevent
general release.

Can you check what the collation settings are?

This should work correctly with 1.5.1, which now has support for explicit charset
selection which should override odd local defaults. Resolving FIXED.