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

zabbix server log: ERROR 1064 (42000) 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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 3.4.9
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:

      Description

      newly installed zabbix 3.4  on centos 8, with newly installed mysql 8. there is no error during the installation process, but launch the zabbix server, I got the error from log zabbix_server.log:

      1213:20180517:084357.744 [Z3005] 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]

      I got erro when execute the [select gourpid,name from groups] in mysql, but  [select gourpid,name from `groups`] can be executed in mysql, so I wonder whether the compatibility between zabbix-server-mysql and mysql8 no good.

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                yvv yvv
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: