MySQL 5.0 & Zabbix Install Problems

[SAT QPass]

Apparently the Zabbix schema.sql uses the following:

line 454:

userid int(4) DEFAULT '' NOT NULL,

MySQL 5 returns:

ERROR 1067 (42000) at line 454: Invalid default value for 'userid'

I will back down and run MySQL 4.1 instead and see if it works there.

[Alexei]

Try to change it to DEFAULT '0' or DEFAULT 0 to make it work.