crs9
07-02-2006, 22:14
I had an issue with the patch.sql for this upgrade.
# cat patch.sql |mysql zabbix -u root
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 '-alter table sysmaps add label_location int(1) DEFAULT '0' NOT NULL' at line 1
I edited the line and removed the leading - . The patch took, but I'm not sure if this was the correct course of action. Thanks for any info.
# cat patch.sql |mysql zabbix -u root
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 '-alter table sysmaps add label_location int(1) DEFAULT '0' NOT NULL' at line 1
I edited the line and removed the leading - . The patch took, but I'm not sure if this was the correct course of action. Thanks for any info.