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.