Ad Widget

Collapse

Problems adding item in ZABBIX-1.1beta11

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JustAddWater
    Junior Member
    • May 2006
    • 5

    #1

    Problems adding item in ZABBIX-1.1beta11

    Hi,

    When I try to add an item (using zabbix-1.1beta11.tar.gz) I get the following error:

    Code:
    ERROR EXECUTING: insert into items (description,key_,hostid,delay,history,lastdelete,nextcheck,status,type,snmp_community,snmp_oid,value_type,trapper_hosts,snmp_port,units,multiplier,delta) values ('Simple Ping','icmpping',10003,60,365,0,0,0,3,'public','interfaces.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
    Last edited by JustAddWater; 30-05-2006, 17:23.
  • erisan500
    Senior Member
    Zabbix Certified Specialist
    • Aug 2005
    • 285

    #2
    Did you upgraded from a previous version or is this a clean install?

    Greetings
    EriSan
    Zabbix Certified Specialist

    Comment

    • JustAddWater
      Junior Member
      • May 2006
      • 5

      #3
      Originally posted by erisan500
      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/mig...nux/tag/zabbix

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

      Comment

      • JustAddWater
        Junior Member
        • May 2006
        • 5

        #4
        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

        Comment

        • erisan500
          Senior Member
          Zabbix Certified Specialist
          • Aug 2005
          • 285

          #5
          Glad you resolved it
          EriSan
          Zabbix Certified Specialist

          Comment

          Working...