Have a Question?

Categories

Possible problems and solutions after MySQL server upgrade

You are here:
< All topics
Table of contents

If you encounter an error message similar to the following during the operation that you want to perform on the MySQL server:

Field 'field_name' doesn't have a default value

Then we recommend that you run the following query after building a MySQL connection:

Up to PHP version 5.7 you should use the following code:

mysql_query("SET SESSION sql_mode = ''");

From PHP version 7.0 or higher, you should use the following line of code:

mysqli_query("SET SESSION sql_mode = ''");
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we correct this article?
Please submit the reason for your vote so that we can improve the article.
Previous Install and run Python Django using cPanel
Next Possible problems and solutions after MySQL server upgrade