Looks like the mysql version on the new server is 5.6 vs 5.5 and the sql mode of the new server is

-> STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

I will implement the fix and post if any other issues occur.

Thanks Dr B and MC