[Vtigercrm-developers] recommended sql_mode

[Rubén A. Estrada Orozco]

Hi everyone,

I have been using

sql_mode =
"ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

on some vtiger instances for a few months without problems. After
installing a third party extension (its4you), I notice they have a
"requirement" of setting it to an empty value or to
"NO_ENGINE_SUBSTITUTION".

My question is, what are the benefits/downsides of each option and which
one is the "optimal" configuration?

Doing a quick search on the repository, I could only find this related
issue opened by Alan Lord:
https://code.vtiger.com/vtiger/vtigercrm/issues/1640



Saludos

Rubén
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220110/8b1c1bd9/attachment.html>