Last modified: 2011-03-13 18:05:38 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 5796 - upgrade from 1.5.8 fails on externallinks table creation
upgrade from 1.5.8 fails on externallinks table creation
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
PC Linux
: Lowest normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2006-05-02 18:53 UTC by Paweł Widera
Modified: 2011-03-13 18:05 UTC (History)
0 users

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


Description Paweł Widera 2006-05-02 18:53:32 UTC
1.5.8 -> 1.6.3 upgrade fails (clean ungzipped, running web installer).
Using PHP 4.3.9 and mysql 4.0.13.

* There are already MediaWiki tables in this database. Checking if updates are
...hitcounter table already exists.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...logging table already exists.
...validate table already exists.
...user_newtalk table already exists.
...transcache table already exists.
...trackbacks table already exists.
Creating externallinks table...Query "CREATE TABLE `externallinks` (
 el_from int(8) unsigned NOT NULL default '0',
 el_to blob NOT NULL default '',
 el_index blob NOT NULL default '',
 KEY (el_from, el_to(40)),
 KEY (el_to(60), el_from),
 KEY (el_index(60))
 ) TYPE=InnoDB
" failed with error code "BLOB column 'el_to' can't be used in key specification
with the used table type (xxx)".
Comment 1 Antoine "hashar" Musso (WMF) 2006-05-02 19:07:32 UTC
BLOB and TEXT indexes for InnoDB tables have been added
in mysql 4.0.14 (18 july 2003).

You should upgrade mysql to at least 4.0.14.

References: (paragraph 4) (paragraph 3)

I am adding a note in 1.6 release notes ( r14027 )
Comment 2 Antoine "hashar" Musso (WMF) 2006-05-02 19:10:08 UTC
Forported in trunk ( r14028 )

Thanks for the bug report.
Comment 3 Brian 2006-12-28 15:48:02 UTC
I ran into the exact same issue, but I had Msql 5.0.27 installed.  The 
solution in my case was to run Mysql in 'non-strict table' mode.

Here is a link described the solution: (look at update #3)

"This is a result of MySQL running in "strict" mode. See for details. 
Basically, you need to remove STRICT_TRANS_TABLES from sql_mode variable. 
You can do that in your overall configuration file, when you start mysql, or 
per session by executing SET SQL_MODE = '' (you may add any attributes you 
actually need, see above link.)

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