Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4644

Web display window data error

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.4.11
    • Frontend (F)
    • 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]

       

            Unassigned Unassigned
            rtanglife Roger Tang
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: