Changes

Data quality checks before upgrading to V6.0

547 bytes added, 13:04, 7 April 2015
no edit summary
===Attachment table (mandatory)===__NOEDITSECTION__
If the database was created with an early version of {{IMSMANG}} the name of the column ''Filedescription'' might be written without leading '''capital''' F. If there are old {| class="wikitable"! colspan="4" | Old tables like these:* |-| width="100pt"| hazreducmarkinginfo* | injury| qamethodinfo| vegetationinfo|-| width="100pt"| hazreducmarkinginfoversion* | injuryversion| qamethodinfoversion| vegetationinfoversion|-| width="100pt"| hazreducmethodinfo* | markinginfo| suitableforinfo||-| width="100pt"| hazreducmethodinfoversion* markinginfo|markinginfoversion| suitableforinfoversion* markinginfoversion|* suitableforinfo|}* suitableforinfoversion If there are old tables like these in the database then there is a high likelihood that the column name is wrong!These tables were used for storage of multi-select values before tables like hazard_has_imsmaenum were introduced. The upgrade functionality will '''not''' remove these old tables during upgrade and it is recommended to delete them manually before upgrade due to that they may cause upgrade errors.
Check the table design with Navicat and if necessary update the name of the column to leading capital F [[Attachment SQL |(query)]].
6,632
edits