Getting below error while creating sales order
Erpnext Version 12.6
pymysql.err.InternalError: (1364, “Field ‘against_blanket_order’ doesn’t have a default value”)
Earlier it was working fine. Even I have setup new site on same server with same code base, there also sales order is working fine.
I am not sure why one one erpsite which is mine production is facing this issues. All test sites are working fine.
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
above line in my.cnf has fixed the issue