Author: mhillion

Description:
Hi there,
I found one during the upgrade from 1.5alpha1 to 1.5beta3 version.
The script to create the table pagelinks failed so I created the table and indexes
manually. After that the update process run without any more problems.
The only issue is that ended being a MyISAM table instead of InnoDB.
Is that something I should be worried about?

The sql file creating the table when executing upgrade.php is patch-pagelinks.sql
located at \maintenance\archives

The output of the php update.php is:

Going to run database updates for wikidb
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds... 5,4,3,2,1,0
...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.
...have ur_user field in user_rights table.
...have group_rights field in group table.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...have rc_type field in recentchanges table.
...have rc_ip field in recentchanges table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...have user_real_name field in user table.
...have user_token field in user table.
...have user_email_token field in user table.
...have user_email_authenticated field in user table.
...have user_email_token_expires field in user table.
...have user_enotif_newpages field in user table.
...have log_params field in logging table.
...have ar_rev_id field in archive table.
...have ar_text_id field in archive table.
...have page_len field in page table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have img_media_type field in image table.
...have val_ip field in validate table.
...have ss_total_pages field in site_stats table.
...have wl_notificationtimestamp field in watchlist table.
...have wl_lastvisitedrevision field in watchlist table.
...have iw_trans field in interwiki table.
...already have interwiki table
...indexes seem up to 20031107 standards
Converting links table to ID-ID...
Schema already converted
...image primary key already set.
Logging table has correct title encoding.
...page table already exists.
revision timestamp indexes already up to 2005-03-13
...rev_text_id already in place.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
Converting links and brokenlinks tables to pagelinks... A database error has occurred
Query: CREATE TABLE bcgmw_pagelinks ( pl_from int(8) unsigned NOT NULL default '0',
pl_namespace int NOT NULL default '0', pl_title varchar(255) binary NOT NULL
default '', UNIQUE KEY pl_from(pl_from,pl_namespace,pl_title), KEY
(pl_namespace,pl_title) ) TYPE=InnoDB
Function:
Error: 1005 Can't create table '.\wikidb\bcgmw_pagelinks.frm' (errno: 121) (localhost)

Backtrace:
GlobalFunctions.php line 424 calls wfbacktrace()
Database.php line 395 calls wfdebugdiebacktrace()
Database.php line 345 calls database::reportqueryerror()
install-utils.inc line 122 calls database::query()
updaters.inc line 451 calls dbsource()
updaters.inc line 634 calls do_pagelinks_update()
update.php line 30 calls do_all_updates()

Version: 1.5.x
Severity: normal