Author: hebeldark

Description:
hello,
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:

1. PHP 5.2.0 installed
2. Found database drivers for: MySQL
3. PHP server API is isapi; using ugly URLs (index.php?title=Page_Title)
4. Have XML / Latin1-UTF-8 conversion support.
5. PHP is configured with no memory_limit.
6. Have zlib support; enabling output compression.
7. Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions

cannot be used.

1. GNU diff3 not found.
2. Couldn't find GD library or ImageMagick; image thumbnailing disabled.
3. Installation directory: C:\Inetpub\wwwroot\mediawiki
4. Script URI path: /mediawiki
5. Environment checked. You can install MediaWiki.
6. Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider

changing it manually.

Generating configuration file...

1. Database type: MySQL
2. Loading class: DatabaseMysql
3. Attempting to connect to database server as root...success.
4. Connected to 5.0.26-community-nt
5. Created database wikidb
6. 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 ?

thx

Version: 1.8.x
Severity: blocker
OS: Windows XP
Platform: PC