I am working with an add-on that does an insert into a custom member data field and I am getting the following kind of error:
A Database Error Occurred Error Number: 1364 Field 'm_field_id_2' doesn't have a default value
My EE install is currently at 2.5.2 and it was upgraded from EE 1.6.9. In checking the
exp_member_data table in database I can see that none of the custom field columns are set up with default values or allowed to be set to NULL. This includes even custom fields I set up after upgrading.
My questions are:
- Is it default behaviour for EE to create new
exp_member_datacolumns to not allow NULL and to have no default set? Seems like it shouldn't be.
- Did something happen to my
exp_member_datatable in my upgrade so it is not set up correctly for EE2?
- Am I safe to simply set the columns in the
exp_member_datatable to allow NULLS and set the default value to NULL?