[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 Created: 2018 May 17 Updated: 2018 May 17 Resolved: 2018 May 17 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 3.4.9 |
| Fix Version/s: | None |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | yvv | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
centos7, mysql-community-server-8.0.11-1.el7.x86_64, got zabbix from zabbix yum (zabbix-release-3.4-2.el7.noarch.rpm ), |
||
| Attachments: |
image-2018-05-17-08-50-57-988.png
zabbix_server.log
|
||||||||
| Issue Links: |
|
||||||||
| 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.
|
| Comments |
| Comment by Andrei Gushchin (Inactive) [ 2018 May 17 ] |
|
This probably duplicates the |
| Comment by yvv [ 2018 May 17 ] |
|
ok |
