JustAddWater
30-05-2006, 12:40
Hi,
When I try to add an item (using zabbix-1.1beta11.tar.gz) I get the following error:
ERROR EXECUTING: insert into items (description,key_,hostid,delay,history,lastdelete, nextcheck,status,type,snmp_community,snmp_oid,valu e_type,trapper_hosts,snmp_port,units,multiplier,de lta) values ('Simple Ping','icmpping',10003,60,365,0,0,0,3,'public','in terfaces.ifTable.ifEntry.ifInOctets.1',0,'',161,'' ,0,0)
I know nothing about MySQL, but I found out using phpMyAdmin that field "lastdelete" does not exist in table "items", which may cause the error. Can you reproduce this?
Just for troubleshooting purposes I granted the zabbix user all rights and it made no difference.
Best regards,
Patrick van den Berg
When I try to add an item (using zabbix-1.1beta11.tar.gz) I get the following error:
ERROR EXECUTING: insert into items (description,key_,hostid,delay,history,lastdelete, nextcheck,status,type,snmp_community,snmp_oid,valu e_type,trapper_hosts,snmp_port,units,multiplier,de lta) values ('Simple Ping','icmpping',10003,60,365,0,0,0,3,'public','in terfaces.ifTable.ifEntry.ifInOctets.1',0,'',161,'' ,0,0)
I know nothing about MySQL, but I found out using phpMyAdmin that field "lastdelete" does not exist in table "items", which may cause the error. Can you reproduce this?
Just for troubleshooting purposes I granted the zabbix user all rights and it made no difference.
Best regards,
Patrick van den Berg