Last modified: 2010-05-15 15:38:08 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 2778 - problem 1.5alpha1 to 1.5beta3 - Error: 1005 Can't create table '.\wikidb\bcgmw_pagelinks.frm' (errno: 121)) problem 1.5alpha1 to 1.5beta3 - Error: 1005 Can't create table '...
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2005-07-09 19:17 UTC by Martin
Modified: 2010-05-15 15:38 UTC (History)
1 user (show)

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


Description Martin 2005-07-09 19:17:56 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. 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
Error: 1005 Can't create table '.\wikidb\bcgmw_pagelinks.frm' (errno: 121) (localhost)

GlobalFunctions.php line 424 calls wfbacktrace()
Database.php line 395 calls wfdebugdiebacktrace()
Database.php line 345 calls database::reportqueryerror() line 122 calls database::query() line 451 calls dbsource() line 634 calls do_pagelinks_update()
update.php line 30 calls do_all_updates()
Comment 1 T. Gries 2005-07-09 19:44:20 UTC
changed title

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