MySQLi error 1364:

[chadlly2003]

I am trying to do an import using easy populate, but for some reason I am getting this error. i did just upgrad to php 7.3 o that might have something to do with the error. If someone could assist me that would be great

- Zencart 1.5.6
- Module Easy Populate 4.0.36.ZC
- Php 7.3


I believe the file in question might be Admin/easypopulate_4_import.php

error

MySQLi error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description SET 
categories_id   = 3759,
language_id     = 1,
categories_name = 'Battery Straps'

[lat9]

I suggest that you post in the EZ-Populate support thread.

[chadlly2003]

i figured it out. I went to the terminal and edited the cnf file


change this sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

to this
sql_mode=