f you want to disable permanently error "Expression #N of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db.table.COL' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" do those steps:

    1. sudo nano /etc/mysql/my.cnf
    2. Add this to the end of the file

    3. sudo service mysql restart to restart MySQL

    This will disable ONLY_FULL_GROUP_BY for ALL users

    Tags: ,
    © 201 René Frick. All Rights Reserved. Designed By Rcomputer

    Please publish modules in offcanvas position.