PDA

View Full Version : Problems adding item in ZABBIX-1.1beta11


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

erisan500
30-05-2006, 13:02
Did you upgraded from a previous version or is this a clean install?

Greetings

JustAddWater
30-05-2006, 14:35
Did you upgraded from a previous version or is this a clean install?
I first installed an unofficial Debian package. I ran into problems with this so I uninstalled the package and removed the zabbix database from MySQL. After this I did an installation from scratch using 1.1beta11. I used the Debian specific installation howto from http://community.livejournal.com/migrate2linux/tag/zabbix

Nothing special in this howto though -as far as I can see- which could explain the error mentioned...

JustAddWater
30-05-2006, 17:23
Solved the problem:
The Debian package I had inunstalled did not remove the PHP files to which the web interface pointed. I removed them and copied the correct ones. Now everything works fine again. :-)

Best regards,
Patrick van den Berg

erisan500
30-05-2006, 17:24
Glad you resolved it ;)