Last modified: 2014-11-12 03:15:07 UTC
While testing 1.23.0-rc.1 I discovered that all the DB updates aren't run. I ran update.php and saw the following differences. These should all be taken care of during the inital installation: --- update1 2014-05-12 12:46:04.788237142 -0400 +++ update3 2014-05-12 12:47:22.608297003 -0400 @@ -100,19 +100,9 @@ ...page_props table already exists. ...updatelog table already exists. ...category table already exists. -Populating category table, printing progress markers. For large databases, you -may want to hit Ctrl-C and do this manually with maintenance/ -populateCategory.php. -Category population complete. -Done populating category table. +...category table already populated. ...have ar_parent_id field in archive table. ...have user_last_timestamp field in user_newtalk table. -Populating rev_parent_id fields, printing progress markers. For large -databases, you may want to hit Ctrl-C and do this manually with -maintenance/populateParentId.php. -Populating rev_parent_id column -...doing rev_id from 1 to 200 -rev_parent_id population complete ... 0 rows [0 changed] ...protected_titles table has correct pt_title encoding. ...have ss_active_users field in site_stats table. ...ss_active_users user count set... @@ -124,29 +114,19 @@ ...user_properties table already exists. ...log_search table already exists. ...have log_user_text field in logging table. -Populating log_user_text field, printing progress markers. For large -databases, you may want to hit Ctrl-C and do this manually with -maintenance/populateLogUsertext.php. -Nothing to do. -done. -Populating log_search table, printing progress markers. For large -databases, you may want to hit Ctrl-C and do this manually with -maintenance/populateLogSearch.php. -Nothing to do. -done. ...l10n_cache table already exists. ...index ls_field_val already set on log_search table. ...index change_tag_rc_tag already set on change_tag table. ...have rd_interwiki field in redirect table. -Converting tc_time from UNIX epoch to MediaWiki timestamp ...done. -Altering all *_mime_minor fields to 100 bytes in size ...done. +...transcache tc_time already converted. +...*_mime_minor fields are already long enough. ...iwlinks table already exists. ...index iwl_prefix_title_from already set on iwlinks table. ...have ul_value field in updatelog table. ...have iw_api field in interwiki table. ...iwl_prefix key doesn't exist. ...have cl_collation field in categorylinks table. -Updating categorylinks (again) ...done. +...categorylinks up-to-date. ...collations up-to-date. ...msg_resource table already exists. ...module_deps table already exists. @@ -155,7 +135,7 @@ ...ll_lang is up-to-date. ...user_last_timestamp is already nullable. ...index user_email already set on user table. -Modifying up_property field of table user_properties ...done. +...up_property in table user_properties already modified by patch patch-up_property.sql. ...uploadstash table already exists. ...user_former_groups table already exists. ...index type_action already set on logging table. @@ -183,8 +163,8 @@ ...have job_token field in job table. ...have job_attempts field in job table. ...have us_props field in uploadstash table. -Modifying ug_group field of table user_groups ...done. -Modifying ufg_group field of table user_former_groups ...done. +...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql. +...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql. ...index pp_propname_page already set on page_props table. ...index img_media_mime already set on image table. ...iwl_prefix_title_from index is already non-UNIQUE. @@ -197,26 +177,11 @@ ...have page_links_updated field in page table. ...have user_password_expires field in user table. ...site_stats is populated...done. -Checking existence of old default messages...done. -Populating rev_len column -...doing rev_id from 1 to 200 -Populating ar_len column -...archive table seems to be empty. -rev_len and ar_len population complete [0 revision rows, 0 archive rows]. -Populating rev_sha1 column -...doing rev_id from 1 to 200 -Populating ar_sha1 column -...archive table seems to be empty. -Populating ar_sha1 column legacy rows -rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows]. -Populating img_sha1 field - -Done 0 files in 0.0 seconds -Fixing protocol-relative entries in the externallinks table... -Done, 0 rows updated. -Populating fa_sha1 field from fa_storage_key - -Done 0 files in 0.0 seconds +...Update 'populate rev_len and ar_len' already logged as completed. +...Update 'populate rev_sha1' already logged as completed. +...img_sha1 column of image table already populated. +...protocol-relative URLs in externallinks table already fixed. +...fa_sha1 column of filearchive table already populated. Purging caches...done. Done in 0:00.