===Published templates===__NOEDITSECTION__
There might be templates that are created with an old version of {{IMSMANG}} and may contain errors that have been undetected in 5.08.04 but will not be working with V6.0. There are countries that have several hundred unused published templates. In order to avoid upgrade problems it is recommended to
# delete unused published templates '''[[Used DEF template SQL |(query)]]'''.
# discuss with the country if some of the used published templates should be switched together [[Used DEF template SQL |(query)]]
# check the names of the remaining templates for odd characters like @ #
<li> The upgrade scripts will '''wrongly''' change enumvalues to Inactive and therefore the current values must be documented [[Imsmaenum Duplicate fix | query]]
<li> The upgrade script will change ''Location point'' to ''Reference point'', run this [[Location point | query]] '''before''' and '''after''' the upgrade.
<li> The upgrade scripts do not handle the subobjects that should be transformed into normal multi-selects well (2014-11-25/NAA).
Run these [[Check Detection Sample Sector VegetationRemoval | queries]] in order to see if there are any records that have to be inserted manually.
<li> How many rows are there in the attachment table? If more than 0, then you have to verify that the attachments are included in the backup folder or instruct the country on how to handle them.