MediaWiki  1.28.1
MysqlUpdater.php
Go to the documentation of this file.
1 <?php
31  protected function getCoreUpdateList() {
32  return [
33  [ 'disableContentHandlerUseDB' ],
34 
35  // 1.2
36  [ 'addField', 'ipblocks', 'ipb_id', 'patch-ipblocks.sql' ],
37  [ 'addField', 'ipblocks', 'ipb_expiry', 'patch-ipb_expiry.sql' ],
38  [ 'doInterwikiUpdate' ],
39  [ 'doIndexUpdate' ],
40  [ 'addField', 'recentchanges', 'rc_type', 'patch-rc_type.sql' ],
41  [ 'addIndex', 'recentchanges', 'new_name_timestamp', 'patch-rc-newindex.sql' ],
42 
43  // 1.3
44  [ 'addField', 'user', 'user_real_name', 'patch-user-realname.sql' ],
45  [ 'addTable', 'querycache', 'patch-querycache.sql' ],
46  [ 'addTable', 'objectcache', 'patch-objectcache.sql' ],
47  [ 'addTable', 'categorylinks', 'patch-categorylinks.sql' ],
48  [ 'doOldLinksUpdate' ],
49  [ 'doFixAncientImagelinks' ],
50  [ 'addField', 'recentchanges', 'rc_ip', 'patch-rc_ip.sql' ],
51 
52  // 1.4
53  [ 'addIndex', 'image', 'PRIMARY', 'patch-image_name_primary.sql' ],
54  [ 'addField', 'recentchanges', 'rc_id', 'patch-rc_id.sql' ],
55  [ 'addField', 'recentchanges', 'rc_patrolled', 'patch-rc-patrol.sql' ],
56  [ 'addTable', 'logging', 'patch-logging.sql' ],
57  [ 'addField', 'user', 'user_token', 'patch-user_token.sql' ],
58  [ 'addField', 'watchlist', 'wl_notificationtimestamp', 'patch-email-notification.sql' ],
59  [ 'doWatchlistUpdate' ],
60  [ 'dropField', 'user', 'user_emailauthenticationtimestamp',
61  'patch-email-authentication.sql' ],
62 
63  // 1.5
64  [ 'doSchemaRestructuring' ],
65  [ 'addField', 'logging', 'log_params', 'patch-log_params.sql' ],
66  [ 'checkBin', 'logging', 'log_title', 'patch-logging-title.sql', ],
67  [ 'addField', 'archive', 'ar_rev_id', 'patch-archive-rev_id.sql' ],
68  [ 'addField', 'page', 'page_len', 'patch-page_len.sql' ],
69  [ 'dropField', 'revision', 'inverse_timestamp', 'patch-inverse_timestamp.sql' ],
70  [ 'addField', 'revision', 'rev_text_id', 'patch-rev_text_id.sql' ],
71  [ 'addField', 'revision', 'rev_deleted', 'patch-rev_deleted.sql' ],
72  [ 'addField', 'image', 'img_width', 'patch-img_width.sql' ],
73  [ 'addField', 'image', 'img_metadata', 'patch-img_metadata.sql' ],
74  [ 'addField', 'user', 'user_email_token', 'patch-user_email_token.sql' ],
75  [ 'addField', 'archive', 'ar_text_id', 'patch-archive-text_id.sql' ],
76  [ 'doNamespaceSize' ],
77  [ 'addField', 'image', 'img_media_type', 'patch-img_media_type.sql' ],
78  [ 'doPagelinksUpdate' ],
79  [ 'dropField', 'image', 'img_type', 'patch-drop_img_type.sql' ],
80  [ 'doUserUniqueUpdate' ],
81  [ 'doUserGroupsUpdate' ],
82  [ 'addField', 'site_stats', 'ss_total_pages', 'patch-ss_total_articles.sql' ],
83  [ 'addTable', 'user_newtalk', 'patch-usernewtalk2.sql' ],
84  [ 'addTable', 'transcache', 'patch-transcache.sql' ],
85  [ 'addField', 'interwiki', 'iw_trans', 'patch-interwiki-trans.sql' ],
86 
87  // 1.6
88  [ 'doWatchlistNull' ],
89  [ 'addIndex', 'logging', 'times', 'patch-logging-times-index.sql' ],
90  [ 'addField', 'ipblocks', 'ipb_range_start', 'patch-ipb_range_start.sql' ],
91  [ 'doPageRandomUpdate' ],
92  [ 'addField', 'user', 'user_registration', 'patch-user_registration.sql' ],
93  [ 'doTemplatelinksUpdate' ],
94  [ 'addTable', 'externallinks', 'patch-externallinks.sql' ],
95  [ 'addTable', 'job', 'patch-job.sql' ],
96  [ 'addField', 'site_stats', 'ss_images', 'patch-ss_images.sql' ],
97  [ 'addTable', 'langlinks', 'patch-langlinks.sql' ],
98  [ 'addTable', 'querycache_info', 'patch-querycacheinfo.sql' ],
99  [ 'addTable', 'filearchive', 'patch-filearchive.sql' ],
100  [ 'addField', 'ipblocks', 'ipb_anon_only', 'patch-ipb_anon_only.sql' ],
101  [ 'addIndex', 'recentchanges', 'rc_ns_usertext', 'patch-recentchanges-utindex.sql' ],
102  [ 'addIndex', 'recentchanges', 'rc_user_text', 'patch-rc_user_text-index.sql' ],
103 
104  // 1.9
105  [ 'addField', 'user', 'user_newpass_time', 'patch-user_newpass_time.sql' ],
106  [ 'addTable', 'redirect', 'patch-redirect.sql' ],
107  [ 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ],
108  [ 'addField', 'ipblocks', 'ipb_enable_autoblock', 'patch-ipb_optional_autoblock.sql' ],
109  [ 'doBacklinkingIndicesUpdate' ],
110  [ 'addField', 'recentchanges', 'rc_old_len', 'patch-rc_len.sql' ],
111  [ 'addField', 'user', 'user_editcount', 'patch-user_editcount.sql' ],
112 
113  // 1.10
114  [ 'doRestrictionsUpdate' ],
115  [ 'addField', 'logging', 'log_id', 'patch-log_id.sql' ],
116  [ 'addField', 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ],
117  [ 'addField', 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ],
118  [ 'addField', 'revision', 'rev_len', 'patch-rev_len.sql' ],
119  [ 'addField', 'recentchanges', 'rc_deleted', 'patch-rc_deleted.sql' ],
120  [ 'addField', 'logging', 'log_deleted', 'patch-log_deleted.sql' ],
121  [ 'addField', 'archive', 'ar_deleted', 'patch-ar_deleted.sql' ],
122  [ 'addField', 'ipblocks', 'ipb_deleted', 'patch-ipb_deleted.sql' ],
123  [ 'addField', 'filearchive', 'fa_deleted', 'patch-fa_deleted.sql' ],
124  [ 'addField', 'archive', 'ar_len', 'patch-ar_len.sql' ],
125 
126  // 1.11
127  [ 'addField', 'ipblocks', 'ipb_block_email', 'patch-ipb_emailban.sql' ],
128  [ 'doCategorylinksIndicesUpdate' ],
129  [ 'addField', 'oldimage', 'oi_metadata', 'patch-oi_metadata.sql' ],
130  [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-archive-user-index.sql' ],
131  [ 'addIndex', 'image', 'img_usertext_timestamp', 'patch-image-user-index.sql' ],
132  [ 'addIndex', 'oldimage', 'oi_usertext_timestamp', 'patch-oldimage-user-index.sql' ],
133  [ 'addField', 'archive', 'ar_page_id', 'patch-archive-page_id.sql' ],
134  [ 'addField', 'image', 'img_sha1', 'patch-img_sha1.sql' ],
135 
136  // 1.12
137  [ 'addTable', 'protected_titles', 'patch-protected_titles.sql' ],
138 
139  // 1.13
140  [ 'addField', 'ipblocks', 'ipb_by_text', 'patch-ipb_by_text.sql' ],
141  [ 'addTable', 'page_props', 'patch-page_props.sql' ],
142  [ 'addTable', 'updatelog', 'patch-updatelog.sql' ],
143  [ 'addTable', 'category', 'patch-category.sql' ],
144  [ 'doCategoryPopulation' ],
145  [ 'addField', 'archive', 'ar_parent_id', 'patch-ar_parent_id.sql' ],
146  [ 'addField', 'user_newtalk', 'user_last_timestamp', 'patch-user_last_timestamp.sql' ],
147  [ 'doPopulateParentId' ],
148  [ 'checkBin', 'protected_titles', 'pt_title', 'patch-pt_title-encoding.sql', ],
149  [ 'doMaybeProfilingMemoryUpdate' ],
150  [ 'doFilearchiveIndicesUpdate' ],
151 
152  // 1.14
153  [ 'addField', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ],
154  [ 'doActiveUsersInit' ],
155  [ 'addField', 'ipblocks', 'ipb_allow_usertalk', 'patch-ipb_allow_usertalk.sql' ],
156 
157  // 1.15
158  [ 'addTable', 'change_tag', 'patch-change_tag.sql' ],
159  [ 'addTable', 'tag_summary', 'patch-tag_summary.sql' ],
160  [ 'addTable', 'valid_tag', 'patch-valid_tag.sql' ],
161 
162  // 1.16
163  [ 'addTable', 'user_properties', 'patch-user_properties.sql' ],
164  [ 'addTable', 'log_search', 'patch-log_search.sql' ],
165  [ 'addField', 'logging', 'log_user_text', 'patch-log_user_text.sql' ],
166  # listed separately from the previous update because 1.16 was released without this update
167  [ 'doLogUsertextPopulation' ],
168  [ 'doLogSearchPopulation' ],
169  [ 'addTable', 'l10n_cache', 'patch-l10n_cache.sql' ],
170  [ 'addIndex', 'log_search', 'ls_field_val', 'patch-log_search-rename-index.sql' ],
171  [ 'addIndex', 'change_tag', 'change_tag_rc_tag', 'patch-change_tag-indexes.sql' ],
172  [ 'addField', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ],
173  [ 'doUpdateTranscacheField' ],
174  [ 'doUpdateMimeMinorField' ],
175 
176  // 1.17
177  [ 'addTable', 'iwlinks', 'patch-iwlinks.sql' ],
178  [ 'addIndex', 'iwlinks', 'iwl_prefix_title_from', 'patch-rename-iwl_prefix.sql' ],
179  [ 'addField', 'updatelog', 'ul_value', 'patch-ul_value.sql' ],
180  [ 'addField', 'interwiki', 'iw_api', 'patch-iw_api_and_wikiid.sql' ],
181  [ 'dropIndex', 'iwlinks', 'iwl_prefix', 'patch-kill-iwl_prefix.sql' ],
182  [ 'addField', 'categorylinks', 'cl_collation', 'patch-categorylinks-better-collation.sql' ],
183  [ 'doClFieldsUpdate' ],
184  [ 'addTable', 'module_deps', 'patch-module_deps.sql' ],
185  [ 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ],
186  [ 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ],
187  [ 'doLangLinksLengthUpdate' ],
188 
189  // 1.18
190  [ 'doUserNewTalkTimestampNotNull' ],
191  [ 'addIndex', 'user', 'user_email', 'patch-user_email_index.sql' ],
192  [ 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ],
193  [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
194  [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
195 
196  // 1.19
197  [ 'addIndex', 'logging', 'type_action', 'patch-logging-type-action-index.sql' ],
198  [ 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1.sql' ],
199  [ 'doMigrateUserOptions' ],
200  [ 'dropField', 'user', 'user_options', 'patch-drop-user_options.sql' ],
201  [ 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1.sql' ],
202  [ 'addIndex', 'page', 'page_redirect_namespace_len',
203  'patch-page_redirect_namespace_len.sql' ],
204  [ 'addField', 'uploadstash', 'us_chunk_inx', 'patch-uploadstash_chunk.sql' ],
205  [ 'addfield', 'job', 'job_timestamp', 'patch-jobs-add-timestamp.sql' ],
206 
207  // 1.20
208  [ 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ],
209  [ 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ],
210  [ 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ],
211  [ 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ],
212 
213  // 1.21
214  [ 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ],
215  [ 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ],
216  [ 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ],
217  [ 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ],
218  [ 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ],
219  [ 'enableContentHandlerUseDB' ],
220  [ 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ],
221  [ 'dropField', 'recentchanges', 'rc_moved_to_title', 'patch-rc_moved.sql' ],
222  [ 'addTable', 'sites', 'patch-sites.sql' ],
223  [ 'addField', 'filearchive', 'fa_sha1', 'patch-fa_sha1.sql' ],
224  [ 'addField', 'job', 'job_token', 'patch-job_token.sql' ],
225  [ 'addField', 'job', 'job_attempts', 'patch-job_attempts.sql' ],
226  [ 'doEnableProfiling' ],
227  [ 'addField', 'uploadstash', 'us_props', 'patch-uploadstash-us_props.sql' ],
228  [ 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ],
229  [ 'modifyField', 'user_former_groups', 'ufg_group',
230  'patch-ufg_group-length-increase-255.sql' ],
231  [ 'addIndex', 'page_props', 'pp_propname_page',
232  'patch-page_props-propname-page-index.sql' ],
233  [ 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ],
234 
235  // 1.22
236  [ 'doIwlinksIndexNonUnique' ],
237  [ 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
238  'patch-iwlinks-from-title-index.sql' ],
239  [ 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ],
240  [ 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ],
241 
242  // 1.23
243  [ 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ],
244  [ 'addIndex', 'logging', 'log_user_text_type_time',
245  'patch-logging_user_text_type_time_index.sql' ],
246  [ 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ],
247  [ 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ],
248  [ 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ],
249 
250  // 1.24
251  [ 'addField', 'page_props', 'pp_sortkey', 'patch-pp_sortkey.sql' ],
252  [ 'dropField', 'recentchanges', 'rc_cur_time', 'patch-drop-rc_cur_time.sql' ],
253  [ 'addIndex', 'watchlist', 'wl_user_notificationtimestamp',
254  'patch-watchlist-user-notificationtimestamp-index.sql' ],
255  [ 'addField', 'page', 'page_lang', 'patch-page_lang.sql' ],
256  [ 'addField', 'pagelinks', 'pl_from_namespace', 'patch-pl_from_namespace.sql' ],
257  [ 'addField', 'templatelinks', 'tl_from_namespace', 'patch-tl_from_namespace.sql' ],
258  [ 'addField', 'imagelinks', 'il_from_namespace', 'patch-il_from_namespace.sql' ],
259  [ 'modifyField', 'image', 'img_major_mime',
260  'patch-img_major_mime-chemical.sql' ],
261  [ 'modifyField', 'oldimage', 'oi_major_mime',
262  'patch-oi_major_mime-chemical.sql' ],
263  [ 'modifyField', 'filearchive', 'fa_major_mime',
264  'patch-fa_major_mime-chemical.sql' ],
265 
266  // 1.25
267  [ 'doUserNewTalkUseridUnsigned' ],
268  // note this patch covers other _comment and _description fields too
269  [ 'modifyField', 'recentchanges', 'rc_comment', 'patch-editsummary-length.sql' ],
270 
271  // 1.26
272  [ 'dropTable', 'hitcounter' ],
273  [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
274  [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
275 
276  // 1.27
277  [ 'dropTable', 'msg_resource_links' ],
278  [ 'dropTable', 'msg_resource' ],
279  [ 'addTable', 'bot_passwords', 'patch-bot_passwords.sql' ],
280  [ 'addField', 'watchlist', 'wl_id', 'patch-watchlist-wl_id.sql' ],
281  [ 'dropIndex', 'categorylinks', 'cl_collation', 'patch-kill-cl_collation_index.sql' ],
282  [ 'addIndex', 'categorylinks', 'cl_collation_ext',
283  'patch-add-cl_collation_ext_index.sql' ],
284  [ 'doCollationUpdate' ],
285 
286  // 1.28
287  [ 'addIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
288  'patch-add-rc_name_type_patrolled_timestamp_index.sql' ],
289  [ 'doRevisionPageRevIndexNonUnique' ],
290  [ 'doNonUniquePlTlIl' ],
291  [ 'addField', 'change_tag', 'ct_id', 'patch-change_tag-ct_id.sql' ],
292  [ 'addField', 'tag_summary', 'ts_id', 'patch-tag_summary-ts_id.sql' ],
293  [ 'modifyField', 'recentchanges', 'rc_ip', 'patch-rc_ip_modify.sql' ],
294  [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-rename-ar_usertext_timestamp.sql' ],
295  ];
296  }
297 
307  protected function checkBin( $table, $field, $patchFile ) {
308  if ( !$this->doTable( $table ) ) {
309  return true;
310  }
311 
313  $fieldInfo = $this->db->fieldInfo( $table, $field );
314  if ( $fieldInfo->isBinary() ) {
315  $this->output( "...$table table has correct $field encoding.\n" );
316  } else {
317  $this->applyPatch( $patchFile, false, "Fixing $field encoding on $table table" );
318  }
319  }
320 
329  protected function indexHasField( $table, $index, $field ) {
330  if ( !$this->doTable( $table ) ) {
331  return true;
332  }
333 
334  $info = $this->db->indexInfo( $table, $index, __METHOD__ );
335  if ( $info ) {
336  foreach ( $info as $row ) {
337  if ( $row->Column_name == $field ) {
338  $this->output( "...index $index on table $table includes field $field.\n" );
339 
340  return true;
341  }
342  }
343  }
344  $this->output( "...index $index on table $table has no field $field; added.\n" );
345 
346  return false;
347  }
348 
352  protected function doInterwikiUpdate() {
353  global $IP;
354 
355  if ( !$this->doTable( 'interwiki' ) ) {
356  return true;
357  }
358 
359  if ( $this->db->tableExists( "interwiki", __METHOD__ ) ) {
360  $this->output( "...already have interwiki table\n" );
361 
362  return;
363  }
364 
365  $this->applyPatch( 'patch-interwiki.sql', false, 'Creating interwiki table' );
366  $this->applyPatch(
367  "$IP/maintenance/interwiki.sql",
368  true,
369  'Adding default interwiki definitions'
370  );
371  }
372 
376  protected function doIndexUpdate() {
377  $meta = $this->db->fieldInfo( 'recentchanges', 'rc_timestamp' );
378  if ( $meta === false ) {
379  throw new MWException( 'Missing rc_timestamp field of recentchanges table. Should not happen.' );
380  }
381  if ( $meta->isMultipleKey() ) {
382  $this->output( "...indexes seem up to 20031107 standards.\n" );
383 
384  return;
385  }
386 
387  $this->applyPatch( 'patch-indexes.sql', true, "Updating indexes to 20031107" );
388  }
389 
390  protected function doOldLinksUpdate() {
391  $cl = $this->maintenance->runChild( 'ConvertLinks' );
392  $cl->execute();
393  }
394 
395  protected function doFixAncientImagelinks() {
396  $info = $this->db->fieldInfo( 'imagelinks', 'il_from' );
397  if ( !$info || $info->type() !== 'string' ) {
398  $this->output( "...il_from OK\n" );
399 
400  return;
401  }
402 
403  $applied = $this->applyPatch(
404  'patch-fix-il_from.sql',
405  false,
406  'Fixing ancient broken imagelinks table.'
407  );
408 
409  if ( $applied ) {
410  $this->output( "NOTE: you will have to run maintenance/refreshLinks.php after this." );
411  }
412  }
413 
417  function doWatchlistUpdate() {
418  $talk = $this->db->selectField( 'watchlist', 'count(*)', 'wl_namespace & 1', __METHOD__ );
419  $nontalk = $this->db->selectField(
420  'watchlist',
421  'count(*)',
422  'NOT (wl_namespace & 1)',
423  __METHOD__
424  );
425  if ( $talk == $nontalk ) {
426  $this->output( "...watchlist talk page rows already present.\n" );
427 
428  return;
429  }
430 
431  $this->output( "Adding missing watchlist talk page rows... " );
432  $this->db->insertSelect( 'watchlist', 'watchlist',
433  [
434  'wl_user' => 'wl_user',
435  'wl_namespace' => 'wl_namespace | 1',
436  'wl_title' => 'wl_title',
437  'wl_notificationtimestamp' => 'wl_notificationtimestamp'
438  ], [ 'NOT (wl_namespace & 1)' ], __METHOD__, 'IGNORE' );
439  $this->output( "done.\n" );
440 
441  $this->output( "Adding missing watchlist subject page rows... " );
442  $this->db->insertSelect( 'watchlist', 'watchlist',
443  [
444  'wl_user' => 'wl_user',
445  'wl_namespace' => 'wl_namespace & ~1',
446  'wl_title' => 'wl_title',
447  'wl_notificationtimestamp' => 'wl_notificationtimestamp'
448  ], [ 'wl_namespace & 1' ], __METHOD__, 'IGNORE' );
449  $this->output( "done.\n" );
450  }
451 
453  if ( $this->db->tableExists( 'page', __METHOD__ ) ) {
454  $this->output( "...page table already exists.\n" );
455 
456  return;
457  }
458 
459  $this->output( "...converting from cur/old to page/revision/text DB structure.\n" );
460  $this->output( wfTimestamp( TS_DB ) );
461  $this->output( "......checking for duplicate entries.\n" );
462 
463  list( $cur, $old, $page, $revision, $text ) = $this->db->tableNamesN(
464  'cur',
465  'old',
466  'page',
467  'revision',
468  'text'
469  );
470 
471  $rows = $this->db->query( "
472  SELECT cur_title, cur_namespace, COUNT(cur_namespace) AS c
473  FROM $cur
474  GROUP BY cur_title, cur_namespace
475  HAVING c>1",
476  __METHOD__
477  );
478 
479  if ( $rows->numRows() > 0 ) {
480  $this->output( wfTimestamp( TS_DB ) );
481  $this->output( "......<b>Found duplicate entries</b>\n" );
482  $this->output( sprintf( "<b> %-60s %3s %5s</b>\n", 'Title', 'NS', 'Count' ) );
483  $duplicate = [];
484  foreach ( $rows as $row ) {
485  if ( !isset( $duplicate[$row->cur_namespace] ) ) {
486  $duplicate[$row->cur_namespace] = [];
487  }
488 
489  $duplicate[$row->cur_namespace][] = $row->cur_title;
490  $this->output( sprintf(
491  " %-60s %3s %5s\n",
492  $row->cur_title, $row->cur_namespace,
493  $row->c
494  ) );
495  }
496  $sql = "SELECT cur_title, cur_namespace, cur_id, cur_timestamp FROM $cur WHERE ";
497  $firstCond = true;
498  foreach ( $duplicate as $ns => $titles ) {
499  if ( $firstCond ) {
500  $firstCond = false;
501  } else {
502  $sql .= ' OR ';
503  }
504  $sql .= "( cur_namespace = {$ns} AND cur_title in (";
505  $first = true;
506  foreach ( $titles as $t ) {
507  if ( $first ) {
508  $sql .= $this->db->addQuotes( $t );
509  $first = false;
510  } else {
511  $sql .= ', ' . $this->db->addQuotes( $t );
512  }
513  }
514  $sql .= ") ) \n";
515  }
516  # By sorting descending, the most recent entry will be the first in the list.
517  # All following entries will be deleted by the next while-loop.
518  $sql .= 'ORDER BY cur_namespace, cur_title, cur_timestamp DESC';
519 
520  $rows = $this->db->query( $sql, __METHOD__ );
521 
522  $prev_title = $prev_namespace = false;
523  $deleteId = [];
524 
525  foreach ( $rows as $row ) {
526  if ( $prev_title == $row->cur_title && $prev_namespace == $row->cur_namespace ) {
527  $deleteId[] = $row->cur_id;
528  }
529  $prev_title = $row->cur_title;
530  $prev_namespace = $row->cur_namespace;
531  }
532  $sql = "DELETE FROM $cur WHERE cur_id IN ( " . implode( ',', $deleteId ) . ')';
533  $this->db->query( $sql, __METHOD__ );
534  $this->output( wfTimestamp( TS_DB ) );
535  $this->output( "......<b>Deleted</b> " . $this->db->affectedRows() . " records.\n" );
536  }
537 
538  $this->output( wfTimestamp( TS_DB ) );
539  $this->output( "......Creating tables.\n" );
540  $this->db->query( "CREATE TABLE $page (
541  page_id int(8) unsigned NOT NULL auto_increment,
542  page_namespace int NOT NULL,
543  page_title varchar(255) binary NOT NULL,
544  page_restrictions tinyblob NOT NULL,
545  page_is_redirect tinyint(1) unsigned NOT NULL default '0',
546  page_is_new tinyint(1) unsigned NOT NULL default '0',
547  page_random real unsigned NOT NULL,
548  page_touched char(14) binary NOT NULL default '',
549  page_latest int(8) unsigned NOT NULL,
550  page_len int(8) unsigned NOT NULL,
551 
552  PRIMARY KEY page_id (page_id),
553  UNIQUE INDEX name_title (page_namespace,page_title),
554  INDEX (page_random),
555  INDEX (page_len)
556  ) ENGINE=InnoDB", __METHOD__ );
557  $this->db->query( "CREATE TABLE $revision (
558  rev_id int(8) unsigned NOT NULL auto_increment,
559  rev_page int(8) unsigned NOT NULL,
560  rev_comment tinyblob NOT NULL,
561  rev_user int(5) unsigned NOT NULL default '0',
562  rev_user_text varchar(255) binary NOT NULL default '',
563  rev_timestamp char(14) binary NOT NULL default '',
564  rev_minor_edit tinyint(1) unsigned NOT NULL default '0',
565  rev_deleted tinyint(1) unsigned NOT NULL default '0',
566  rev_len int(8) unsigned,
567  rev_parent_id int(8) unsigned default NULL,
568  PRIMARY KEY rev_page_id (rev_page, rev_id),
569  UNIQUE INDEX rev_id (rev_id),
570  INDEX rev_timestamp (rev_timestamp),
571  INDEX page_timestamp (rev_page,rev_timestamp),
572  INDEX user_timestamp (rev_user,rev_timestamp),
573  INDEX usertext_timestamp (rev_user_text,rev_timestamp)
574  ) ENGINE=InnoDB", __METHOD__ );
575 
576  $this->output( wfTimestamp( TS_DB ) );
577  $this->output( "......Locking tables.\n" );
578  $this->db->query(
579  "LOCK TABLES $page WRITE, $revision WRITE, $old WRITE, $cur WRITE",
580  __METHOD__
581  );
582 
583  $maxold = intval( $this->db->selectField( 'old', 'max(old_id)', '', __METHOD__ ) );
584  $this->output( wfTimestamp( TS_DB ) );
585  $this->output( "......maxold is {$maxold}\n" );
586 
587  $this->output( wfTimestamp( TS_DB ) );
589  if ( $wgLegacySchemaConversion ) {
590  // Create HistoryBlobCurStub entries.
591  // Text will be pulled from the leftover 'cur' table at runtime.
592  $this->output( "......Moving metadata from cur; using blob references to text in cur table.\n" );
593  $cur_text = "concat('O:18:\"historyblobcurstub\":1:{s:6:\"mCurId\";i:',cur_id,';}')";
594  $cur_flags = "'object'";
595  } else {
596  // Copy all cur text in immediately: this may take longer but avoids
597  // having to keep an extra table around.
598  $this->output( "......Moving text from cur.\n" );
599  $cur_text = 'cur_text';
600  $cur_flags = "''";
601  }
602  $this->db->query(
603  "INSERT INTO $old (old_namespace, old_title, old_text, old_comment, old_user,
604  old_user_text, old_timestamp, old_minor_edit, old_flags)
605  SELECT cur_namespace, cur_title, $cur_text, cur_comment, cur_user, cur_user_text,
606  cur_timestamp, cur_minor_edit, $cur_flags
607  FROM $cur",
608  __METHOD__
609  );
610 
611  $this->output( wfTimestamp( TS_DB ) );
612  $this->output( "......Setting up revision table.\n" );
613  $this->db->query(
614  "INSERT INTO $revision (rev_id, rev_page, rev_comment, rev_user,
615  rev_user_text, rev_timestamp, rev_minor_edit)
616  SELECT old_id, cur_id, old_comment, old_user, old_user_text,
617  old_timestamp, old_minor_edit
618  FROM $old,$cur WHERE old_namespace=cur_namespace AND old_title=cur_title",
619  __METHOD__
620  );
621 
622  $this->output( wfTimestamp( TS_DB ) );
623  $this->output( "......Setting up page table.\n" );
624  $this->db->query(
625  "INSERT INTO $page (page_id, page_namespace, page_title,
626  page_restrictions, page_is_redirect, page_is_new, page_random,
627  page_touched, page_latest, page_len)
628  SELECT cur_id, cur_namespace, cur_title, cur_restrictions,
629  cur_is_redirect, cur_is_new, cur_random, cur_touched, rev_id, LENGTH(cur_text)
630  FROM $cur,$revision
631  WHERE cur_id=rev_page AND rev_timestamp=cur_timestamp AND rev_id > {$maxold}",
632  __METHOD__
633  );
634 
635  $this->output( wfTimestamp( TS_DB ) );
636  $this->output( "......Unlocking tables.\n" );
637  $this->db->query( "UNLOCK TABLES", __METHOD__ );
638 
639  $this->output( wfTimestamp( TS_DB ) );
640  $this->output( "......Renaming old.\n" );
641  $this->db->query( "ALTER TABLE $old RENAME TO $text", __METHOD__ );
642 
643  $this->output( wfTimestamp( TS_DB ) );
644  $this->output( "...done.\n" );
645  }
646 
647  protected function doNamespaceSize() {
648  $tables = [
649  'page' => 'page',
650  'archive' => 'ar',
651  'recentchanges' => 'rc',
652  'watchlist' => 'wl',
653  'querycache' => 'qc',
654  'logging' => 'log',
655  ];
656  foreach ( $tables as $table => $prefix ) {
657  $field = $prefix . '_namespace';
658 
659  $tablename = $this->db->tableName( $table );
660  $result = $this->db->query( "SHOW COLUMNS FROM $tablename LIKE '$field'", __METHOD__ );
661  $info = $this->db->fetchObject( $result );
662 
663  if ( substr( $info->Type, 0, 3 ) == 'int' ) {
664  $this->output( "...$field is already a full int ($info->Type).\n" );
665  } else {
666  $this->output( "Promoting $field from $info->Type to int... " );
667  $this->db->query( "ALTER TABLE $tablename MODIFY $field int NOT NULL", __METHOD__ );
668  $this->output( "done.\n" );
669  }
670  }
671  }
672 
673  protected function doPagelinksUpdate() {
674  if ( $this->db->tableExists( 'pagelinks', __METHOD__ ) ) {
675  $this->output( "...already have pagelinks table.\n" );
676 
677  return;
678  }
679 
680  $this->applyPatch(
681  'patch-pagelinks.sql',
682  false,
683  'Converting links and brokenlinks tables to pagelinks'
684  );
685 
687  foreach ( $wgContLang->getNamespaces() as $ns => $name ) {
688  if ( $ns == 0 ) {
689  continue;
690  }
691 
692  $this->output( "Cleaning up broken links for namespace $ns... " );
693  $this->db->update( 'pagelinks',
694  [
695  'pl_namespace' => $ns,
696  "pl_title = TRIM(LEADING {$this->db->addQuotes( "$name:" )} FROM pl_title)",
697  ],
698  [
699  'pl_namespace' => 0,
700  'pl_title' . $this->db->buildLike( "$name:", $this->db->anyString() ),
701  ],
702  __METHOD__
703  );
704  $this->output( "done.\n" );
705  }
706  }
707 
708  protected function doUserUniqueUpdate() {
709  if ( !$this->doTable( 'user' ) ) {
710  return true;
711  }
712 
713  $duper = new UserDupes( $this->db, [ $this, 'output' ] );
714  if ( $duper->hasUniqueIndex() ) {
715  $this->output( "...already have unique user_name index.\n" );
716 
717  return;
718  }
719 
720  if ( !$duper->clearDupes() ) {
721  $this->output( "WARNING: This next step will probably fail due to unfixed duplicates...\n" );
722  }
723  $this->applyPatch( 'patch-user_nameindex.sql', false, "Adding unique index on user_name" );
724  }
725 
726  protected function doUserGroupsUpdate() {
727  if ( !$this->doTable( 'user_groups' ) ) {
728  return true;
729  }
730 
731  if ( $this->db->tableExists( 'user_groups', __METHOD__ ) ) {
732  $info = $this->db->fieldInfo( 'user_groups', 'ug_group' );
733  if ( $info->type() == 'int' ) {
734  $oldug = $this->db->tableName( 'user_groups' );
735  $newug = $this->db->tableName( 'user_groups_bogus' );
736  $this->output( "user_groups table exists but is in bogus intermediate " .
737  "format. Renaming to $newug... " );
738  $this->db->query( "ALTER TABLE $oldug RENAME TO $newug", __METHOD__ );
739  $this->output( "done.\n" );
740 
741  $this->applyPatch( 'patch-user_groups.sql', false, "Re-adding fresh user_groups table" );
742 
743  $this->output( "***\n" );
744  $this->output( "*** WARNING: You will need to manually fix up user " .
745  "permissions in the user_groups\n" );
746  $this->output( "*** table. Old 1.5 alpha versions did some pretty funky stuff...\n" );
747  $this->output( "***\n" );
748  } else {
749  $this->output( "...user_groups table exists and is in current format.\n" );
750  }
751 
752  return;
753  }
754 
755  $this->applyPatch( 'patch-user_groups.sql', false, "Adding user_groups table" );
756 
757  if ( !$this->db->tableExists( 'user_rights', __METHOD__ ) ) {
758  if ( $this->db->fieldExists( 'user', 'user_rights', __METHOD__ ) ) {
759  $this->applyPatch(
760  'patch-user_rights.sql',
761  false,
762  'Upgrading from a 1.3 or older database? Breaking out user_rights for conversion'
763  );
764  } else {
765  $this->output( "*** WARNING: couldn't locate user_rights table or field for upgrade.\n" );
766  $this->output( "*** You may need to manually configure some sysops by manipulating\n" );
767  $this->output( "*** the user_groups table.\n" );
768 
769  return;
770  }
771  }
772 
773  $this->output( "Converting user_rights table to user_groups... " );
774  $result = $this->db->select( 'user_rights',
775  [ 'ur_user', 'ur_rights' ],
776  [ "ur_rights != ''" ],
777  __METHOD__ );
778 
779  foreach ( $result as $row ) {
780  $groups = array_unique(
781  array_map( 'trim',
782  explode( ',', $row->ur_rights ) ) );
783 
784  foreach ( $groups as $group ) {
785  $this->db->insert( 'user_groups',
786  [
787  'ug_user' => $row->ur_user,
788  'ug_group' => $group ],
789  __METHOD__ );
790  }
791  }
792  $this->output( "done.\n" );
793  }
794 
799  protected function doWatchlistNull() {
800  $info = $this->db->fieldInfo( 'watchlist', 'wl_notificationtimestamp' );
801  if ( !$info ) {
802  return;
803  }
804  if ( $info->isNullable() ) {
805  $this->output( "...wl_notificationtimestamp is already nullable.\n" );
806 
807  return;
808  }
809 
810  $this->applyPatch(
811  'patch-watchlist-null.sql',
812  false,
813  'Making wl_notificationtimestamp nullable'
814  );
815  }
816 
822  protected function doPageRandomUpdate() {
823  $page = $this->db->tableName( 'page' );
824  $this->db->query( "UPDATE $page SET page_random = RAND() WHERE page_random = 0", __METHOD__ );
825  $rows = $this->db->affectedRows();
826 
827  if ( $rows ) {
828  $this->output( "Set page_random to a random value on $rows rows where it was set to 0\n" );
829  } else {
830  $this->output( "...no page_random rows needed to be set\n" );
831  }
832  }
833 
834  protected function doTemplatelinksUpdate() {
835  if ( $this->db->tableExists( 'templatelinks', __METHOD__ ) ) {
836  $this->output( "...templatelinks table already exists\n" );
837 
838  return;
839  }
840 
841  $this->applyPatch( 'patch-templatelinks.sql', false, "Creating templatelinks table" );
842 
843  $this->output( "Populating...\n" );
844  if ( wfGetLB()->getServerCount() > 1 ) {
845  // Slow, replication-friendly update
846  $res = $this->db->select( 'pagelinks', [ 'pl_from', 'pl_namespace', 'pl_title' ],
847  [ 'pl_namespace' => NS_TEMPLATE ], __METHOD__ );
848  $count = 0;
849  foreach ( $res as $row ) {
850  $count = ( $count + 1 ) % 100;
851  if ( $count == 0 ) {
852  wfGetLBFactory()->waitForReplication( [ 'wiki' => wfWikiID() ] );
853  }
854  $this->db->insert( 'templatelinks',
855  [
856  'tl_from' => $row->pl_from,
857  'tl_namespace' => $row->pl_namespace,
858  'tl_title' => $row->pl_title,
859  ], __METHOD__
860  );
861  }
862  } else {
863  // Fast update
864  $this->db->insertSelect( 'templatelinks', 'pagelinks',
865  [
866  'tl_from' => 'pl_from',
867  'tl_namespace' => 'pl_namespace',
868  'tl_title' => 'pl_title'
869  ], [
870  'pl_namespace' => 10
871  ], __METHOD__
872  );
873  }
874  $this->output( "Done. Please run maintenance/refreshLinks.php for a more " .
875  "thorough templatelinks update.\n" );
876  }
877 
878  protected function doBacklinkingIndicesUpdate() {
879  if ( !$this->indexHasField( 'pagelinks', 'pl_namespace', 'pl_from' ) ||
880  !$this->indexHasField( 'templatelinks', 'tl_namespace', 'tl_from' ) ||
881  !$this->indexHasField( 'imagelinks', 'il_to', 'il_from' )
882  ) {
883  $this->applyPatch( 'patch-backlinkindexes.sql', false, "Updating backlinking indices" );
884  }
885  }
886 
892  protected function doRestrictionsUpdate() {
893  if ( $this->db->tableExists( 'page_restrictions', __METHOD__ ) ) {
894  $this->output( "...page_restrictions table already exists.\n" );
895 
896  return;
897  }
898 
899  $this->applyPatch(
900  'patch-page_restrictions.sql',
901  false,
902  'Creating page_restrictions table (1/2)'
903  );
904  $this->applyPatch(
905  'patch-page_restrictions_sortkey.sql',
906  false,
907  'Creating page_restrictions table (2/2)'
908  );
909  $this->output( "done.\n" );
910 
911  $this->output( "Migrating old restrictions to new table...\n" );
912  $task = $this->maintenance->runChild( 'UpdateRestrictions' );
913  $task->execute();
914  }
915 
916  protected function doCategorylinksIndicesUpdate() {
917  if ( !$this->indexHasField( 'categorylinks', 'cl_sortkey', 'cl_from' ) ) {
918  $this->applyPatch( 'patch-categorylinksindex.sql', false, "Updating categorylinks Indices" );
919  }
920  }
921 
922  protected function doCategoryPopulation() {
923  if ( $this->updateRowExists( 'populate category' ) ) {
924  $this->output( "...category table already populated.\n" );
925 
926  return;
927  }
928 
929  $this->output(
930  "Populating category table, printing progress markers. " .
931  "For large databases, you\n" .
932  "may want to hit Ctrl-C and do this manually with maintenance/\n" .
933  "populateCategory.php.\n"
934  );
935  $task = $this->maintenance->runChild( 'PopulateCategory' );
936  $task->execute();
937  $this->output( "Done populating category table.\n" );
938  }
939 
940  protected function doPopulateParentId() {
941  if ( !$this->updateRowExists( 'populate rev_parent_id' ) ) {
942  $this->output(
943  "Populating rev_parent_id fields, printing progress markers. For large\n" .
944  "databases, you may want to hit Ctrl-C and do this manually with\n" .
945  "maintenance/populateParentId.php.\n" );
946 
947  $task = $this->maintenance->runChild( 'PopulateParentId' );
948  $task->execute();
949  }
950  }
951 
952  protected function doMaybeProfilingMemoryUpdate() {
953  if ( !$this->doTable( 'profiling' ) ) {
954  return true;
955  }
956 
957  if ( !$this->db->tableExists( 'profiling', __METHOD__ ) ) {
958  return true;
959  } elseif ( $this->db->fieldExists( 'profiling', 'pf_memory', __METHOD__ ) ) {
960  $this->output( "...profiling table has pf_memory field.\n" );
961 
962  return true;
963  }
964 
965  return $this->applyPatch(
966  'patch-profiling-memory.sql',
967  false,
968  'Adding pf_memory field to table profiling'
969  );
970  }
971 
972  protected function doFilearchiveIndicesUpdate() {
973  $info = $this->db->indexInfo( 'filearchive', 'fa_user_timestamp', __METHOD__ );
974  if ( !$info ) {
975  $this->applyPatch( 'patch-filearchive-user-index.sql', false, "Updating filearchive indices" );
976  }
977 
978  return true;
979  }
980 
981  protected function doNonUniquePlTlIl() {
982  $info = $this->db->indexInfo( 'pagelinks', 'pl_namespace' );
983  if ( is_array( $info ) && $info[0]->Non_unique ) {
984  $this->output( "...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE.\n" );
985 
986  return true;
987  }
988  if ( $this->skipSchema ) {
989  $this->output( "...skipping schema change (making pl_namespace, tl_namespace " .
990  "and il_to indices non-UNIQUE).\n" );
991 
992  return false;
993  }
994 
995  return $this->applyPatch(
996  'patch-pl-tl-il-nonunique.sql',
997  false,
998  'Making pl_namespace, tl_namespace and il_to indices non-UNIQUE'
999  );
1000  }
1001 
1002  protected function doUpdateMimeMinorField() {
1003  if ( $this->updateRowExists( 'mime_minor_length' ) ) {
1004  $this->output( "...*_mime_minor fields are already long enough.\n" );
1005 
1006  return;
1007  }
1008 
1009  $this->applyPatch(
1010  'patch-mime_minor_length.sql',
1011  false,
1012  'Altering all *_mime_minor fields to 100 bytes in size'
1013  );
1014  }
1015 
1016  protected function doClFieldsUpdate() {
1017  if ( $this->updateRowExists( 'cl_fields_update' ) ) {
1018  $this->output( "...categorylinks up-to-date.\n" );
1019 
1020  return;
1021  }
1022 
1023  $this->applyPatch(
1024  'patch-categorylinks-better-collation2.sql',
1025  false,
1026  'Updating categorylinks (again)'
1027  );
1028  }
1029 
1030  protected function doLangLinksLengthUpdate() {
1031  $langlinks = $this->db->tableName( 'langlinks' );
1032  $res = $this->db->query( "SHOW COLUMNS FROM $langlinks LIKE 'll_lang'" );
1033  $row = $this->db->fetchObject( $res );
1034 
1035  if ( $row && $row->Type == "varbinary(10)" ) {
1036  $this->applyPatch(
1037  'patch-langlinks-ll_lang-20.sql',
1038  false,
1039  'Updating length of ll_lang in langlinks'
1040  );
1041  } else {
1042  $this->output( "...ll_lang is up-to-date.\n" );
1043  }
1044  }
1045 
1046  protected function doUserNewTalkTimestampNotNull() {
1047  if ( !$this->doTable( 'user_newtalk' ) ) {
1048  return true;
1049  }
1050 
1051  $info = $this->db->fieldInfo( 'user_newtalk', 'user_last_timestamp' );
1052  if ( $info === false ) {
1053  return;
1054  }
1055  if ( $info->isNullable() ) {
1056  $this->output( "...user_last_timestamp is already nullable.\n" );
1057 
1058  return;
1059  }
1060 
1061  $this->applyPatch(
1062  'patch-user-newtalk-timestamp-null.sql',
1063  false,
1064  'Making user_last_timestamp nullable'
1065  );
1066  }
1067 
1068  protected function doIwlinksIndexNonUnique() {
1069  $info = $this->db->indexInfo( 'iwlinks', 'iwl_prefix_title_from' );
1070  if ( is_array( $info ) && $info[0]->Non_unique ) {
1071  $this->output( "...iwl_prefix_title_from index is already non-UNIQUE.\n" );
1072 
1073  return true;
1074  }
1075  if ( $this->skipSchema ) {
1076  $this->output( "...skipping schema change (making iwl_prefix_title_from index non-UNIQUE).\n" );
1077 
1078  return false;
1079  }
1080 
1081  return $this->applyPatch(
1082  'patch-iwl_prefix_title_from-non-unique.sql',
1083  false,
1084  'Making iwl_prefix_title_from index non-UNIQUE'
1085  );
1086  }
1087 
1088  protected function doUserNewTalkUseridUnsigned() {
1089  if ( !$this->doTable( 'user_newtalk' ) ) {
1090  return true;
1091  }
1092 
1093  $info = $this->db->fieldInfo( 'user_newtalk', 'user_id' );
1094  if ( $info === false ) {
1095  return true;
1096  }
1097  if ( $info->isUnsigned() ) {
1098  $this->output( "...user_id is already unsigned int.\n" );
1099 
1100  return true;
1101  }
1102 
1103  return $this->applyPatch(
1104  'patch-user-newtalk-userid-unsigned.sql',
1105  false,
1106  'Making user_id unsigned int'
1107  );
1108  }
1109 
1110  protected function doRevisionPageRevIndexNonUnique() {
1111  if ( !$this->doTable( 'revision' ) ) {
1112  return true;
1113  } elseif ( !$this->db->indexExists( 'revision', 'rev_page_id' ) ) {
1114  $this->output( "...rev_page_id index not found on revision.\n" );
1115  return true;
1116  }
1117 
1118  if ( !$this->db->indexUnique( 'revision', 'rev_page_id' ) ) {
1119  $this->output( "...rev_page_id index already non-unique.\n" );
1120  return true;
1121  }
1122 
1123  return $this->applyPatch(
1124  'patch-revision-page-rev-index-nonunique.sql',
1125  false,
1126  'Making rev_page_id index non-unique'
1127  );
1128  }
1129 
1130  public function getSchemaVars() {
1132 
1133  $vars = [];
1134  $vars['wgDBTableOptions'] = str_replace( 'TYPE', 'ENGINE', $wgDBTableOptions );
1135  $vars['wgDBTableOptions'] = str_replace(
1136  'CHARSET=mysql4',
1137  'CHARSET=binary',
1138  $vars['wgDBTableOptions']
1139  );
1140 
1141  return $vars;
1142  }
1143 }
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these but it might have such a feature in the future We handle these by creating a deferred update object and putting those objects on a global list
Definition: deferred.txt:11
doWatchlistUpdate()
Check if we need to add talk page rows to the watchlist.
doUserNewTalkUseridUnsigned()
doMaybeProfilingMemoryUpdate()
$IP
Definition: WebStart.php:58
applyPatch($path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Class for handling database updates.
doBacklinkingIndicesUpdate()
output($str)
Output some text.
when a variable name is used in a it is silently declared as a new local masking the global
Definition: design.txt:93
const NS_TEMPLATE
Definition: Defines.php:66
this hook is for auditing only RecentChangesLinked and Watchlist RecentChangesLinked and Watchlist e g Watchlist & $tables
Definition: hooks.txt:1007
The index of the header message $result[1]=The index of the body text message $result[2 through n]=Parameters passed to body text message.Please note the header message cannot receive/use parameters. 'ImportHandleLogItemXMLTag':When parsing a XML tag in a log item.Return false to stop further processing of the tag $reader:XMLReader object $logInfo:Array of information 'ImportHandlePageXMLTag':When parsing a XML tag in a page.Return false to stop further processing of the tag $reader:XMLReader object &$pageInfo:Array of information 'ImportHandleRevisionXMLTag':When parsing a XML tag in a page revision.Return false to stop further processing of the tag $reader:XMLReader object $pageInfo:Array of page information $revisionInfo:Array of revision information 'ImportHandleToplevelXMLTag':When parsing a top level XML tag.Return false to stop further processing of the tag $reader:XMLReader object 'ImportHandleUploadXMLTag':When parsing a XML tag in a file upload.Return false to stop further processing of the tag $reader:XMLReader object $revisionInfo:Array of information 'ImportLogInterwikiLink':Hook to change the interwiki link used in log entries and edit summaries for transwiki imports.&$fullInterwikiPrefix:Interwiki prefix, may contain colons.&$pageTitle:String that contains page title. 'ImportSources':Called when reading from the $wgImportSources configuration variable.Can be used to lazy-load the import sources list.&$importSources:The value of $wgImportSources.Modify as necessary.See the comment in DefaultSettings.php for the detail of how to structure this array. 'InfoAction':When building information to display on the action=info page.$context:IContextSource object &$pageInfo:Array of information 'InitializeArticleMaybeRedirect':MediaWiki check to see if title is a redirect.&$title:Title object for the current page &$request:WebRequest &$ignoreRedirect:boolean to skip redirect check &$target:Title/string of redirect target &$article:Article object 'InternalParseBeforeLinks':during Parser's internalParse method before links but after nowiki/noinclude/includeonly/onlyinclude and other processings.&$parser:Parser object &$text:string containing partially parsed text &$stripState:Parser's internal StripState object 'InternalParseBeforeSanitize':during Parser's internalParse method just before the parser removes unwanted/dangerous HTML tags and after nowiki/noinclude/includeonly/onlyinclude and other processings.Ideal for syntax-extensions after template/parser function execution which respect nowiki and HTML-comments.&$parser:Parser object &$text:string containing partially parsed text &$stripState:Parser's internal StripState object 'InterwikiLoadPrefix':When resolving if a given prefix is an interwiki or not.Return true without providing an interwiki to continue interwiki search.$prefix:interwiki prefix we are looking for.&$iwData:output array describing the interwiki with keys iw_url, iw_local, iw_trans and optionally iw_api and iw_wikiid. 'InvalidateEmailComplete':Called after a user's email has been invalidated successfully.$user:user(object) whose email is being invalidated 'IRCLineURL':When constructing the URL to use in an IRC notification.Callee may modify $url and $query, URL will be constructed as $url.$query &$url:URL to index.php &$query:Query string $rc:RecentChange object that triggered url generation 'IsFileCacheable':Override the result of Article::isFileCacheable()(if true) &$article:article(object) being checked 'IsTrustedProxy':Override the result of IP::isTrustedProxy() &$ip:IP being check &$result:Change this value to override the result of IP::isTrustedProxy() 'IsUploadAllowedFromUrl':Override the result of UploadFromUrl::isAllowedUrl() $url:URL used to upload from &$allowed:Boolean indicating if uploading is allowed for given URL 'isValidEmailAddr':Override the result of Sanitizer::validateEmail(), for instance to return false if the domain name doesn't match your organization.$addr:The e-mail address entered by the user &$result:Set this and return false to override the internal checks 'isValidPassword':Override the result of User::isValidPassword() $password:The password entered by the user &$result:Set this and return false to override the internal checks $user:User the password is being validated for 'Language::getMessagesFileName':$code:The language code or the language we're looking for a messages file for &$file:The messages file path, you can override this to change the location. 'LanguageGetMagic':DEPRECATED!Use $magicWords in a file listed in $wgExtensionMessagesFiles instead.Use this to define synonyms of magic words depending of the language &$magicExtensions:associative array of magic words synonyms $lang:language code(string) 'LanguageGetNamespaces':Provide custom ordering for namespaces or remove namespaces.Do not use this hook to add namespaces.Use CanonicalNamespaces for that.&$namespaces:Array of namespaces indexed by their numbers 'LanguageGetSpecialPageAliases':DEPRECATED!Use $specialPageAliases in a file listed in $wgExtensionMessagesFiles instead.Use to define aliases of special pages names depending of the language &$specialPageAliases:associative array of magic words synonyms $lang:language code(string) 'LanguageGetTranslatedLanguageNames':Provide translated language names.&$names:array of language code=> language name $code:language of the preferred translations 'LanguageLinks':Manipulate a page's language links.This is called in various places to allow extensions to define the effective language links for a page.$title:The page's Title.&$links:Associative array mapping language codes to prefixed links of the form"language:title".&$linkFlags:Associative array mapping prefixed links to arrays of flags.Currently unused, but planned to provide support for marking individual language links in the UI, e.g.for featured articles. 'LanguageSelector':Hook to change the language selector available on a page.$out:The output page.$cssClassName:CSS class name of the language selector. 'LinkBegin':DEPRECATED!Use HtmlPageLinkRendererBegin instead.Used when generating internal and interwiki links in Linker::link(), before processing starts.Return false to skip default processing and return $ret.See documentation for Linker::link() for details on the expected meanings of parameters.$skin:the Skin object $target:the Title that the link is pointing to &$html:the contents that the< a > tag should have(raw HTML) $result
Definition: hooks.txt:1934
wfTimestamp($outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
doRestrictionsUpdate()
Adding page_restrictions table, obsoleting page.page_restrictions.
wfGetLB($wiki=false)
Get a load balancer object.
doUserNewTalkTimestampNotNull()
Mysql update list and mysql-specific update functions.
doRevisionPageRevIndexNonUnique()
$res
Definition: database.txt:21
wfWikiID()
Get an ASCII string identifying this wiki This is used as a prefix in memcached keys.
$wgDBTableOptions
MySQL table options to use during installation or update.
indexHasField($table, $index, $field)
Check whether an index contain a field.
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition: distributors.txt:9
doInterwikiUpdate()
Check that interwiki table exists; if it doesn't source it.
doWatchlistNull()
Make sure wl_notificationtimestamp can be NULL, and update old broken items.
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition: injection.txt:35
wfGetLBFactory()
Get the load balancer factory object.
linkcache txt The LinkCache class maintains a list of article titles and the information about whether or not the article exists in the database This is used to mark up links when displaying a page If the same link appears more than once on any page then it only has to be looked up once In most cases link lookups are done in batches with the LinkBatch class or the equivalent in so the link cache is mostly useful for short snippets of parsed and for links in the navigation areas of the skin The link cache was formerly used to track links used in a document for the purposes of updating the link tables This application is now deprecated To create a you can use the following $titles
Definition: linkcache.txt:17
checkBin($table, $field, $patchFile)
1.4 betas were missing the 'binary' marker from logging.log_title, which causes a collation mismatch ...
$wgLegacySchemaConversion
If set to true, the MediaWiki 1.4 to 1.5 schema conversion will create stub reference rows in the tex...
this class mediates it Skin Encapsulates a look and feel for the wiki All of the functions that render HTML and make choices about how to render it are here and are called from various other places when and is meant to be subclassed with other skins that may override some of its functions The User object contains a reference to a and so rather than having a global skin object we just rely on the global User and get the skin with $wgUser and also has some character encoding functions and other locale stuff The current user interface language is instantiated as and the local content language as $wgContLang
Definition: design.txt:56
doFilearchiveIndicesUpdate()
$count
updateRowExists($key)
Helper function: check if the given key is present in the updatelog table.
doCategorylinksIndicesUpdate()
doPageRandomUpdate()
Set page_random field to a random value where it is equals to 0.
Look for duplicate user table entries and optionally prune them.
Definition: userDupes.inc:35
doIndexUpdate()
Check that proper indexes are in place.
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
Definition: hooks.txt:2159
const TS_DB
MySQL DATETIME (YYYY-MM-DD HH:MM:SS)
Definition: defines.php:16
do that in ParserLimitReportFormat instead use this to modify the parameters of the image and a DIV can begin in one section and end in another Make sure your code can handle that case gracefully See the EditSectionClearerLink extension for an example zero but section is usually empty its values are the globals values before the output is cached $page
Definition: hooks.txt:2491
doTable($name)
Returns whether updates should be executed on the database table $name.
Allows to change the fields on the form that will be generated $name
Definition: hooks.txt:300