TermVocabularies of OrderedTerms must be OrderedVocabularies
Updatescript for TermVocabularies of OrderedTerms which are not OrderedVocabularies.
Otherwise the terms of the following types need to be unordered (see #7340)
Therefore the following script needs to run for them:
UPDATE TermVocabulary SET DTYPE = 'TermVocabulary' WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO'); UPDATE DefinedTermBase SET orderIndex = NULL WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO');
Also we may want to set the uri and some iso fields to NULL where empty (see #7445):
UPDATE DefinedTermBase SET uri = null WHERE Trim(uri) = ''; UPDATE DefinedTermBase SET iso639_1 = null WHERE Trim(iso639_1) = ''; UPDATE DefinedTermBase SET iso3166_A2 = null WHERE Trim(iso3166_A2) = ''; UPDATE TermVocabulary SET uri = null WHERE Trim(uri) = '';
I did run these scripts on production, integration and test.