Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘openboxes.tag.id’

[jmiranda]

This error occurs when loading the dashboard on instances using MySQL 5.7+. By default, MySQL 5.7+ has disabled the ability to include columns in the SELECT clause that are not also in the GROUP BY clause.

https://stackoverflow.com/questions/48147294/error-sqlexceptionhelper146-expression-7-of-select-list-is-not-in-group-by-c

The bug should be easy to fix and will be included in an upcoming release, but you can use the following workaround in the meantime.

1. Log into MySQL as root
2. Execute the following statement

mysql> show variables like '%sql_mode%';
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                                     |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

3. Copy the value removing ONLY_FULL_GROUP_BY
4. Edit /etc/mysql/mysql.cnf
5. Paste sql_mode value without ONLY_FULL_GROUP_BY to the bottom of the file

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION