-
Change Request
-
Resolution: Duplicate
-
Major
-
None
-
3.4.11
-
Centos 7.4
Zabbix 3.4
mysql-community-server 8.0.11-1.e17.x86_64
php 5.4.16
Hi Admin,
Today, I tried to build a new zabbix environment, but login to the Web console after the discovery of the following module this error,
I suspect that the MySQL database, how to deal with?
Thanks in advance!
Web monitoring/System status/Host status
error info :
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]
- is duplicated by
-
ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0
- Closed