[Vtigercrm-developers] recommended sql_mode

[Rubén A. Estrada Orozco]

Exactly Martin. php 5.2 does not even work for vtiger 5.4. It's pretty
misleading. What vtiger version do they apply for?
That's why I've been suggesting a table, having the requirements for each
vtiger version. It comes in handy, for example when you are updating a
vtiger from a very old version. At some point you have to switch php
versions.

Another observation is that the hardware requirements are huge for small
instances. I have clients running on servers with 1RAM 1CPU 25GB SD.

Saludos

Rubén


On Mon, Jan 17, 2022 at 2:25 AM Martin Allen <martin.allen at exe-squared.co.uk>
wrote:

> 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> 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/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220117/a5fa6cc0/attachment.html>