How to fix the issue with SQL_Mode?

Answered Stas K. 8 years ago

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

Replies (1)

photo
10

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
Your vote is accepted!