Last modified: 2010-05-15 15:56:55 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 5508 - 1.6 doesn't work with MySQL 4.0
1.6 doesn't work with MySQL 4.0
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
All All
: Normal normal with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
: testme
Depends on:
  Show dependency treegraph
Reported: 2006-04-08 20:19 UTC by Plyd
Modified: 2010-05-15 15:56 UTC (History)
0 users

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


Description Plyd 2006-04-08 20:19:09 UTC 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
    * 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 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)".
Comment 1 Brion Vibber 2006-04-08 20:55:18 UTC
ENGINE=InnoDB works fine with 4.0.24.
Comment 2 Brion Vibber 2006-04-10 22:19:41 UTC
Use 4.0.19 or later or get current REL1_6 branch from SVN or wait for 
1.6.3 or replace the ENGINE= with TYPE= manually.
Comment 3 Rob Church 2006-04-11 00:49:43 UTC
Fixed in SVN HEAD and backported to REL1_6, r13563. Will be fixed in 1.6.3.
Comment 4 Joseph Lee 2006-04-21 00:08:26 UTC
Changing ENGINE->TYPE breaks updating to 1.6.3 from 1.5.8 using MySQL 5.1.7 when
creating the new 1.6.x tables.

Creating templatelinks table...
Query "CREATE TABLE `tt_templatelinks` (
 tl_from int(8) unsigned NOT NULL default '0',
 tl_namespace int NOT NULL default '0',
 tl_title varchar(255) binary NOT NULL default '',
 UNIQUE KEY tl_from(tl_from,tl_namespace,tl_title),
 KEY (tl_namespace,tl_title)
 ) 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
'TYPE=InnoDB' at line 7 (localhost)".

The solution is to manually create these tables with TYPE->ENGINE instead.
Comment 5 Antoine "hashar" Musso (WMF) 2006-06-09 20:39:25 UTC
See also bug 6085 :
 TYPE= will generate fatal error in MySQL 5.2

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