problem creating my first item: Error in query[INSERT INTO items

[cskang]

I got the following error message from zabbix while I was following steps in "Creating an item", which is on page 52 of the book, Zabbix 1.8 Network Monitoring by Richards Olups:

ERROR: Cannot add item
Error in query [INSERT INTO items (itemid,description,key_,hostid,delay,history,next check,status,type,snmp_community,snmp_oid,value_ty pe,trapper_hosts,snmp_port,units,multiplier,delta, snmpv3_securityname,snmpv3_securitylevel,snmpv3_au thpassphrase,snmpv3_privpassphrase,formula,trends, logtimefmt,valuemapid,delay_flex,params,ipmi_senso r,templateid) VALUES (22162,'CPU Load','system.cpu.load',10047,30,90,0,0,0,'public' ,'interfaces.ifTable.ifEntry.ifInOctets.1',0,'',16 1,'',0,0,'',0,'','','1',365,'',0,'','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','',0)] [Unknown column 'nextcheck' in 'field list']

I appreciate if anyone can provide me some help how to resolve this issue.

[cskang]

Above problem was resolved with the great help from ricklv.
The problem was due to using older version of web front end, i.e. 1.6.9, while using zabbix server version 1.8.3.

Charles

[chronikeur]

Hi there !!!
I advise safari (last version) for zabbix-1.8.3!!! It work very well and very fast !!! Sounds better than ie or mozilla !!

[sugraj1119]

Error in query while attaching the template for the host

Error in query [INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,descript ion,key_,delay,history,trends,status,value_type,tr apper_hosts,units,multiplier,delta,snmpv3_security name,snmpv3_securitylevel,snmpv3_authpassphrase,sn mpv3_privpassphrase,formula,logtimefmt,valuemapid, delay_flex,params,ipmi_sensor,data_type,authtype,u sername,password,publickey,privatekey,flags,filter ,port,inventory_link,lifetime,templateid,itemid) VALUES ('7','','','500500000021907','Disk space free(B) on C:','','vfs.fs.size[C:,free]','900','4','180','0','3','','B','0','0','','0','' ,'','1','',NULL,'','','','0','0','','','','','0',' ','','0','30','500500000689774','500500000983605')] [Duplicate entry '500500000021907-vfs.fs.size[C:,free]' for key 'items_1']
SQL statement execution has failed "INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,descript ion,key_,delay,history,trends,status,value_type,tr apper_hosts,units,multiplier,delta,snmpv3_security name,snmpv3_securitylevel,snmpv3_authpassphrase,sn mpv3_privpassphrase,formula,logtimefmt,valuemapid, delay_flex,params,ipmi_sensor,data_type,authtype,u sername,password,publickey,privatekey,flags,filter ,port,inventory_link,lifetime,templateid,itemid) VALUES ('7','','','500500000021907','Disk space free(B) on C:','','vfs.fs.size[C:,free]','900','4','180','0','3','','B','0','0','','0','' ,'','1','',NULL,'','','','0','0','','','','','0',' ','','0','30','500500000689774','500500000983605') ".

Any one help how to resolve this.
We are using zabbix 2.0.9 version