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',''));
Africa : Zimbabwe, South Africa, Kenya, Tanzania, Nigeria, Egypt | South
Asia : Bangladesh, Bhutan, Maldives, Nepal, Srilanka | South East Asia :Cambodia,
Indonesia, Malaysia, Philippines, Singapore, Thailand, Vietnam | Middle East : Iran,
Jordan, Oman, Qatar, Saudi Arabia, UAE, Yemen, Bahrain, Kuwait, Turkey | Europe : Austria,
Germany, Denmark, Ukraine, Portugal, United Kingdom, Netherlands, Croatia | North America :
United States, Canada, Mexico | Central America : Caribbean Islands, Dominican Republic.