Possible problems and solutions after MySQL server upgrade
Categories / cPanel, MySQL By DotRoll
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
Categories / cPanel, MySQL By DotRoll
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, [...]
