codeigniter Error Code: 1055 incompatible with sql_mode=only_full_group_by
In this post we will show you codeigniter Error Code: 1055 incompatible with sql_mode=only_full_group_by, hear for codeigniter Error Code: 1055 incompatible with sql_mode=only_full_group_by we will give you demo and example for implement.
for solution of codeigniter Error Code: 1055 or error number 1055 codeigniter or this is incompatible with sql_mode=only_full_group_by codeigniter or error 1055 amazon or sql error 1055 sqlstate 42000 or mysql nonaggregated column or gisq game date >’ isn t in group by or 1055 sql error or how to disable only_full_group_by you can apply this solution.
how to fix this you need this problem
you have to remove “only_full_group_by” in sql_mode.
or
if sql mode is not exist then add this line
set sql_mode=''; set global sql_mode=''; set session sql_mode='';
for xampp
go to xampp\mysql\bin\my.ini
for lamp
go to /etc/mysql/my.cnf
Hope this code and post will helped you for implement codeigniter Error Code: 1055 incompatible with sql_mode=only_full_group_by. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve onlincode. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs onlincode.org
