MySQL ERROR: Error Number: 1364 Description: Field 'whatever' doesn't have a default value

Question

Firstable, I´m  designer, hence my ignorance.
It´s been awhile since I didn´t updated a site. The client asked me to make a new member in EE. I´ve been able always to do that on the spot, but this time I always get the SQL error of the email subject (1364). After some researching, I tried to publish some entry and I got the same SQL error.

Then i found this post here
Database Error 1364 in Solspace Calendar

The point is that i´m not sure if I have to adding a default value (0) to all the tables or there is a way to do that for the whole site.

Thank you in advance

Michael McGhee · Answer

Hmm, I had this error on a site recently and I fixed it by removing strict mode from MySQL.

https://stackoverflow.com/questions/37964325/how-to-find-and-disable-mysql-strict-mode

^ That has some information on the matter. I'm not sure what your current setup is but the update is fairly standard. Find the cnf file, remove "STRICT_TRANS_TABLES" from the string and save, then restart MySQL.

MySQL ERROR: Error Number: 1364 Description: Field 'whatever' doesn't have a default value

One Answer

Add your own answers!

Ask a Question