[ZBXNEXT-4644] Web display window data error Created: 2018 Jul 19  Updated: 2024 Apr 10  Resolved: 2018 Jul 19

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F)
Affects Version/s: 3.4.11
Fix Version/s: None

Type: Change Request Priority: Major
Reporter: Roger Tang Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: mysql, web
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7.4
Zabbix 3.4
mysql-community-server 8.0.11-1.e17.x86_64
php 5.4.16

Attachments: PNG File error.png    
Issue Links:
Duplicate
is duplicated by ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.... Closed
Team: Team A

 Description   

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]

 

 Comments   
Comment by Alexey Pustovalov [ 2018 Jul 19 ]

Zabbix 3.4 does not support MySQL 8.0: https://www.zabbix.com/documentation/3.4/manual/installation/requirements

Generated at Thu Apr 25 00:02:28 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.