Ad Widget

Collapse

freebsd6 -> simple check?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Unixboy
    Junior Member
    • Apr 2006
    • 10

    #1

    freebsd6 -> simple check?

    Hi there,

    I've got a really strange update today i've updated to beta9.

    But now my actions dont work anymore.

    Anybody experiencing identical problems?
    Last edited by Unixboy; 25-04-2006, 12:43. Reason: Strange problem :|
  • Unixboy
    Junior Member
    • Apr 2006
    • 10

    #2
    099162:20060425:141500 Query::insert into alerts (actionid,triggerid,userid,cloc k,mediatypeid,sendto,subject,message,status,retrie s,maxrepeats,delay) values (1, 3,12244,1145967300,1,'[email protected]','POP3 op server somedomain.tld','Serv er: somedomain.tld

    Thats what i can find in zabbix_server.log

    "099161:20060425:114000 Query failed:Unknown column 'userid' in 'field list' [105 4]" thats the error i get i've just launched the old Zabbix 1.1b8 again and that works as a charm. But any ideas upon this problem would be wonderfull...

    Comment

    • Alexei
      Founder, CEO
      Zabbix Certified Trainer
      Zabbix Certified SpecialistZabbix Certified Professional
      • Sep 2004
      • 5654

      #3
      You haven't applied database patches.
      Alexei Vladishev
      Creator of Zabbix, Product manager
      New York | Tokyo | Riga
      My Twitter

      Comment

      • Unixboy
        Junior Member
        • Apr 2006
        • 10

        #4
        Originally posted by Alexei
        You haven't applied database patches.
        Yes i did.

        cat /home/zabbix/new/zabbix-1.1beta9/upgrades/dbpatches/1.1beta8_to_1.1beta9/mysql/patch.sql | mysql -u zabbix -p zabbix

        hmm redoing it...

        Comment

        • Unixboy
          Junior Member
          • Apr 2006
          • 10

          #5
          obviously net-smtp is broken , i just compiled it without net-smtp and stuff now does work.

          Comment

          • Alexei
            Founder, CEO
            Zabbix Certified Trainer
            Zabbix Certified SpecialistZabbix Certified Professional
            • Sep 2004
            • 5654

            #6
            Support of SNMP has nothing to do with the Query failed:Unknown column 'userid' in 'field list' [1054]. The database patch has not been applied.
            Alexei Vladishev
            Creator of Zabbix, Product manager
            New York | Tokyo | Riga
            My Twitter

            Comment

            Working...