[Vtigercrm-developers] recommended sql_mode

[Martin Allen]

Although the version requirements in this document are pretty much useless – writing PHP 5.2+, 7.2+ does not help anyone, as It means that ALL versions of PHP since 5.2 will work – which is not true (8.0 / 8.1??). Should explicitly write the versions that it has been tested / designed for.

From: vtigercrm-developers-bounces at lists.vtigercrm.com <vtigercrm-developers-bounces at lists.vtigercrm.com> On Behalf Of Prasad
Sent: 16 January 2022 15:15
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] recommended sql_mode

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<mailto: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<mailto: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<mailto: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/20220117/3b74318b/attachment-0001.html>