How to fix the issue with SQL_Mode?

Answered Stas K. 7 years ago

On MYSQL 5.7 there could be an error on system installation with sql_mode=only_full_group_by

Replies (1)

photo
1

In order to fix the error permanently, you would need to edit my.cnf file using root access to the server with SSH.


Normally this file is located here in Ubuntu, Debian - /etc/mysql/my.cnf

Make sure that in the file there is following line [mysqld]

After that line add

  1. sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

This would remove sql_mode only_full_group_by that prevents UseResponse to work correctly.

Then in console restart mysql if you are in Ubuntu (without sudo if on Debian)

  1. sudo service mysql restart

Leave a Comment
 
Attach a file