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]]: Duplicate enumvalues cause import issues i.e. empty fields, which are difficult to detect due to there are no error messages);
# 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.
