Direct DB connection does not work with ONLY_FULL_GROUP_BY option enabled

[ghost]

If ONLY_FULL_GROUP_BY MySQL option enabled, queries fail. This option is enabled by default since MySQL 5.7.5.

Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.

[alexanderzobnin]

Can you describe an error you get?

[ghost]

no error as such. I just don't see any data on the default zabbix demo dashboard when the direct DB connection is enabled.

[adisong]

SQL queries generated by grafana-zabbix plugin fails if you have ONLY_FULL_GROUP_BY sql mode enabled on your db. https://stackoverflow.com/questions/23921117/disable-only-full-group-by

[ghost]

Sweet. Thanks for that, I tired it and it worked! Thank you so much.

[ghost]

Thanks guys for the help.

[alexanderzobnin]

@inkonthebrink @nayra123 reopened it with new description.

[alexanderzobnin]

ONLY_FULL_GROUP_BY description:
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by

[alexanderzobnin]

Fixed in 35f89bf