Author: Ben_Allen
Description:
Hello
I am installing MediaWiki 1.6.6 (not yet an option in the version picklist) on
WindowsXP using Apache 2.2.2, PHP 5.2, and MySQL 5.0.21
When the wiki tries to install, I get the following:
- PHP 5.2.0-dev installed
- PHP server API is apache2handler; ok, using pretty URLs (index.php/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.
- Couldn't find GD library or ImageMagick; image thumbnailing disabled.
- Installation directory: D:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\wiki
- Script URI path: /wiki
- 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 * Attempting to connect to database server as wikiuser...success. * Connected to 5.0.21-community-nt * Database wikidb exists * 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 "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 '' at
line 1 (localhost)".
It appears that even though the install recognized the MySQL 5 server, it tries
to use MySQL4 command syntax. Manually running that query through the MySQL
Queryt Browser application returned an error indicating that the
"TYPE=database_type" syntax was deprecated and should be changed to
"ENGINE=database_type". I made that change to the command and the Query Browser
app was able to run it sucessfully.
While that change fixes the one error, perhaps this might be an indicator of a
larger problem? The installer noticed that I was using MySQL5 but used MySQL4
syntax instead. Is this something that I can change (or find a list of the SQL
commands run and create all the tables manually)? Thank you!
Version: unspecified
Severity: normal
URL: http://bugs.mysql.com/bug.php?id=17501