Error 500 after login on new install V3.3.9 about opensourcepos

[SidSkiba]

I was able to get it to startup with MySQL V5.7.44 but I had to make the following entry under [mysqld] in the my.ini file:

sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

This is apparently undesirable practice but it worked.

[jekkos]

Ah the good old only_full_group_by
Maybe we can try to set this config from the application directly, in case it detect MySQL.

[jekkos]

related to #2819, it's probably best to get rid of the only_full_group_by and review the logic to work properly.

[SidSkiba]

I verified it worked to disable only_full_group_by under MySQL V8.0 but I had to use a slightly different modification in my.ini:

sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

but if the query could be fixed it would be better.

[jsiddall]

I also got caught by this issue running on Ubuntu 20.04 which has MySQL 8.0 and can confirm that the sql-mode setting documented by @SidSkiba above works. Would be nice if this were already fixed, or perhaps better documented.