Author: wiki.vincent

Description:
http://www.mediawiki.org/wiki/Release_notes/1.6 reports that 1.6 works fine
since MySQL 4.0, but in fact, it works since 4.1

The bug belongs to MySQL but could be removed changing ENGINE->TYPE at the
creation of the tables.

ENGINE=InnoDB -> Type=InnoDB

Here is the trace.

• PHP 4.4.2 installed
• Warning: PHP's register_globals option is enabled. Disable it if you can. MediaWiki will work, but your server is more exposed to PHP-based security

vulnerabilities.

• PHP server API is cgi; 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.
• Neither Turck MMCache nor eAccelerator are installed, can't use object

caching functions

• GNU diff3 not found.
• Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be

enabled if you enable uploads.

• Found GD graphics library built-in.
• Installation directory: /home.1/a/m/p/amplyd/www/wikiblog
• Script URI path: /~amplyd/wikiblog
• Environment checked. You can install MediaWiki.
  
  Generating configuration file...
• Database type: mysql
• PHP is linked with old MySQL client libraries. If you are using a MySQL

4.1 server and have problems connecting to the database, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.

• Attempting to connect to database server as amplyd1...success.
• Connected to 4.0.17-standard-log
• Database amplyd1 exists
• Creating tables... using MySQL 4 table defs...Query "CREATE TABLE

mw_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) ) ENGINE=InnoDB " 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 'ENGINE=InnoDB' at line 18 (sql)".

Version: 1.6.x
Severity: normal