I’ve a column with the option $col[“isnull”] = true;
In default edit mode this works fine, if I put 0 in the dialog box the NULL value is inserted into the database.
But unfortunately this not works in bulkedit mode and with the csv import function. With the csv import function the value 0 is inserted into the database (I also tried to put NULL in the csv, but the result is that in the database is written the text NULL and not the NULL value)
In bulkedit instead if I put 0, this is totally ignored a there are no changes.
There is any solution or workaround? Thanks
Both issues are resolved and updated files emailed to you.
I tested your fix, it works well for bulkedit but not for csv import.
The fields with isnull options are recognized correctly but there is some problem with the insert query
I checked the mysql log and the query is like:
INSERT INTO test (field1,field2,field3) VALUES (”,’10’,’2019-02-10′)
When it should be
INSERT INTO test (field1,field2,field3) VALUES (null,’10’,’2019-02-10′)
Make sure you update step3.php in lib/inc/import. I verified it before sending. Please confirm.
Emailed you update that should fix import case.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?