-
Incident report
-
Resolution: Cannot Reproduce
-
Major
-
None
-
1.8
-
None
-
Solaris 10, PHP 5.3.1
I get this when I try to either add a template or import one.
SQL error [ORA-01400: cannot insert NULL into ("ZABBIX_DBUSER"."HOSTS"."IPMI_IP")] in [INSERT INTO hosts (hostid,proxy_hostid,host,port,status,useip,dns,ip,disable_until,available,useipmi,ipmi_port,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_ip) VALUES (10165,0,'SMP_7404',10050,3,0,'','0.0.0.0',0,0,0,623,0,0,'','','')]
Clearly the dbpatch has implications here:
alter table hosts add ipmi_ip nvarchar2(64) DEFAULT '127.0.0.1' NOT NULL;
alter table hosts modify ipmi_ip nvarchar2(64) DEFAULT '127.0.0.1';
Should this allow for NULL since we have a default?