Sql_mode = ERROR_FOR_DIVISION_BY_ZERO,

SYSTEM INFORMATION
OS type and version Debian
Webmin version REQUIRED
Virtualmin version REQUIRED
Related packages SUGGESTED

can not install vtiger due to mysql errort

sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

“sql_mode = ERROR_FOR_DIVISION_BY_ZERO” is a configuration setting in MySQL that specifies the behavior of the database when a division by zero error occurs.

When this mode is enabled, MySQL will raise an error and abort the statement if a division by zero occurs. This can help prevent unexpected or incorrect results from being returned by the query.

However, it is important to note that enabling this mode may cause some queries that worked previously to fail, so it should be used with caution. It may also impact the performance of the database, since extra error checking and handling is required.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.