How toTurn Off SQL MODE only_full_group_by


  • | 461 points

    I use codeigniter 3.1.9 to do project. But there is a database problem. I can not completely turn off sql mode only_full_group_by. I used phpmyadmin to stop but after every reboot laragon, only_full_group_by mode is automatically turned on.
    "Error Number: 1055
    Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigproject.site_log.access_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"


  • administrators
    | 115064 points

    @đoàn-nguyễn-phạm : Just add this to my.ini:

    sql_mode=only_full_group_by
    

  • | 461 points

    @leokhoa hello leokhoa. I just updated to the latest version 4.0.16. however, I got the error that only_full_group_by could not be turned off. Despite having sql_mode in my.ini file, it will remain the same after reboot. I have using phpmyadmin to set it up but this way is only temporary. Rebooting is lost. laragon doesn't recognize sql_mode configuration in my.ini file


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.