Skip to content

Translation
Translation
Open
Opened by darren.woods@darren.woods
Report abuse New issue

Unable to add new custom field set or new fields (to existing field set) after enabling multilingual setting.

Reproduced on demo site https://dmaster.demo.civicrm.org/ running 5.24.alpha1 and also 5.21.1

  1. Settings - Localization - enable Multilingual setting.
  2. Custom Data - Add set of custom fields.
  3. Enter "Set Name" and select "Used For", click "Save"

Error returned:-

Database Error Code: Field of view 'dmastercivi_g5lis.civicrm_custom_group_en_US' underlying table doesn't have a default value, 1423

Additional Details: ` Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO `civicrm_custom_group_en_US` (`name` , `title` , `extends` , `extends_entity_column_id` , `extends_entity_column_value` , `style` , `collapse_display` , `help_pre` , `help_post` , `weight` , `is_active` , `is_multiple` , `max_multiple` , `created_id` , `created_date` , `is_public` ) VALUES ('test' , 'test' , 'Contact' ,  NULL ,  NULL , 'Inline' ,  1 , '' , '' ,  6 ,  1 ,  0 ,  NULL ,  203 ,  20200305111654 ,  1 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_group_en_US' underlying table doesn't have a default value]
[type] => DB_Error
[user_info] => INSERT INTO `civicrm_custom_group_en_US` (`name` , `title` , `extends` , `extends_entity_column_id` , `extends_entity_column_value` , `style` , `collapse_display` , `help_pre` , `help_post` , `weight` , `is_active` , `is_multiple` , `max_multiple` , `created_id` , `created_date` , `is_public` ) VALUES ('test' , 'test' , 'Contact' ,  NULL ,  NULL , 'Inline' ,  1 , '' , '' ,  6 ,  1 ,  0 ,  NULL ,  203 ,  20200305111654 ,  1 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_group_en_US' underlying table doesn't have a default value]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO `civicrm_custom_group_en_US` (`name` , `title` , `extends` , `extends_entity_column_id` , `extends_entity_column_value` , `style` , `collapse_display` , `help_pre` , `help_post` , `weight` , `is_active` , `is_multiple` , `max_multiple` , `created_id` , `created_date` , `is_public` ) VALUES ('test' , 'test' , 'Contact' ,  NULL ,  NULL , 'Inline' ,  1 , '' , '' ,  6 ,  1 ,  0 ,  NULL ,  203 ,  20200305111654 ,  1 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_group_en_US' underlying table doesn't have a default value]"]

) `

Also unable to add new fields to existing sets.

  1. Open exiting field set
  2. Click "Add custom field"
  3. Enter Label
  4. Click "Save"

Error details:-

Database Error Code: Field of view 'dmastercivi_g5lis.civicrm_custom_field_en_US' underlying table doesn't have a default value, 1423

Additional Details:

`Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO `civicrm_custom_field_en_US` (`custom_group_id` , `name` , `label` , `data_type` , `html_type` , `default_value` , `is_required` , `is_searchable` , `is_search_range` , `weight` , `help_pre` , `help_post` , `is_active` , `is_view` , `options_per_line` , `text_length` , `start_date_years` , `end_date_years` , `date_format` , `time_format` , `note_columns` , `note_rows` , `column_name` , `option_group_id` , `filter` , `in_selector` ) VALUES ( 7 , 'test' , 'test' , 'String' , 'Text' ,  NULL ,  NULL ,  NULL ,  0 ,  2 ,  NULL ,  NULL ,  1 ,  NULL ,  NULL ,  255 ,  NULL ,  NULL ,  NULL ,  NULL ,  60 ,  4 , 'test' ,  NULL ,  NULL ,  0 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_field_en_US' underlying table doesn't have a default value]
[type] => DB_Error
[user_info] => INSERT INTO `civicrm_custom_field_en_US` (`custom_group_id` , `name` , `label` , `data_type` , `html_type` , `default_value` , `is_required` , `is_searchable` , `is_search_range` , `weight` , `help_pre` , `help_post` , `is_active` , `is_view` , `options_per_line` , `text_length` , `start_date_years` , `end_date_years` , `date_format` , `time_format` , `note_columns` , `note_rows` , `column_name` , `option_group_id` , `filter` , `in_selector` ) VALUES ( 7 , 'test' , 'test' , 'String' , 'Text' ,  NULL ,  NULL ,  NULL ,  0 ,  2 ,  NULL ,  NULL ,  1 ,  NULL ,  NULL ,  255 ,  NULL ,  NULL ,  NULL ,  NULL ,  60 ,  4 , 'test' ,  NULL ,  NULL ,  0 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_field_en_US' underlying table doesn't have a default value]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO `civicrm_custom_field_en_US` (`custom_group_id` , `name` , `label` , `data_type` , `html_type` , `default_value` , `is_required` , `is_searchable` , `is_search_range` , `weight` , `help_pre` , `help_post` , `is_active` , `is_view` , `options_per_line` , `text_length` , `start_date_years` , `end_date_years` , `date_format` , `time_format` , `note_columns` , `note_rows` , `column_name` , `option_group_id` , `filter` , `in_selector` ) VALUES ( 7 , 'test' , 'test' , 'String' , 'Text' ,  NULL ,  NULL ,  NULL ,  0 ,  2 ,  NULL ,  NULL ,  1 ,  NULL ,  NULL ,  255 ,  NULL ,  NULL ,  NULL ,  NULL ,  60 ,  4 , 'test' ,  NULL ,  NULL ,  0 )  [nativecode=1423 ** Field of view 'dmastercivi_g5lis.civicrm_custom_field_en_US' underlying table doesn't have a default value]"]

)`

The one place for your designs

To enable design management, you'll need to meet the requirements. If you need help, reach out to our support team for assistance.