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 create duplicate enumvalues and therefore the current values must be documented [[Imsmaenum Duplicate fix | query]];
# Take backup;
# How many rows is 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 the duplicate enumvalues [[Imsmaenum Duplicate fix | query]];
# Stop TrayLauncher;
# Start TrayLauncher;