Now we are running MediaWiki 1.30. We can upgrade to 1.33.1 to fix some errors of bad coding in:
Currently our old version is affected by these bugs:
| valerio.bozzolan | |
| Nov 13 2019, 07:482019-11-13 07:48:06 (UTC+1) |
Now we are running MediaWiki 1.30. We can upgrade to 1.33.1 to fix some errors of bad coding in:
Currently our old version is affected by these bugs:
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Resolved | valerio.bozzolan | T16 Upgrade InformAzioni's MediaWiki | ||
| Resolved | valerio.bozzolan | T99 Install Lockdown extension |
Now this MediaWiki instance is in sync with the Debian mediawiki package.
It's installed via some symbolic links:
# ls -l total 28 lrwxrwxrwx 1 root root 28 Jan 5 09:00 api.php -> /usr/share/mediawiki/api.php lrwxrwxrwx 1 root root 33 Jan 5 09:00 autoload.php -> /usr/share/mediawiki/autoload.php drwxr-x--- 2 www-data www-data 4096 Dec 8 2017 cache lrwxrwxrwx 1 root root 34 Jan 5 09:00 composer.json -> /usr/share/mediawiki/composer.json drwxr-x--- 19 www-data www-data 4096 Dec 8 2017 extensions drwxr-x--- 11 www-data www-data 4096 Jan 4 15:36 images lrwxrwxrwx 1 root root 33 Jan 5 09:01 img_auth.php -> /usr/share/mediawiki/img_auth.php lrwxrwxrwx 1 root root 30 Jan 5 09:01 includes -> /usr/share/mediawiki/includes/ lrwxrwxrwx 1 root root 30 Jan 5 09:01 index.php -> /usr/share/mediawiki/index.php lrwxrwxrwx 1 root root 31 Jan 5 09:03 languages -> /usr/share/mediawiki/languages/ lrwxrwxrwx 1 root root 29 Jan 5 09:01 load.php -> /usr/share/mediawiki/load.php -rw-r----- 1 root www-data 6641 Jan 5 09:14 LocalSettings.php -rw-r----- 1 www-data www-data 4187 Apr 30 2018 Logogiallo.png lrwxrwxrwx 1 root root 33 Jan 5 09:01 maintenance -> /usr/share/mediawiki/maintenance/ lrwxrwxrwx 1 root root 31 Jan 5 09:02 mw-config -> /usr/share/mediawiki/mw-config/ lrwxrwxrwx 1 root root 40 Jan 5 09:01 opensearch_desc.php -> /usr/share/mediawiki/opensearch_desc.php lrwxrwxrwx 1 root root 36 Jan 5 09:01 profileinfo.php -> /usr/share/mediawiki/profileinfo.php lrwxrwxrwx 1 root root 31 Jan 5 09:03 resources -> /usr/share/mediawiki/resources/ lrwxrwxrwx 1 root root 32 Jan 5 09:03 serialized -> /usr/share/mediawiki/serialized/ lrwxrwxrwx 1 root root 27 Jan 5 09:03 skins -> /usr/share/mediawiki/skins/ lrwxrwxrwx 1 root root 38 Jan 5 09:02 thumb_handler.php -> /usr/share/mediawiki/thumb_handler.php lrwxrwxrwx 1 root root 30 Jan 5 09:02 thumb.php -> /usr/share/mediawiki/thumb.php lrwxrwxrwx 1 root root 28 Jan 5 09:02 vendor -> /usr/share/mediawiki/vendor/
The upgrade script run successfully:
| 1 | $ php maintenance/update.php --conf LocalSettings.php |
|---|---|
| 2 | MediaWiki 1.31.6 Updater |
| 3 | |
| 4 | Your composer.lock file is up to date with current dependencies! |
| 5 | Going to run database updates for informazioniwiki_mw |
| 6 | Depending on the size of your database this may take a while! |
| 7 | Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0 |
| 8 | Turning off Content Handler DB fields for this part of upgrade. |
| 9 | ...have ipb_id field in ipblocks table. |
| 10 | ...have ipb_expiry field in ipblocks table. |
| 11 | ...already have interwiki table |
| 12 | ...indexes seem up to 20031107 standards. |
| 13 | ...have rc_type field in recentchanges table. |
| 14 | ...index new_name_timestamp already set on recentchanges table. |
| 15 | ...have user_real_name field in user table. |
| 16 | ...querycache table already exists. |
| 17 | ...objectcache table already exists. |
| 18 | ...categorylinks table already exists. |
| 19 | ...have pagelinks; skipping old links table updates |
| 20 | ...il_from OK |
| 21 | ...have rc_ip field in recentchanges table. |
| 22 | ...index PRIMARY already set on image table. |
| 23 | ...have rc_id field in recentchanges table. |
| 24 | ...have rc_patrolled field in recentchanges table. |
| 25 | ...logging table already exists. |
| 26 | ...have user_token field in user table. |
| 27 | ...have wl_notificationtimestamp field in watchlist table. |
| 28 | ...watchlist talk page rows already present. |
| 29 | ...user table does not contain user_emailauthenticationtimestamp field. |
| 30 | ...page table already exists. |
| 31 | ...have log_params field in logging table. |
| 32 | ...logging table has correct log_title encoding. |
| 33 | ...have ar_rev_id field in archive table. |
| 34 | ...have page_len field in page table. |
| 35 | ...revision table does not contain inverse_timestamp field. |
| 36 | ...have rev_text_id field in revision table. |
| 37 | ...have rev_deleted field in revision table. |
| 38 | ...have img_width field in image table. |
| 39 | ...have img_metadata field in image table. |
| 40 | ...have user_email_token field in user table. |
| 41 | ...have ar_text_id field in archive table. |
| 42 | ...page_namespace is already a full int (int(11)). |
| 43 | ...ar_namespace is already a full int (int(11)). |
| 44 | ...rc_namespace is already a full int (int(11)). |
| 45 | ...wl_namespace is already a full int (int(11)). |
| 46 | ...qc_namespace is already a full int (int(11)). |
| 47 | ...log_namespace is already a full int (int(11)). |
| 48 | ...have img_media_type field in image table. |
| 49 | ...already have pagelinks table. |
| 50 | ...image table does not contain img_type field. |
| 51 | ...already have unique user_name index. |
| 52 | ...user_groups table exists and is in current format. |
| 53 | ...have ss_total_pages field in site_stats table. |
| 54 | ...user_newtalk table already exists. |
| 55 | ...transcache table already exists. |
| 56 | ...have iw_trans field in interwiki table. |
| 57 | ...wl_notificationtimestamp is already nullable. |
| 58 | ...index times already set on logging table. |
| 59 | ...have ipb_range_start field in ipblocks table. |
| 60 | ...no page_random rows needed to be set |
| 61 | ...have user_registration field in user table. |
| 62 | ...templatelinks table already exists |
| 63 | ...externallinks table already exists. |
| 64 | ...job table already exists. |
| 65 | ...have ss_images field in site_stats table. |
| 66 | ...langlinks table already exists. |
| 67 | ...querycache_info table already exists. |
| 68 | ...filearchive table already exists. |
| 69 | ...have ipb_anon_only field in ipblocks table. |
| 70 | ...index rc_ns_usertext already set on recentchanges table. |
| 71 | ...index rc_user_text already set on recentchanges table. |
| 72 | ...have user_newpass_time field in user table. |
| 73 | ...redirect table already exists. |
| 74 | ...querycachetwo table already exists. |
| 75 | ...have ipb_enable_autoblock field in ipblocks table. |
| 76 | ...index pl_namespace on table pagelinks includes field pl_from. |
| 77 | ...index tl_namespace on table templatelinks includes field tl_from. |
| 78 | ...index il_to on table imagelinks includes field il_from. |
| 79 | ...have rc_old_len field in recentchanges table. |
| 80 | ...have user_editcount field in user table. |
| 81 | ...page_restrictions table already exists. |
| 82 | ...have log_id field in logging table. |
| 83 | ...have rev_parent_id field in revision table. |
| 84 | ...have pr_id field in page_restrictions table. |
| 85 | ...have rev_len field in revision table. |
| 86 | ...have rc_deleted field in recentchanges table. |
| 87 | ...have log_deleted field in logging table. |
| 88 | ...have ar_deleted field in archive table. |
| 89 | ...have ipb_deleted field in ipblocks table. |
| 90 | ...have fa_deleted field in filearchive table. |
| 91 | ...have ar_len field in archive table. |
| 92 | ...have ipb_block_email field in ipblocks table. |
| 93 | ...index cl_sortkey on table categorylinks includes field cl_from. |
| 94 | ...have oi_metadata field in oldimage table. |
| 95 | ...index usertext_timestamp already set on archive table. |
| 96 | ...index img_usertext_timestamp already set on image table. |
| 97 | ...index oi_usertext_timestamp already set on oldimage table. |
| 98 | ...have ar_page_id field in archive table. |
| 99 | ...have img_sha1 field in image table. |
| 100 | ...protected_titles table already exists. |
| 101 | ...have ipb_by_text field in ipblocks table. |
| 102 | ...page_props table already exists. |
| 103 | ...updatelog table already exists. |
| 104 | ...category table already exists. |
| 105 | Populating category table, printing progress markers. For large databases, you |
| 106 | may want to hit Ctrl-C and do this manually with maintenance/ |
| 107 | populateCategory.php. |
| 108 | Category population complete. |
| 109 | Done populating category table. |
| 110 | ...have ar_parent_id field in archive table. |
| 111 | ...have user_last_timestamp field in user_newtalk table. |
| 112 | Populating rev_parent_id fields, printing progress markers. For large |
| 113 | databases, you may want to hit Ctrl-C and do this manually with |
| 114 | maintenance/populateParentId.php. |
| 115 | Populating rev_parent_id column |
| 116 | ...doing rev_id from 1 to 200 |
| 117 | ...doing rev_id from 201 to 400 |
| 118 | ...doing rev_id from 401 to 600 |
| 119 | ...doing rev_id from 601 to 800 |
| 120 | ...doing rev_id from 801 to 1000 |
| 121 | ...doing rev_id from 1001 to 1200 |
| 122 | rev_parent_id population complete ... 0 rows [0 changed] |
| 123 | ...protected_titles table has correct pt_title encoding. |
| 124 | ...have ss_active_users field in site_stats table. |
| 125 | ...ss_active_users user count set... |
| 126 | ...have ipb_allow_usertalk field in ipblocks table. |
| 127 | ...change_tag table already exists. |
| 128 | ...tag_summary table already exists. |
| 129 | ...valid_tag table already exists. |
| 130 | ...user_properties table already exists. |
| 131 | ...log_search table already exists. |
| 132 | ...have log_user_text field in logging table. |
| 133 | Populating log_user_text field, printing progress markers. For large |
| 134 | databases, you may want to hit Ctrl-C and do this manually with |
| 135 | maintenance/populateLogUsertext.php. |
| 136 | ...doing log_id from 1 to 100 |
| 137 | ...doing log_id from 101 to 200 |
| 138 | ...doing log_id from 201 to 300 |
| 139 | ...doing log_id from 301 to 400 |
| 140 | ...doing log_id from 401 to 500 |
| 141 | ...doing log_id from 501 to 600 |
| 142 | ...doing log_id from 601 to 700 |
| 143 | ...doing log_id from 701 to 800 |
| 144 | ...doing log_id from 801 to 900 |
| 145 | ...doing log_id from 901 to 1000 |
| 146 | ...doing log_id from 1001 to 1100 |
| 147 | Done populating log_user_text field. |
| 148 | done. |
| 149 | Populating log_search table, printing progress markers. For large |
| 150 | databases, you may want to hit Ctrl-C and do this manually with |
| 151 | maintenance/populateLogSearch.php. |
| 152 | ...doing log_id from 1 to 100 |
| 153 | ...doing log_id from 101 to 200 |
| 154 | ...doing log_id from 201 to 300 |
| 155 | ...doing log_id from 301 to 400 |
| 156 | ...doing log_id from 401 to 500 |
| 157 | ...doing log_id from 501 to 600 |
| 158 | ...doing log_id from 601 to 700 |
| 159 | ...doing log_id from 701 to 800 |
| 160 | ...doing log_id from 801 to 900 |
| 161 | ...doing log_id from 901 to 1000 |
| 162 | ...doing log_id from 1001 to 1100 |
| 163 | Done populating log_search table. |
| 164 | done. |
| 165 | ...l10n_cache table already exists. |
| 166 | ...index change_tag_rc_tag already set on change_tag table. |
| 167 | ...have rd_interwiki field in redirect table. |
| 168 | Converting tc_time from UNIX epoch to MediaWiki timestamp ...done. |
| 169 | Altering all *_mime_minor fields to 100 bytes in size ...done. |
| 170 | ...iwlinks table already exists. |
| 171 | ...index iwl_prefix_title_from already set on iwlinks table. |
| 172 | ...have ul_value field in updatelog table. |
| 173 | ...have iw_api field in interwiki table. |
| 174 | ...iwl_prefix key doesn't exist. |
| 175 | ...have cl_collation field in categorylinks table. |
| 176 | Updating categorylinks (again) ...done. |
| 177 | ...module_deps table already exists. |
| 178 | ...ar_page_revid key doesn't exist. |
| 179 | ...index ar_revid already set on archive table. |
| 180 | ...ll_lang is up-to-date. |
| 181 | ...user_last_timestamp is already nullable. |
| 182 | ...index user_email already set on user table. |
| 183 | ...up_property in table user_properties already modified by patch patch-up_property.sql. |
| 184 | ...uploadstash table already exists. |
| 185 | ...user_former_groups table already exists. |
| 186 | ...index type_action already set on logging table. |
| 187 | ...have rev_sha1 field in revision table. |
| 188 | ...batch conversion of user_options: nothing to migrate. done. |
| 189 | ...user table does not contain user_options field. |
| 190 | ...have ar_sha1 field in archive table. |
| 191 | ...index page_redirect_namespace_len already set on page table. |
| 192 | ...have us_chunk_inx field in uploadstash table. |
| 193 | ...have job_timestamp field in job table. |
| 194 | ...index page_user_timestamp already set on revision table. |
| 195 | ...have ipb_parent_block_id field in ipblocks table. |
| 196 | ...index ipb_parent_block_id already set on ipblocks table. |
| 197 | ...category table does not contain cat_hidden field. |
| 198 | ...have rev_content_format field in revision table. |
| 199 | ...have rev_content_model field in revision table. |
| 200 | ...have ar_content_format field in archive table. |
| 201 | ...have ar_content_model field in archive table. |
| 202 | ...have page_content_model field in page table. |
| 203 | Content Handler DB fields should be usable now. |
| 204 | ...site_stats table does not contain ss_admins field. |
| 205 | ...recentchanges table does not contain rc_moved_to_title field. |
| 206 | ...sites table already exists. |
| 207 | ...have fa_sha1 field in filearchive table. |
| 208 | ...have job_token field in job table. |
| 209 | ...have job_attempts field in job table. |
| 210 | ...have us_props field in uploadstash table. |
| 211 | ...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql. |
| 212 | ...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql. |
| 213 | ...index pp_propname_page already set on page_props table. |
| 214 | ...index img_media_mime already set on image table. |
| 215 | ...iwl_prefix_title_from index is already non-UNIQUE. |
| 216 | ...index iwl_prefix_from_title already set on iwlinks table. |
| 217 | ...have ar_id field in archive table. |
| 218 | ...have el_id field in externallinks table. |
| 219 | ...have rc_source field in recentchanges table. |
| 220 | ...index log_user_text_type_time already set on logging table. |
| 221 | ...index log_user_text_time already set on logging table. |
| 222 | ...have page_links_updated field in page table. |
| 223 | ...have user_password_expires field in user table. |
| 224 | ...have pp_sortkey field in page_props table. |
| 225 | ...recentchanges table does not contain rc_cur_time field. |
| 226 | ...index wl_user_notificationtimestamp already set on watchlist table. |
| 227 | ...have page_lang field in page table. |
| 228 | ...have pl_from_namespace field in pagelinks table. |
| 229 | ...have tl_from_namespace field in templatelinks table. |
| 230 | ...have il_from_namespace field in imagelinks table. |
| 231 | ...img_major_mime in table image already modified by patch patch-img_major_mime-chemical.sql. |
| 232 | ...oi_major_mime in table oldimage already modified by patch patch-oi_major_mime-chemical.sql. |
| 233 | ...fa_major_mime in table filearchive already modified by patch patch-fa_major_mime-chemical.sql. |
| 234 | ...comment fields are up to date...hitcounter doesn't exist. |
| 235 | ...site_stats table does not contain ss_total_views field. |
| 236 | ...page table does not contain page_counter field. |
| 237 | ...msg_resource_links doesn't exist. |
| 238 | ...msg_resource doesn't exist. |
| 239 | ...bot_passwords table already exists. |
| 240 | ...have wl_id field in watchlist table. |
| 241 | ...cl_collation key doesn't exist. |
| 242 | ...index cl_collation_ext already set on categorylinks table. |
| 243 | ...collations up-to-date. |
| 244 | ...index rc_name_type_patrolled_timestamp already set on recentchanges table. |
| 245 | ...rev_page_id index already non-unique. |
| 246 | ...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE. |
| 247 | ...have ct_id field in change_tag table. |
| 248 | ...have ts_id field in tag_summary table. |
| 249 | Modifying rc_ip field of table recentchanges ...done. |
| 250 | ...index usertext_timestamp already set on archive table. |
| 251 | ...have el_index_60 field in externallinks table. |
| 252 | ...ug_user_group key doesn't exist. |
| 253 | ...have ug_expiry field in user_groups table. |
| 254 | ...index img_user_timestamp already set on image table. |
| 255 | Modifying img_media_type field of table image ...done. |
| 256 | ...ip_changes table already exists. |
| 257 | ...index PRIMARY already set on categorylinks table. |
| 258 | ...index PRIMARY already set on templatelinks table. |
| 259 | ...index PRIMARY already set on pagelinks table. |
| 260 | ...index PRIMARY already set on text table. |
| 261 | ...index PRIMARY already set on imagelinks table. |
| 262 | ...index PRIMARY already set on iwlinks table. |
| 263 | ...index PRIMARY already set on langlinks table. |
| 264 | ...index PRIMARY already set on log_search table. |
| 265 | ...index PRIMARY already set on module_deps table. |
| 266 | ...index PRIMARY already set on objectcache table. |
| 267 | ...index PRIMARY already set on querycache_info table. |
| 268 | ...index PRIMARY already set on site_stats table. |
| 269 | ...index PRIMARY already set on transcache table. |
| 270 | ...index PRIMARY already set on user_former_groups table. |
| 271 | ...index PRIMARY already set on user_properties table. |
| 272 | ...comment table already exists. |
| 273 | ...revision_comment_temp table already exists. |
| 274 | ...image_comment_temp table already exists. |
| 275 | ...have ar_comment_id field in archive table. |
| 276 | ...have fa_description_id field in filearchive table. |
| 277 | Modifying img_description field of table image ...done. |
| 278 | ...have ipb_reason_id field in ipblocks table. |
| 279 | ...have log_comment_id field in logging table. |
| 280 | ...have oi_description_id field in oldimage table. |
| 281 | ...have pt_reason_id field in protected_titles table. |
| 282 | ...have rc_comment_id field in recentchanges table. |
| 283 | Modifying rev_comment field of table revision ...done. |
| 284 | Adding img_description_id field to table image ...done. |
| 285 | ...index PRIMARY already set on l10n_cache table. |
| 286 | ...bot_passwords.bp_user is already unsigned int. |
| 287 | ...change_tag.ct_log_id is already unsigned int. |
| 288 | ...change_tag.ct_rev_id is already unsigned int. |
| 289 | ...page_restrictions.pr_user is already unsigned int. |
| 290 | ...tag_summary.ts_log_id is already unsigned int. |
| 291 | ...tag_summary.ts_rev_id is already unsigned int. |
| 292 | ...user_newtalk.user_id is already unsigned int. |
| 293 | ...user_properties.up_user is already unsigned int. |
| 294 | Creating slots table ...done. |
| 295 | ...have slot_origin field in slots table. |
| 296 | Creating content table ...done. |
| 297 | Creating slot_roles table ...done. |
| 298 | Creating content_models table ...done. |
| 299 | Migrating archive ar_text to modern storage. |
| 300 | Migrating ar_text to modern storage... |
| 301 | Completed ar_text migration, 0 rows updated, 0 missing data. |
| 302 | Dropping ar_text and ar_flags columns ...done. |
| 303 | Creating actor table ...done. |
| 304 | Creating revision_actor_temp table ...done. |
| 305 | Adding ar_actor field to table archive ...done. |
| 306 | Adding ipb_by_actor field to table ipblocks ...done. |
| 307 | Adding img_actor field to table image ...done. |
| 308 | Adding oi_actor field to table oldimage ...done. |
| 309 | Adding fa_actor field to table filearchive ...done. |
| 310 | Adding rc_actor field to table recentchanges ...done. |
| 311 | Adding log_actor field to table logging ...done. |
| 312 | Modifying rev_text_id field of table revision ...done. |
| 313 | Modifying table site_stats ...done. |
| 314 | Populating ar_rev_id. |
| 315 | Populating ar_rev_id... |
| 316 | Completed ar_rev_id population, 0 rows updated. |
| 317 | Making ar_rev_id not nullable ...done. |
| 318 | Adding index rc_namespace_title_timestamp to table recentchanges ...done. |
| 319 | ...site_stats is populated...done. |
| 320 | Checking existence of old default messages...done. |
| 321 | Populating rev_len column |
| 322 | ...doing rev_id from 1 to 200 |
| 323 | ...doing rev_id from 201 to 400 |
| 324 | ...doing rev_id from 401 to 600 |
| 325 | ...doing rev_id from 601 to 800 |
| 326 | ...doing rev_id from 801 to 1000 |
| 327 | ...doing rev_id from 1001 to 1200 |
| 328 | Populating ar_len column |
| 329 | ...doing ar_id from 1 to 200 |
| 330 | rev_len and ar_len population complete [0 revision rows, 0 archive rows]. |
| 331 | Populating rev_sha1 column |
| 332 | ...doing rev_id from 1 to 200 |
| 333 | ...doing rev_id from 201 to 400 |
| 334 | ...doing rev_id from 401 to 600 |
| 335 | ...doing rev_id from 601 to 800 |
| 336 | ...doing rev_id from 801 to 1000 |
| 337 | ...doing rev_id from 1001 to 1200 |
| 338 | Populating ar_sha1 column |
| 339 | ...doing ar_rev_id from 96 to 295 |
| 340 | ...doing ar_rev_id from 296 to 495 |
| 341 | ...doing ar_rev_id from 496 to 695 |
| 342 | ...doing ar_rev_id from 696 to 895 |
| 343 | ...doing ar_rev_id from 896 to 1095 |
| 344 | Populating ar_sha1 column legacy rows |
| 345 | rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows]. |
| 346 | Populating img_sha1 field |
| 347 | |
| 348 | Done 0 files in 0.0 seconds |
| 349 | Fixing protocol-relative entries in the externallinks table... |
| 350 | Done, 0 rows updated. |
| 351 | Populating fa_sha1 field from fa_storage_key |
| 352 | |
| 353 | Done 0 files in 0.0 seconds |
| 354 | Updating *_from_namespace fields in links tables. |
| 355 | ...doing page_id from 1 to 200 |
| 356 | Adding empty categories with description pages... |
| 357 | Removing empty categories without description pages... |
| 358 | --mode=remove --begin=Wiki_Loves_Earth |
| 359 | Category cleanup complete. |
| 360 | Populating page_props.pp_sortkey... |
| 361 | Updated 0 rows |
| 362 | Populating page_props.pp_sortkey complete. |
| 363 | Copying IP revisions to ip_changes, from rev_id 0 to rev_id 1068 |
| 364 | ...checking 1 revisions for IP edits that need copying, between rev_ids 0 and 200 |
| 365 | Attempted to insert 0 IP revisions, 0 actually done. |
| 366 | Purging caches...done. |
| 367 | |
| 368 | Done in 30 s. |
We are now on MediaWiki 1.31.6.
This task can be closed.
Memo: during update these skins were disabled:
Because they are not used and they are not available in Debian.