I saw your Group By Query on this forum. I can help you in resolving the issue.
Your issue can be very easily solved by just changing your sql mode in the MySQL by below command:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
After this command you need to restart the MySql Service.
This worked for me too.I had used this as my project was having many Group By Queries so I simply changed the sql mode to the only_full_group_by
Now the MySQL's only_full_group_by mode is turned on by you, it means that the strict ANSI SQL rules will now apply when you will try to use GROUP BY. With reference to your query,it means that if you try to GROUP BY of a proof_type column, then you can only select below two things:
First is the proof_type column, or
Second is the aggregates of any other column.