Hi everyone, just checked this with my server people and infact that was the problem. Strict mode enabled from a minor cPanel upgrade. Hope will help others with the same issue:

Hi Walter,

I have checked this issue further and it seems that some minor cPanel upgrade process run in the server created a MySQL CNF over-ride file that re-enabled the STRICT mode. I have now turned off the the mysql STRICT mode.

root@pandora [/home]# mysql -e 'select @@GLOBAL.sql_mode;'
+------------------------+
| @@GLOBAL.sql_mode |
+------------------------+
| NO_ENGINE_SUBSTITUTION |
+------------------------+

Could you please have a check now.