Last modified: 2010-05-15 15:38:08 UTC
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()
changed title