Mediawiki references and how tos

- 2017-07-26 Wednesday -

Ted having trouble restoring a Mediawiki 1.19.2 database dump to a back-up server, where Mediawiki 1.28.0 version is installed. Not sure whether updating the database schema on the newer versioned back-up server will work. Here is a Mediawiki reference to an update script which is part of this open source wiki project:

  *  https://www.mediawiki.org/wiki/Manual:Update.php

Detailed version information of Mediawiki installations and supporting software elements, on original and back-up servers:

Product	alta-ubuntu version	alta-spare-2u version
MediaWiki	1.19.2	1.28.0
PHP	5.3.5-1ubuntu7.11 (apache2handler)	7.0.18-0ubuntu0.16.04.1 (apache2handler)
MySQL	5.1.54-1ubuntu4	5.7.13-0ubuntu0.16.04.2

So there are differences between Mediawiki 1.19.2 and 1.28.0 in the names of wiki database table fields, which led to the restored wiki on host alta-spare-2u not being able to present any wiki pages. The brief error message indicated, however, that setting two Mediawiki variables in the Mediawiki configuration file LocalSettings.php would produce on next visit to wiki page a more detailed debugging report. This more detailed debugging report mentions the possible need and help of running updatedb.php.

Example Output Of Mediawiki Update PHP Script

