Channel Field not saving
How Do I?
8 years ago
Hi All, We upgraded to EE 2.9.2 awhile back (and everything seemed fine) and now I went to add a new channel field and nothing I do will cause it to save.
the error i’m getting is:
A Database Error Occurred
Error Number: 1364
Field 'ff_settings' doesn't have a default value
INSERT INTO `exp_channel_fields` (`site_id`, `group_id`, `field_name`, `field_label`, `field_instructions`, `field_type`, `field_list_items`, `field_pre_populate`, `field_pre_channel_id`, `field_pre_field_id`, `field_ta_rows`, `field_maxl`, `field_required`, `field_text_direction`, `field_search`, `field_is_hidden`, `field_fmt`, `field_show_fmt`, `field_order`, `field_settings`) VALUES ('1', '27', 'terst2', 'terst2', 'iut dqwiuqw', 'text', '', 0, 0, 0, '6', '128', 'y', 'ltr', 'y', 'n', 'none', 'n', '1', 'YTo3OntzOjE4OiJmaWVsZF9jb250ZW50X3R5cGUiO3M6NzoibnVtZXJpYyI7czoxODoiZmllbGRfc2hvd19zbWlsZXlzIjtzOjE6InkiO3M6MTk6ImZpZWxkX3Nob3dfZ2xvc3NhcnkiO3M6MToieSI7czoyMToiZmllbGRfc2hvd19zcGVsbGNoZWNrIjtzOjE6InkiO3M6MjY6ImZpZWxkX3Nob3dfZm9ybWF0dGluZ19idG5zIjtzOjE6Im4iO3M6MjQ6ImZpZWxkX3Nob3dfZmlsZV9zZWxlY3RvciI7czoxOiJ5IjtzOjIwOiJmaWVsZF9zaG93X3dyaXRlbW9kZSI7czoxOiJuIjt9')
Filename: libraries/api/Api_channel_fields.php
Line Number: 1444Any ideas?
thanks in advance
Pete
8 years ago
Hi Pete,
Hmm,ff_settings isn’t a standard/native column on that database table, which leads me to think that an add-on may have added it. The best solution is to figure out what added that column and how it is being used, and the quickest solution is to use a tool like phpMyAdmin and edit that column so it will accept NULL values (or edit it to have a default value).