[Vtigercrm-developers] recommended sql_mode

Prasad prasad at vtiger.com
Sun Jan 16 15:15:19 GMT 2022


It's covered here
<https://code.vtiger.com/vtiger/vtigercrm-manual/wikis/Administration-Docs>.

On Thu, Jan 13, 2022 at 11:25 PM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
wrote:

> Is there a chance we could add a "recommended configuration" section to
> the wiki, with a table indicating php versions, mysql versions, sql_mode,
> etc... for each vtiger version? I feel that the advice of "leave it empty"
> is kind of like saying "set all files and folder permissions  to 777".
>
> I make this request every once in a while ;)
>
> Saludos
>
> Rubén
>
>
> On Thu, Jan 13, 2022 at 11:40 AM Prasad <prasad at vtiger.com> wrote:
>
>> sql_mode flag can vary over versions (5.7
>> <https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html> vs 8.0
>> <https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html>).
>>
>> empty should make it work.
>>
>> There are some flag to which we need to make the product compatible (
>> follow <https://code.vtiger.com/vtiger/vtigercrm/issues/202>)
>>
>>    - STRICT_TRANS_TABLES
>>    - ONLY_FULL_GROUP_BY
>>    - NO_ZERO_IN_DATE
>>    - NO_ZERO_DATE
>>
>> Regards,
>> Prasad
>>
>> On Mon, Jan 10, 2022 at 10:43 PM Rubén A. Estrada Orozco <
>> rulotec1 at gmail.com> wrote:
>>
>>> 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
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220116/0080faa1/attachment.html>


More information about the vtigercrm-developers mailing list