Maintenance script "update­Entity­Collation.php"

Allows to do mass updates of database field "smw_sort" on the occasion that setting for the entity collation was changed
Further Information
Provided by: Semantic MediaWiki
Added: 3.0.0
Removed: still in use
Location (path): ./extensions/SemanticMediaWiki/maintenance/
Table of Contents

The "updateEntityCollation.php" maintenance script allows mass updates of database field "smw_sort" on the occasion that the setting of configuration parameter $smwgEntityCollationSets which collation entities in Semantic MediaWiki should sort with was changed. The maintenance script was introduced in Semantic MediaWiki 3.0.0Released on 11 October 2018 and compatible with MW 1.27.0 - 1.31.x..1

Semantic MediaWiki 3.2.0Released on 7 September 2020 and compatible with MW 1.31.0 - 1.35.x. brought an improved client output to this maintenance script.2


php updateEntityCollation.php


Maintenance scripts provide generic maintenance parameters, script dependent parameters and depending on the maintenance script script specific parameters which are described on this page if provided.

This script does not provide any script specific parameters.


The following command updates the entity collation of the "smw_sort" field.
php updateEntityCollation.php
[ Notes ]

- $smwgEntityCollation              uca-default-u-kn
- $wgCategoryCollation              numeric

The setting of $smwgEntityCollation and $wgCategoryCollation are different
and may result in an inconsitent sorting display for entities.

[ Update ]

- Selecting rows ...                1 to 100659
- Updating the smw_sort field ...     0% (313/100659)


  1. ^  Semantic MediaWiki: GitHub pull request gh:smw:2429
  2. ^  Semantic MediaWiki: GitHub pull request gh:smw:4552