How toTurn Off SQL MODE only_full_group_by
-
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"
-
@đoàn-nguyễn-phạm : Just add this to
my.ini
:sql_mode=only_full_group_by
-
@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