Health Check Error: Field has incorrect display_default value

Overview

The Health Check wizard must be run when upgrading in order to evaluate your instance's ability to move to the target version. During the health check, various types of issues may be detected which can affect your ability to upgrade. This article will cover how to resolve a "Field has incorrect display_default value" error reported by the health check.

Symptoms

This error generates an output similar to the following in health check:

Resolution

The generated error message will help determine the contents of the file causing the health check error.

Breakdown of health check error:

• The health check detects an issue with the custom date field (test_date_c) in the Accounts module with an incorrect display_default value of -none-.  

To address this error, the custom field's default value will need to be changed to an empty value. Use one of the following methods to resolve this issue:

• The first method is to update the default value directly in the database. In this example, the following query can be run in the database:

  UPDATE fields_meta_data SET default_value = NULL WHERE name = 'test_date_c' AND custom_module = 'Accounts';

• The second method is to navigate to Admin > Studio to re-save the custom field(s) causing the error. In this example, you will navigate to Admin > Studio > Accounts > Fields and locate the custom date field (test_date_c). Select the field to edit, then click the Save button without making any changes.

Once the necessary change has been made, navigate to Admin > Repair in Sugar and perform a "Quick Repair and Rebuild". Then, perform the health check again to confirm that the error is no longer reported.