Details

    • Type: Change Request
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.4.11
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Centos 7.4
      Zabbix 3.4
      mysql-community-server 8.0.11-1.e17.x86_64
      php 5.4.16
    • 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]

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rtanglife Roger Tang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: