How to Disable Strict SQL Mode in MySQL 5.7

If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.7, you can disable strict SQL mode. For example, apps such as WHMCS 6 and Craft 2 do not support strict SQL mode. If you’re using WHMCS 7, see our article on customizing MySQL for […]

Customizing MySQL for WHMCS 7

The WHMCS 7 documentation currently does not state which MySQL 5.7 sql_mode customizations need to be made. This article is based on feedback we’ve heard from users about how they have successfully gotten WHMCS 7 working. If you’re using WHMCS 6, use the instructions in our article on disabling SQL strict mode. As WHMCS 7 […]