bug #6343
Updated by Andreas Müller almost 6 years ago
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: ~~~ sql 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 to NULL where empty (see #7445): empty: ~~~ sql UPDATE TermVocabulary SET uri = NULL WHERE uri = ''; UPDATE DefinedTermBase SET uri = NULL WHERE uri = ''; ~~~ I did run these scripts on production, integration and test.