NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
#:* error message ''COPY fieldreportdesc'' means that it was not possible to load the table so the table is '''empty''';
#:* 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;
# The upgrade scripts will '''wrongly''' change enumvalues to inactive and might create duplicate enumvalues Inactive 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.
[[Image:Upgrade_func.png|400px]]<br/><br/>
If you are upgrading from MySQL there is 110 upgrade scripts to be applied. When the upgrade process is finished:
# Check if the upgrade scripts '''wrongly'' changed created duplicate enumvalues to Inactive and if necessary fix them ('''mandatory''');# Check if the upgrade scripts created duplicate enumvalues ([[Imsmaenum Duplicate fix Part 2| query]] and );#: Duplicate enumvalues cause import issues i.e. empty fields, which are difficult to detect due to there are no error messages;# Check if necessary fix them the upgrade scripts '''wrongly''' changed enumvalues to Inactive ('''mandatory''')([[Inactive enumvalue fix | query ]]);
# Due to mistyping there is one mistake in enumvalue and translation for ''Wind Speed'' [[Translation fix | more details]];
# Stop TrayLauncher;
