Disable MySQL strict mode!
We recently migrated WHMCS to latest CentOS 7 server with cPanel. The WHMCS ClientArea showed White screen when “Client logins were used”. We found that the server had MySQL strict mode enabled which was causing this problem.
I disabled MySQL strict mode as below :
Edited /usr/my.cnf and changed below value :
Restarted MySQL :
voila this worked…… earlier I was trying to change sql_mode under /etc/my.cnf however found MySQL is using different location /usr/my.cnf