Page MenuHomeGitPull.it

Upgrade InformAzioni's MediaWiki
Closed, ResolvedPublic

Description

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:

Event Timeline

valerio.bozzolan created this task.
valerio.bozzolan changed the visibility from "All Users" to "Public (No Login Required)".

I will try to upgrade to the Debian packaged version.

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
2MediaWiki 1.31.6 Updater
3
4Your composer.lock file is up to date with current dependencies!
5Going to run database updates for informazioniwiki_mw
6Depending on the size of your database this may take a while!
7Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
8Turning 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.
105Populating category table, printing progress markers. For large databases, you
106may want to hit Ctrl-C and do this manually with maintenance/
107populateCategory.php.
108Category population complete.
109Done populating category table.
110...have ar_parent_id field in archive table.
111...have user_last_timestamp field in user_newtalk table.
112Populating rev_parent_id fields, printing progress markers. For large
113databases, you may want to hit Ctrl-C and do this manually with
114maintenance/populateParentId.php.
115Populating 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
122rev_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.
133Populating log_user_text field, printing progress markers. For large
134databases, you may want to hit Ctrl-C and do this manually with
135maintenance/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
147Done populating log_user_text field.
148done.
149Populating log_search table, printing progress markers. For large
150databases, you may want to hit Ctrl-C and do this manually with
151maintenance/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
163Done populating log_search table.
164done.
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.
168Converting tc_time from UNIX epoch to MediaWiki timestamp ...done.
169Altering 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.
176Updating 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.
203Content 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.
249Modifying 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.
255Modifying 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.
277Modifying 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.
283Modifying rev_comment field of table revision ...done.
284Adding 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.
294Creating slots table ...done.
295...have slot_origin field in slots table.
296Creating content table ...done.
297Creating slot_roles table ...done.
298Creating content_models table ...done.
299Migrating archive ar_text to modern storage.
300Migrating ar_text to modern storage...
301Completed ar_text migration, 0 rows updated, 0 missing data.
302Dropping ar_text and ar_flags columns ...done.
303Creating actor table ...done.
304Creating revision_actor_temp table ...done.
305Adding ar_actor field to table archive ...done.
306Adding ipb_by_actor field to table ipblocks ...done.
307Adding img_actor field to table image ...done.
308Adding oi_actor field to table oldimage ...done.
309Adding fa_actor field to table filearchive ...done.
310Adding rc_actor field to table recentchanges ...done.
311Adding log_actor field to table logging ...done.
312Modifying rev_text_id field of table revision ...done.
313Modifying table site_stats ...done.
314Populating ar_rev_id.
315Populating ar_rev_id...
316Completed ar_rev_id population, 0 rows updated.
317Making ar_rev_id not nullable ...done.
318Adding index rc_namespace_title_timestamp to table recentchanges ...done.
319...site_stats is populated...done.
320Checking existence of old default messages...done.
321Populating 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
328Populating ar_len column
329...doing ar_id from 1 to 200
330rev_len and ar_len population complete [0 revision rows, 0 archive rows].
331Populating 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
338Populating 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
344Populating ar_sha1 column legacy rows
345rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows].
346Populating img_sha1 field
347
348Done 0 files in 0.0 seconds
349Fixing protocol-relative entries in the externallinks table...
350Done, 0 rows updated.
351Populating fa_sha1 field from fa_storage_key
352
353Done 0 files in 0.0 seconds
354Updating *_from_namespace fields in links tables.
355...doing page_id from 1 to 200
356Adding empty categories with description pages...
357Removing empty categories without description pages...
358--mode=remove --begin=Wiki_Loves_Earth
359Category cleanup complete.
360Populating page_props.pp_sortkey...
361Updated 0 rows
362Populating page_props.pp_sortkey complete.
363Copying 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
365Attempted to insert 0 IP revisions, 0 actually done.
366Purging caches...done.
367
368Done in 30 s.

We are now on MediaWiki 1.31.6.

This task can be closed.

Memo: during update these skins were disabled:

  • CologneBlue
  • Modern

Because they are not used and they are not available in Debian.