Last modified: 2011-12-01 14:55:24 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 8224 - error code during create table on mysql 5
error code during create table on mysql 5
Status: RESOLVED DUPLICATE of bug 7669
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
PC Windows XP
: Highest blocker (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2006-12-12 02:26 UTC by sebastien bonnet
Modified: 2011-12-01 14:55 UTC (History)
1 user (show)

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


Description sebastien bonnet 2006-12-12 02:26:54 UTC
i want to install mediawiki on my pc. I have windows xp pro sp2 with IIS 5.1 and
mysql 5.0.26community
and during creating tables i have error message. i send you all informations:
# PHP 5.2.0 installed
# Found database drivers for: MySQL
# PHP server API is isapi; 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.
# Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions
cannot be used.
# GNU diff3 not found.
# Couldn't find GD library or ImageMagick; image thumbnailing disabled.
# Installation directory: C:\Inetpub\wwwroot\mediawiki
# Script URI path: /mediawiki
# Environment checked. You can install MediaWiki.
# Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider
changing it manually.

Generating configuration file...
# Database type: MySQL
# Loading class: DatabaseMysql
# Attempting to connect to database server as root...success.
# Connected to 5.0.26-community-nt
# Created database wikidb
# Creating tables... using MySQL 4 table defs...Query "CREATE TABLE `user` (
user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary
NOT NULL default '', user_real_name varchar(255) binary NOT NULL default '',
user_password tinyblob NOT NULL default '', user_newpassword tinyblob NOT NULL
default '', user_email tinytext NOT NULL default '', user_options blob NOT NULL
default '', user_touched char(14) binary NOT NULL default '', user_token
char(32) binary NOT NULL default '', user_email_authenticated char(14) binary,
user_email_token char(32) binary, user_email_token_expires char(14) binary,
user_registration char(14) binary, PRIMARY KEY user_id (user_id), UNIQUE INDEX
user_name (user_name), INDEX (user_email_token) ) TYPE=InnoDB " failed with
error code "BLOB/TEXT column 'user_password' can't have a default value (localhost)"

i don t understood. i used mysql with utf8 by default. why this installation use
MySQL 4 table defs ? can we use MySQL 5 tables defs ?

Comment 1 Brion Vibber 2006-12-12 02:29:55 UTC

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

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