phpmysqlvtiger

Unexpected error connecting vtiger with mysql

I am currently getting this error in vtiger installation wizard (step 4).

MySQL Server should be configured with:  
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

I am using shared PHP 7.2 MySQL 5.7 hosting and adminer says that sql_mode is set to

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Here comes the question
Is this behaviour really related to sql_mode setting? Do I have to contact my hosting provider or there is there an override?

Solution

  • Connecting to a new mariadb 10 database solved the problem.

    Changing MySQL version to <5.7 as stated in comments should therefore work as well.