zabbix dashboard Error in query

[ibelieve]

Hi,

I just installed zabbix-server-mysql and zabbix-web-mysql ,the version is 3.4.3, i visited the zabbix frontend and there are many error on pages,

Error in query [SELECT g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status='0' AND g.groupid=hg.groupid)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=' at line 1]

Error in query [SELECT g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status='0' AND g.groupid=hg.groupid)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=' at line 1]

This error should be the "groups" forgot to add backticks, the groups is mysql reserved words and needs to using backticks

is it a bug ?

[kaspars.mednis]

Hello !

Which mysql version are you using ?

Regards,
Kaspars

[ibelieve]

Hello !

Which mysql version are you using ?

Regards,
Kaspars

my mysql version is
/usr/sbin/mysqld Ver 8.0.3-rc-log for Linux on x86_64 (MySQL Community Server (GPL))

[kaspars.mednis]

MySQL 8.0.3 is not officially released yet, it's is a release candidate

Sorry to say that, but MySQL 8 is not officially supported by zabbix at this moment.

Are there any particualr reasons to use MySQL 8.0.3 ? Maybe you can use last stable version of MySQL 5.7 on this instance, and move to MySQL 8 as soon as it becomes officially released ?

Regards,
Kaspars

[zabbixadmin_newbie]

Hi,

MySQL 8.0 has now been officially released but I am getting the same error when I access my frontend dashboard GUI. Any update to this thread?