Using maintenance script "rebuildFulltextSearchTable.php" with the the --v parameter

From semantic-mediawiki.org
Jump to: navigation, search
MaintenanceScriptMaintenanceScript/RebuildFulltextSearchTableUsing maintenance script "rebuildFulltextSearchTable.php" with the the --v parameter
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.