-
New Feature Request
-
Resolution: Fixed
-
Minor
-
None
-
Sprint 14, Sprint 15, Sprint 16, Sprint 32, Sprint 33, Sprint 34, Sprint 35, Sprint 36
-
2
Trying to install Zabbix 3.2.6, using MySQL 8.0.2 I got this message (among many similar ones):
...
26:20170801:200803.540 completed 86% of database upgrade
26:20170801:200804.646 completed 87% of database upgrade
26:20170801:200805.131 completed 88% of database upgrade
26:20170801:200805.935 [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
(groupid)' at line 1 [alter table corr_condition_group add constraint c_corr_condition_group_2 foreign key (groupid) references groups (groupid)]
26:20170801:200805.936 database upgrade failed
I checked, and as per the official MySQL documentation ( https://dev.mysql.com/doc/refman/8.0/en/keywords.html ), "groups" is added as a reserved word since version 8.0.2.
Also, as the schema.sql is properly backticked - there is a chance this requires a considerable refactoring effort to fix...
- causes
-
ZBX-14670 Wrong column name in zabbix 4.0.0-1.1alpha9
-
- Closed
-
- duplicates
-
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]
-
- Closed
-
-
-
- Closed
-
-
ZBX-14705 zabbix3+ 在mysql8上无法使用
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- mentioned in
-
Page Loading...
