Last modified: 2012-08-14 11:27:16 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 2907 - Unspecified default charset in CREATE DATABASE can cause install to fail
Unspecified default charset in CREATE DATABASE can cause install to fail
Status: RESOLVED DUPLICATE of bug 1322
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2005-07-19 15:32 UTC by IByte
Modified: 2012-08-14 11:27 UTC (History)
1 user (show)

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


Description IByte 2005-07-19 15:32:54 UTC
= Symptoms/Reproduction =
When installing using a MySQL server that has UTF8 as default charset rather
than Latin-1, installation may fail with the following error:

MediaWiki 1.4.7 installation

Please include all of the lines below when reporting installation problems.
Checking environment...

    * PHP 5.0.4: 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:\Program Files\OmniSecure\htdocs\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.12a-nt; enabling MySQL 4 enhancements
    * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider
changing it manually.
    * Created database wikidb
    * Creating tables...Query "CREATE TABLE cnwiki1_categorylinks ( cl_from
int(8) unsigned NOT NULL default '0', cl_to varchar(255) binary NOT NULL default
'', cl_sortkey varchar(255) binary NOT NULL default '', cl_timestamp timestamp
NOT NULL, UNIQUE KEY cl_from(cl_from,cl_to), KEY
cl_sortkey(cl_to,cl_sortkey(128)), KEY cl_timestamp(cl_to,cl_timestamp) )"
failed with error code "Specified key was too long; max key length is 1024 bytes".

= Proposed patch =
Append a default charset and collation to line 509 of /config/index.php, so the
query becomes:
"CREATE DATABASE `$wgDBname` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci"

= Environment used =
OS:	Windows XP Home SP2
Server:	Omnicron OmniSecure v3.0a4
PHP:	5.0.4 (official release pre-built CGI binary)
MySQL:	4.1.12a-nt (Win32)
Comment 1 Brion Vibber 2005-07-19 17:42:37 UTC
This has been corrected with different index sizes in 1.5. (Try 1.5beta3 
to confirm it installs correctly.)
Comment 2 Zigger 2005-07-19 23:15:57 UTC

*** This bug has been marked as a duplicate of 1322 ***

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