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 Értékelés 0%
4 Értékelés 0%
3 Értékelés 0%
2 Értékelés 0%
1 Értékelés 0%
How can we correct this article?
Please submit the reason for your vote so that we can improve the article.