user@localhost:/var/www/html/alta-wiki/maintenance$ sudo ./update.php 
[sudo] password for user: 
MediaWiki 1.28.0 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for alta_wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
Turning off Content Handler DB fields for this part of upgrade.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...have rc_type field in recentchanges table.
...index new_name_timestamp already set on recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...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)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...transcache table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...index rc_ns_usertext already set on recentchanges table.
...index rc_user_text already set on recentchanges table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...index usertext_timestamp already set on archive table.
...index img_usertext_timestamp already set on image table.
...index oi_usertext_timestamp already set on oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...have ipb_by_text field in ipblocks table.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
...category table already populated.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...change_tag table already exists.
...tag_summary table already exists.
...valid_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...have log_user_text field in logging table.
...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.
...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.
...categorylinks up-to-date.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...index ar_revid already set on archive table.
...ll_lang is up-to-date.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
...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.
...have rev_sha1 field in revision table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
Adding index page_user_timestamp to table revision ...done.
Adding ipb_parent_block_id field to table ipblocks ...done.
Adding index ipb_parent_block_id to table ipblocks ...done.
Table category contains cat_hidden field. Dropping ...done.
Adding rev_content_format field to table revision ...done.
Adding rev_content_model field to table revision ...done.
Adding ar_content_format field to table archive ...done.
Adding ar_content_model field to table archive ...done.
Adding page_content_model field to table page ...done.
Content Handler DB fields should be usable now.
Table site_stats contains ss_admins field. Dropping ...done.
Table recentchanges contains rc_moved_to_title field. Dropping ...done.
...sites table already exists.
Adding fa_sha1 field to table filearchive ...done.
Adding job_token field to table job ...done.
Adding job_attempts field to table job ...done.
Adding us_props field to table uploadstash ...done.
Modifying ug_group field of table user_groups ...done.
Modifying ufg_group field of table user_former_groups ...done.
Adding index pp_propname_page to table page_props ...done.
Adding index img_media_mime to table image ...done.
Making iwl_prefix_title_from index non-UNIQUE ...done.
Adding index iwl_prefix_from_title to table iwlinks ...done.
Adding ar_id field to table archive ...done.
Adding el_id field to table externallinks ...done.
Adding rc_source field to table recentchanges ...done.
Adding index log_user_text_type_time to table logging ...done.
Adding index log_user_text_time to table logging ...done.
Adding page_links_updated field to table page ...done.
Adding user_password_expires field to table user ...done.
Adding pp_sortkey field to table page_props ...done.
Table recentchanges contains rc_cur_time field. Dropping ...done.
Adding index wl_user_notificationtimestamp to table watchlist ...done.
Adding page_lang field to table page ...done.
Adding pl_from_namespace field to table pagelinks ...done.
Adding tl_from_namespace field to table templatelinks ...done.
Adding il_from_namespace field to table imagelinks ...done.
Modifying img_major_mime field of table image ...done.
Modifying oi_major_mime field of table oldimage ...done.
Modifying fa_major_mime field of table filearchive ...done.
Making user_id unsigned int ...done.
Modifying rc_comment field of table recentchanges ...done.
Dropping table hitcounter ...done.
Table site_stats contains ss_total_views field. Dropping ...done.
Table page contains page_counter field. Dropping ...done.
Dropping table msg_resource_links ...done.
Dropping table msg_resource ...done.
...bot_passwords table already exists.
Adding wl_id field to table watchlist ...done.
Dropping cl_collation index from table categorylinks ...done.
Adding index cl_collation_ext to table categorylinks ...done.
...collations up-to-date.
Adding index rc_name_type_patrolled_timestamp to table recentchanges ...done.
...rev_page_id index not found on revision.
Making pl_namespace, tl_namespace and il_to indices non-UNIQUE ...done.
Adding ct_id field to table change_tag ...done.
Adding ts_id field to table tag_summary ...done.
Modifying rc_ip field of table recentchanges ...done.
...site_stats is populated...done.
Populating rev_len column
...doing rev_id from 1 to 200
...doing rev_id from 201 to 400
...doing rev_id from 401 to 600
...doing rev_id from 601 to 800
...doing rev_id from 801 to 1000
...doing rev_id from 1001 to 1200
...doing rev_id from 1201 to 1400
...doing rev_id from 1401 to 1600
...doing rev_id from 1601 to 1800
...doing rev_id from 1801 to 2000
...doing rev_id from 2001 to 2200
...doing rev_id from 2201 to 2400
...doing rev_id from 2401 to 2600
...doing rev_id from 2601 to 2800
...doing rev_id from 2801 to 3000
...doing rev_id from 3001 to 3200
...doing rev_id from 3201 to 3400
...doing rev_id from 3401 to 3600
...doing rev_id from 3601 to 3800
...doing rev_id from 3801 to 4000
...doing rev_id from 4001 to 4200
...doing rev_id from 4201 to 4400
...doing rev_id from 4401 to 4600
...doing rev_id from 4601 to 4800
...doing rev_id from 4801 to 5000
...doing rev_id from 5001 to 5200
...doing rev_id from 5201 to 5400
...doing rev_id from 5401 to 5600
...doing rev_id from 5601 to 5800
...doing rev_id from 5801 to 6000
...doing rev_id from 6001 to 6200
...doing rev_id from 6201 to 6400
...doing rev_id from 6401 to 6600
...doing rev_id from 6601 to 6800
...doing rev_id from 6801 to 7000
...doing rev_id from 7001 to 7200
...doing rev_id from 7201 to 7400
...doing rev_id from 7401 to 7600
...doing rev_id from 7601 to 7800
...doing rev_id from 7801 to 8000
...doing rev_id from 8001 to 8200
...doing rev_id from 8201 to 8400
...doing rev_id from 8401 to 8600
...doing rev_id from 8601 to 8800
...doing rev_id from 8801 to 9000
Populating ar_len column
...doing ar_id from 1 to 200
...doing ar_id from 201 to 400
...doing ar_id from 401 to 600
...doing ar_id from 601 to 800
...doing ar_id from 801 to 1000
...doing ar_id from 1001 to 1200
...doing ar_id from 1201 to 1400
...doing ar_id from 1401 to 1600
rev_len and ar_len population complete [7 revision rows, 1573 archive rows].
...Update 'populate rev_sha1' already logged as completed.
Populating img_sha1 field

Done 0 files in 0.0 seconds
...protocol-relative URLs in externallinks table already fixed.
Populating fa_sha1 field from fa_storage_key

Done 40 files in 0.1 seconds
Updating *_from_namespace fields in links tables.
...doing page_id from 1 to 200
...doing page_id from 200 to 399
...doing page_id from 399 to 598
...doing page_id from 598 to 797
...doing page_id from 797 to 996
...doing page_id from 996 to 1195
...doing page_id from 1195 to 1394
...doing page_id from 1394 to 1593
...doing page_id from 1593 to 1792
...doing page_id from 1792 to 1991
...doing page_id from 1991 to 2190
...doing page_id from 2190 to 2389
...doing page_id from 2389 to 2588
...doing page_id from 2588 to 2787
Adding empty categories with description pages...
--mode=both --begin=Testing
Removing empty categories without description pages...
--mode=remove --begin=Testsets
Category cleanup complete.
Set the local repo temp zone container to be private.
Purging caches...done.

Done in 24 s.
user@localhost:/var/www/html/alta-wiki/maintenance$