Hi @mosswalker 🙂 ONLY_FULL_GROUP_BY is specified in Indigo's MySQL config file. You'll need to override that file and remove that option.
1. Locate the clean MySQL config file:
The original config files for mysql are inside the App bundle. The following path is for MySQL 8.3 (your version may be slightly different.)
Indigo.app/Contents/Resources/Services/mysql/8.3.0_1/conf/my.cnf
The contents of that file look like this:
# The MySQL Client configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[mysql]
prompt=indigo>
[client]
socket = "{{sock_file}}"
[mysqld]
basedir="{{service_path}}"
datadir="{{dataDirectory}}"
port = "{{port}}"
socket = "{{sock_file}}"
pid-file = "{{pid_file}}"
default_authentication_plugin = mysql_native_password
sql-mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
character-set-server = utf8mb4
max_allowed_packet = {{max_allowed_packet}}
# Only allow connections from localhost
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
2. Override your stack's MySQL config
You need to override your stack's MySQL config using this file as per the docs — let me know if you get stuck; I fully acknowledge the process is ugly right now.
The relevant config is:
sql-mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
In your override, you simply need to remove the ONLY_FULL_GROUP_BY, option.
Let me know how you go — I'm more than happy to provide more detail on any part of the process.