Using maintenance script "rebuildFulltextSearchTable.php" with the the --v parameter
From semantic-mediawiki.org
| Maintenance script example | |
|---|---|
This page shows an example on how to use maintenance script "rebuildFulltextSearchTable.php" with the the --v parameter.
| |
| Script | |
| Keywords | |
The following command rebuilds the database table used for the full-text search feature prompting elaborate progress information.
- Shell command
php rebuildFulltextSearchTable.php --v
- Prompt shown
The script rebuilds the search index from property tables that
support a fulltext search. Any change of the index rules (altered
stopwords, new stemmer etc.) and/or a newly added or altered table
requires to run this script again to ensure that the index complies
with the rules set forth by the DB or Sanitizer.
- ICU (Intl) PHP-extension 52.1
- Tesa::Sanitizer 0.2
- Tesa::Transliterator 0.2
- Tesa::LanguageDetector (disabled)
The following properties are exempted from the fulltext search index.
- _ASKFO, _ASKST, _IMPO, _LCODE, _UNIT, _CONV, _TYPE, _ERRT, __sil_iwl_lang
- __sil_ill_lang
The entire index table is going to be purged first and
it may take a moment before the rebuild is completed due to
dependencies on table content and selected options.
Abort the rebuild with control-c in the next five seconds ... 0
The index table was purged.
Rebuilding the text index from (rows finished/expected):
- smw_di_blob 100% (895/895)
- smw_di_uri 100% (71/71)
- smw_fpt_pval 100% (91/91)
- smw_fpt_list 100% (4/4)
- smw_fpt_serv 100% (1/1)
- smw_fpt_text 100% (47/47)
- smw_fpt_dtitle 100% (48/48)
- smw_fpt_media 100% (13/13)
- smw_fpt_mime 100% (13/13)
- smw_fpt_sci_cite_key 100% (65/65)
- smw_fpt_sci_cite_reference 100% (66/66)
- smw_fpt_sci_cite_text 100% (65/65)
- smw_fpt_sci_doi 100% (9/9)
- smw_fpt_sci_pmcid 100% (12/12)
- smw_fpt_sci_pmid 100% (2/2)
Table(s) not used for indexing:
- smw_di_number Not a blob or URI table type.
- smw_di_bool Not a blob or URI table type.
- smw_di_time Not a blob or URI table type.
- smw_di_coords Not a blob or URI table type.
- smw_di_wikipage Not a blob or URI table type.
- smw_fpt_type Fixed property table that belongs to the _TYPE exempted property.
- smw_fpt_unit Fixed property table that belongs to the _UNIT exempted property.
- smw_fpt_conv Fixed property table that belongs to the _CONV exempted property.
- smw_fpt_prec Not a blob or URI table type.
- smw_fpt_ask Not a blob or URI table type.
- smw_fpt_askde Not a blob or URI table type.
- smw_fpt_asksi Not a blob or URI table type.
- smw_fpt_askfo Fixed property table that belongs to the _ASKFO exempted property.
- smw_fpt_askst Fixed property table that belongs to the _ASKST exempted property.
- smw_fpt_askdu Not a blob or URI table type.
- smw_fpt_subp Not a blob or URI table type.
- smw_fpt_subc Not a blob or URI table type.
- smw_fpt_inst Not a blob or URI table type.
- smw_fpt_redi Not a blob or URI table type.
- smw_fpt_sobj Not a blob or URI table type.
- smw_fpt_impo Fixed property table that belongs to the _IMPO exempted property.
- smw_fpt_uri Empty table.
- smw_fpt_conc Not a blob or URI table type.
- smw_fpt_lcode Fixed property table that belongs to the _LCODE exempted property.
- smw_fpt_mdat Not a blob or URI table type.
- smw_fpt_cdat Not a blob or URI table type.
- smw_fpt_newp Not a blob or URI table type.
- smw_fpt_ledt Not a blob or URI table type.
- smw_fpt_sci_cite Not a blob or URI table type.
- smw_fpt_sci_oclc Empty table.
- smw_fpt_sci_viaf Empty table.
- smw_fpt_sci_olid Empty table.
- smw_ftp_sesp_revid Not a blob or URI table type.
- smw_ftp_sesp_pageid Not a blob or URI table type.
- smw_ftp_sesp_euser Not a blob or URI table type.
- smw_ftp_sesp_cuser Not a blob or URI table type.
- smw_ftp_sesp_subp Not a blob or URI table type.
- smw_ftp_sesp_nrev Not a blob or URI table type.
- smw_ftp_sesp_ntrev Not a blob or URI table type.
- smw_ftp_sesp_userreg Not a blob or URI table type.
- smw_ftp_sesp_usereditcnt Not a blob or URI table type.
- smw_ftp_sesp_exifdata Not a blob or URI table type.
