While working on WHMCS I was not able to generate tickets
I found out issue was due to mysql being in strict mode
I tried disabling mysql strict mode by adding entries in /etc/my.cnf
sql_mode=””
However it didnt work out.
I have found that there is a /usr/my.cnf file that is enabling strict mode on server.
This file contained the following:
====
sql_mode=NO_ENGINE_
====
I removed the STRICT_TRANS_TABLES option and saved the file. All that is left is to restart the MySQL server. You can do this at your convenience with the following command:
====
/scripts/restartsrv_mysql
====
Once it is restarted, strict mode should be disabled.