[ZBX-2457] Error in script ./create/schema/mysql.sql if version mysql is 5.5.x Created: 2010 May 24 Updated: 2017 May 30 Resolved: 2010 May 27 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.8.3 |
| Type: | Incident report | Priority: | Major |
| Reporter: | Petrov Vladimir | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
zabbix 1.8.2, mysql 5.5.4, freebsd 8.0 |
||
| Description |
|
If exec script mysql.sql with clear installed (not upgraded) mysql 5.5.x show error: type=InnoDB. Replace "type=InnoDB" to "ENGINE=InnoDB" resolve problem. |
| Comments |
| Comment by Petrov Vladimir [ 2010 May 24 ] |
|
ERROR 1064 (42000) at line 1: 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 'type = InnoDB' at line 6 |
| Comment by richlv [ 2010 May 24 ] |
|
this will be new with 5.5, according to http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html |
| Comment by richlv [ 2010 May 27 ] |
|
according to mysql documentation, "ENGINE" keyword should be supported in all mysql versions starting with 3 => changed to ENGINE |
| Comment by richlv [ 2011 Sep 04 ] |
|
same issue in upgrade patches will be fixed in |