<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">sql_mode flag can vary over versions (<a href="https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html">5.7</a> vs <a href="https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html">8.0</a>). </div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">empty should make it work.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div>There are some flag to which we need to make the product compatible<span class="gmail_default" style="font-family:arial,helvetica,sans-serif"> (<a href="https://code.vtiger.com/vtiger/vtigercrm/issues/202">follow</a>)</span><br><ul><li><span class="gmail_default" style="font-family:arial,helvetica,sans-serif"></span>STRICT_TRANS_TABLES</li><li>ONLY_FULL_GROUP_BY</li><li><span style="background-color:transparent;color:inherit;font-family:Menlo,"Liberation Mono",Consolas,"DejaVu Sans Mono","Ubuntu Mono","Courier New","andale mono","lucida console",monospace;font-size:inherit">NO_ZERO_IN_DATE</span></li><li><span style="background-color:transparent;color:inherit;font-family:Menlo,"Liberation Mono",Consolas,"DejaVu Sans Mono","Ubuntu Mono","Courier New","andale mono","lucida console",monospace;font-size:inherit">NO_ZERO_DATE</span></li></ul><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Regards,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Prasad</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 10, 2022 at 10:43 PM Rubén A. Estrada Orozco <<a href="mailto:rulotec1@gmail.com">rulotec1@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi everyone,<div><br></div><div>I have been using </div><div><br></div><div>sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</div><div><br></div><div>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".</div><div><br></div><div>My question is, what are the benefits/downsides of each option and which one is the "optimal" configuration?</div><div><br></div><div>Doing a quick search on the repository, I could only find this related issue opened by Alan Lord: <a href="https://code.vtiger.com/vtiger/vtigercrm/issues/1640" target="_blank">https://code.vtiger.com/vtiger/vtigercrm/issues/1640</a></div><div><br></div><div><br></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr">Saludos<div><br></div><div>Rubén</div></div></div></div></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>