Fix vtiger not able to save field changes.

PearDatabase-fix.php

<?php
if ($this->dbType === 'mysql' || $this->dbType === 'mysqli') {
  $this->database->Execute("SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'");
}

// Either in the mysql config or if you don't want to touch it there you can edit the include/database/PearDatabase.php and put that statement at the bottom of the function connect.

// And for setup

// Edit the 
// modules/Install/models/Utils.php
// After the mysql_server_version = self::getMySQLVersion($serverInfo);

// Put this to set the options for the sql mode for the session.

$conn->Execute("SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'");