PDA

View Full Version : Alpha11 MySQL error


Neo
04-08-2005, 10:14
I was trying to install Alpha11 and get this error.
ERROR 1064 (42000): 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 'lob DEFAULT '' NOT NULL,
PRIMARY KEY (hostid)
) type=InnoDB' at line 13when I tried to execute the following.
cat schema.sql | mysql -u root zabbix11
Is Alpha 11 broken? or is there something wrong with my DB setup?

Alexei
04-08-2005, 10:27
Replace lob by blob to fix this problem. Sorry for inconvinience.

Neo
05-08-2005, 12:47
Whoops! thanks Alexei. Hope it's corrected in the package that is available for download