Have a Question?

Kategóriák

Possible problems and solutions after MySQL server upgrade

Itt van:
< Minden téma
Tartalomjegyzék

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.
Előző Possible problems and solutions after MySQL server upgrade
Következő Setup Tortoise SVN