Fix vTiger on mysql that requires set options.

Changes.md

You can change the mysql config to apply the set options.

sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

However this is not always desireable on shared hosting you don't know the follow on effects.

So far, I've found I can simply set this in the installer and the db connection class.

include/database/PearDatabase.php Search for function connect

Apply this code under the if for isdb_default_utf8_charset

                        if($this->isdb_default_utf8_charset) {
                                $this->executeSetNamesUTF8SQL(true);
                        }
                        if ($this->dbType === 'mysql') {
                                $this->database->Execute("SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'");
                        }

And for the installer

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'");

The condition is not always true (I think based on the PHP version and therefore the MySQL connection libraries), so you need to add this other condition as well:

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

Fair enough, was not in my particular use-case but thanks @raksati sorry if you have to deal with vTiger it can be a pain :D