Mysql Field ” doesn’t have a default value

“error: Field ‘description’ doesn’t have a default value”

We updated our Mysql database from 5.6 to 5.7 in September 2019 due to the faster 5.7 Mysql engine… the transition went well without any issues. I was expecting the worse, but it did not occur.

02/21/2020: Our server updated our Cpanel version which also must have updated some additional files in our server because our scripts stopped working with Mysql due to errors as described on the next line.

“error: Field ‘description’ doesn’t have a default value”

We never had this problem with version MySql 5.6 or earlier versions.

I am listing the method utilized to correct the issue below just in case others may be suffering the same unfortunate event…

I have included this help page for anyone that may be in need of help for this specific issue, and since most server administrators are novices when compared to software engineers, IT professionals, MIT Grads and/or dropouts, or other technology veterans, please withhold judgments as to best practices… but please provide your comments below for additional methods or additional methods to resolve such issues. Thanks.

The solution is fast and takes less than an hour… 5 minutes maybe.

SSH into root/etc/ and edit my.cnf file.

add a new line >> sql_mode = ‘NO_ENGINE_SUBSTITUTION’ << save the file. >> Restart Mysql Server

That’s it! Your scripts should work without the error popping up.

There is a lot of info concerning the “Mysql Field ” doesn’t have a default value” in Google land and it’s easy to get lost in the thousands of pages and suggestions.

Google search links for the similar and same issue: https://www.google.com/search?q=my.cnf+sql_mode%3D&oq=my.cnf++sql_mode%3D&aqs=chrome..69i57.8151j0j8&sourceid=chrome&ie=UTF-8

To help locate the file, read:
http://ronaldbradford.com/blog/how-do-i-identify-the-mysql-my-cnf-file-2010-03-09/

To log into your server with SSH, and if you are in need of the tool to utilize: Do a google search for pUTTY or WinScp. I prefer WinScp

Do a google search for winscp:
https://www.google.com/search?ei=GHpRXtCILIzktQWKtJXoCQ&q=winscp&oq=winscp&gs_l=psy-ab.3..0i273j0i67j0i131i67j0i7i30j0i67j0i7i30j0j0i67l3.6767.7318..8234…0.2..0.143.339.1j2……0….1..gws-wiz…….0i71j0i8i30.9DdPXF7pF1g&ved=0ahUKEwjQ9K7q6-XnAhUMcq0KHQpaBZ0Q4dUDCAs&uact=5

[adinserter name=”Block 1″]

Leave a Reply

Your email address will not be published. Required fields are marked *