Last modified: 2010-05-15 15:33:13 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 1896 - Illegal mix of collations for operation
Illegal mix of collations for operation
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
PC Windows XP
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2005-04-15 07:48 UTC by David Mach
Modified: 2010-05-15 15:33 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description David Mach 2005-04-15 07:48:52 UTC
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 
Installation directory: C:\Dokumenty\Projekty\localhost\mediawiki 
Script URI path: /mediawiki 
Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it 
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 
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
site','Accesskey-compareselectedversions','Accesskey-minoredit', ... 
TRUNCATED ..., 'Zhconversiontable')
Error: 1271 Illegal mix of collations for operation ' IN ' (localhost)

Database.php line 345 calls wfDebugDieBacktrace()
Database.php line 297 calls DatabaseMysql::reportQueryError() line 150 calls DatabaseMysql::query() line 78 calls initialiseMessagesReal()
index.php line 584 calls initialiseMessages()
Comment 1 Brion Vibber 2005-04-22 11:33:08 UTC
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?
Comment 2 Brion Vibber 2005-10-29 01:43:52 UTC
This should work correctly with 1.5.1, which now has support for explicit charset 
selection which should override odd local defaults. Resolving FIXED.

Note You need to log in before you can comment on or make changes to this bug.