-
Incident report
-
Resolution: Fixed
-
Minor
-
2.0.2
-
Suse Linux Enterprise Server 10 SP 4 with mysql 5.0.26
During run of patch script I get the following error:
ERROR 1064 (42000) at line 1535: 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 '' at line 1
Failed to patch Zabbix database. Restore from backup
I've fixed this as follows:
fdl117:/home/zabbix/zabbix-2.0.2/upgrades/dbpatches/2.0/mysql # diff patch.sql patch.sql.wk
1535c1535
< CALL zbx_convert_operations();
—
> CALL zbx_convert_operations;
I've also noticed that this typo is not present in de v2.0.1 patch.sql script.