SQL Errors fixation
Managing and fixing SQL Server errors
Some of the database servers are not compadible with our recommended settings therefore you need to run a SQL query manually in to your server. below is the code just copy paste and make sure it has been applied. 01. Login to your WHM panel as a ( ROOT ) 02. Go through phpmyadmin 03. Select your database table 04. Click on SQL tab from navigation 05. paste below code and hit go and you are done.
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));