error-related-to-only-full-group-by-when-executing-a-query-in-mysql

Go to phpmyadmin click table and go to SQL query paste this below and go

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));