The field ‘Address 2 - Type’ is set as NOT NULL and does not have a default value.
Field ‘Address 2 - Formatted’ doesn’t have a default value
Which preferences should be set to solve imported issue?
Need help.
It’s a bit difficult to tell with so little information (such as your database table layout and a sample of the data you’re trying to import into it), but a thought:
This states that the column must contain something (it’s not allowed to be null), and you’re trying to import a blank field into it. Because you don’t have a default value, your database engine (whichever it is) is rejecting the row.
Either set a default value, or allow the column to contain null.
Please find the following settings:
Null is Yes Default is NULL
Which settings should be to import without an issue?
The error message suggests that Null is No. If it’s actually yes, I don’t know what the issue is. Can you do a SHOW CREATE TABLE tablename and post the results?
make sure every column is nullable (i.e. do ~not~ specify NOT NULL)
whether you specify a default value is up to you
It is working now.
NULL is Yes
Default is NULL
Thank you for the message.