[Vtigercrm-developers] recommended sql_mode

[Rubén A. Estrada Orozco]

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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220113/73c689dc/attachment.html>