[ZBXNEXT-4662] [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] Created: 2018 Aug 01 Updated: 2018 Aug 01 Resolved: 2018 Aug 01 |
|
| Status: | Closed |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Installation (I) |
| Affects Version/s: | 3.4.12 |
| Fix Version/s: | None |
| Type: | Change Request | Priority: | Critical |
| Reporter: | mike yi | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | database | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
mysql version:8.0.14 |
||
| Issue Links: |
|
||||||||
| Description |
|
start the zabbix-server service had a error message: [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], after installed zabbix server. I checked the document of mysql that groups is reserved words after 8.0.2 version. |
| Comments |
| Comment by Alexey Pustovalov [ 2018 Aug 01 ] |
|
Zabbix 3.4 does not support MySQL 8. Only Zabbix 4.0 (is not released yet) supports it. |