Try ERPNext Buy Support Partners Foundation

Sales Order Error - against_blanket_order

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