Author: wisesabre
Description:
on Windows Xp + IIS 5.1
mediawiki doesnt detects MySQL 5.0 instead it uses MySQL 4.0 script for creating
tables.
I manually changed path from config/index.php to mysql5 directory
now I am getting errors like..
Creating tables... using MySQL 4/5 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 '', user_newpassword tinyblob NOT NULL '',
user_email mediumtext NOT NULL '', user_options blob NOT NULL '', 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, DEFAULT CHARSET=utf8 " failed with error code
"You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ''', user_newpassword
tinyblob NOT NULL '', user_email mediumtext NOT NULL '', ' at line 5 (localhost)".
how to fix it?
Version: 1.8.x
Severity: normal
OS: Windows XP
Platform: PC