NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
This query should be exported as documentation of the values of the four affected enum categoriesenumcategories:
<pre>
SELECT DISTINCT
imsmaenum.enumvalue ASC
</pre>
The upgrade scripts wrongly add values to the four enumcategories so duplicates are created. The upgrade scripts also sets some of the existing enumvalues to '''inactive'''. 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 enumvalue1.png | 350px]] <br/>
''Example of enumcategory with duplicates(Query 1)'' <br/> <br/>
[[Image: Duplicate enumvalue2.png | 1000px]] <br/>
# Open table '''imsmaenum''' with Navicat and sort on '''enumcategory'''# Compare the result set from '''before''' the upgrade scripts with current records# Delete the new rows, in the example created with user '''migration''', by selecting the row and clicking on delete button# Set '''isactive''' to t (TRUE) on the old rows if the country had them as active in 5.08.04# Repeat 2- 4 until all are done and run Query 2 as double-check of no duplicates remain.
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]