Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-14598

–Error in query [SELECT g.groupid,g.name FROM groups g...

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • None
    • None
    • CentOS Linux release 7.4.1708 (Core);
      mysql-community-server-8.0.11-1.el7.x86_64;
      zabbix_server (Zabbix) 3.4.11 Revision 82160;

    Description

      Steps to reproduce:

      1. After installed mysql and Zabbix-server, once start Zabbix-server;
      2. tail -f /var/log/zabbix/zabbix_server.log ==>
      3. ... query failed: [1064] 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' at line 1 .[+select groupid,name from groups+]..
      4. i've run " mysql -uzabbix -p " to query manually, the same error. The "groups" looks like keyword. i have to use "select groupid,name from zabbix.groups";

      Result:
      See screenshot...
      Expected:

      Attachments

        1. zabbix_query.PNG
          zabbix_query.PNG
          29 kB
        2. zabbix-screen.PNG
          zabbix-screen.PNG
          138 kB
        3. zabbix-server_log.PNG
          zabbix-server_log.PNG
          21 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              WeiZhang Wei Zhang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: