MySQL has a strict mode in 5.7 as a default option. If you updated the Mysql to this version, your old version PHP apps maybe been broken.
On MySQL 5.7, the default values for this key are:
The strict mode comes from STRICT_TRANS_TABLES. So, let’s overwrite the sql_mode and set it to be the same as the default, but without strict mode.
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
add the following line on section [mysqld]
That’s it! Save the file, and restart MySQL.
- [ January 30, 2018 ] How to install and config Termux on Android 5.x or later
- [ January 30, 2018 ] Automatically enable HTTPS on your website with EFF's Certbot
- [ January 29, 2018 ] Wireless network management in Raspberry Pi
- [ January 28, 2018 ] Install pycharm by Ubuntu make
- [ December 22, 2016 ] Deploying Django Apps with mod_wsgi on Ubuntu 16.04
- [ December 19, 2016 ] Top Things to do after Ubuntu 16.04 Installation
- [ December 19, 2016 ] Setting up Vim for Python
- [ December 19, 2016 ] PHP5.2 Parse error: syntax error, unexpected T_FUNCTION
- [ December 19, 2016 ] Automatically enable HTTPS on your website with EFF's Certbot
- [ December 15, 2016 ] How to install php5.6 on Ubuntu 16.04