NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
#:* error message ''ERROR: insert or update on table "fieldreport" violates foreign key constraint "fieldreport_fieldreportdesc_guid_fkey'' means mandatory reference between tables did not work because of missing values in e.g. imsmaenum table;
# Apply the ''fix imsmaenum Foreign Key constraints'' [[Imsmaenum FK fix | script]] ('''first''' time);
# The upgrade scripts will might create duplicate enumvalues and therefore the current values must be documented [[Imsmaenum Duplicate fix | query]]
#: Duplicate enumvalues cause import issues i.e. empty fields, which are difficult to detect due to there are no error messages);
# 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.
If you are upgrading from MySQL there is 106 upgrade scripts to be applied. When the upgrade process is finished:
# Apply the ''fix imsmaenum Foreign Key constraints'' [[Imsmaenum FK fix | script]] ('''second''' time);
# Fix Check if the upgrade scripts created duplicate enumvalues [[Imsmaenum Duplicate fix Part 2| query]]and if necessary fix them ('''mandatory''');
# Due to mistyping there is one mistake in enumvalue and translation for ''Wind Speed'' [[Translation fix | more details]];
# Stop TrayLauncher;