title: Painfully set the sql_mode for vtiger
body: <p>I couldn't figure out what Vtiger was on about when it asked me to set the php.ini file to <code>error_reporting</code>. Even after the error_reporting had been edited to show; </p>
  
  <p><code>error_reporting = E_WARNING &amp; ~E_NOTICE &amp; ~E_DEPRECATED &amp; ~E_STRICT</code></p>
  
  <p>The CRM still persists in telling me it requires resetting, no matter how many time I restarted apache with <code>sudo apachectl restart</code></p>
  
  <p>Anyway...</p>
  
  <p>After moving on, I managed to get to add the database, which at first, looks straight forward, but beware! There's one more huddle to get over before you can successfully install.</p>
  
  <p>You'll probably receive the command to add:</p>
  
  <pre><code> sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  </code></pre>
  
  <p>Big headache!!</p>
  
  <p>firstly, Mac OS X 10.13.* running MySQL mysql-5.7.21-macos10.13-x86_64 doesn't own /my.cnf and if like me, you're MySQL file will probably be stored in usr/local/mysql/bin/.</p>
  
  <p>Stop looking, you wont find it anywhere on your Mac...</p>
  
  <p>But there is light at the end of this tunnel... </p>