EDIT

Updatescript for TermVocabularies of OrderedTerms which are not OrderedVocabularies.

See also https://dev.e-taxonomy.eu/redmine/issues/4821#note-8

===

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.