mysql server disable only_full_group_by (enable only_full_group_by) login phpmyadmin ROOT copy code SET sql_mode = ”; to menu sql Go copy code SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”)); to menu sql GO Test sql GROUP BY code