Possible problems and solutions after MySQL server upgrade

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, [...]

Possible problems and solutions after MySQL server upgrade

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, [...]