NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
This query (Query X) lists the duplicate enumvalues created after the upgrade scripts.
<pre>
SELECT imsmaenum.enumcategory,
The upgrade scripts add new values to the enumcategories e.g. ''CHA''. Since all countries may have different duplicates and different options set to inactive there is no fit-all solution and therefore the duplicates enumvalues are best fixed manually. <br/><br/>
[[Image: Duplicate enumvalue3.png | 300px]]<br/>
''Example of enumcategory with duplicates (Query X)'' <br/> <br/>
[[Image: Duplicate enumvalue2.png | 700px]] <br/><br/>
# Compare the result set from '''before''' the upgrade scripts with current records
# If necessary set ''isactive'' to t (TRUE) on the old rows if the country had them as Active in 5.08.04 and delete the new rows.
# Repeat 3 - 4 until all are done and run Query 2 the query again as double-check of no duplicates remain.
{{NavBox Upgrade}}
