Ad Widget

Collapse

[1.5 R5512] GUI: DB Error in Monitoring/Actions

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NOB
    Senior Member
    Zabbix Certified Specialist
    • Mar 2007
    • 469

    #1

    [1.5 R5512] GUI: DB Error in Monitoring/Actions

    Hi,

    as soon as I select Monitoring/Actions the following message is displayed:

    * pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column a.triggerid does not exist[/usr/local/apache2/htdocs/zabbix-1.5/include/db.inc.php:293]
    * Error in query [SELECT DISTINCT a.alertid,a.clock,mt.description,a.sendto,a.subjec t,a.message,a.status,a.retries,a.error FROM alerts a,media_type mt,functions f,items i WHERE mt.mediatypeid=a.mediatypeid and a.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid not in (-1) and (a.alertid/100000000000000) in (0) ORDER BY a.clock,a.alertid,mt.description,a.sendto,a.status ,a.retries limit 100] [ERROR: column a.triggerid does not exist]
    * pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/zabbix-1.5/include/db.inc.php:414]
    OK, this is PostgeSQL, but it seems to me that this problem is not specific
    to PostgreSQL.
    It looks like there is a problem in the DB-Schema or the PHP-Code or both

    Regards

    Norbert.
  • Aly
    ZABBIX developer
    • May 2007
    • 1126

    #2
    Try the latest code from SVN, there have been changes in actions, so the new schema must be build.
    Zabbix | ex GUI developer

    Comment

    • NOB
      Senior Member
      Zabbix Certified Specialist
      • Mar 2007
      • 469

      #3
      Originally posted by Aly
      Try the latest code from SVN, there have been changes in actions, so the new schema must be build.
      Thanks for the info.

      When will this be reflected in the downloads for the nightly builds ?
      Is there some document or URL describing how this works ?

      I can't access SVN from the company directly: firewall blocks it.

      Regards

      Norbert.

      Comment

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

        #4
        Originally posted by NOB
        When will this be reflected in the downloads for the nightly builds ?
        The download section is updated automatically twice per day.
        Alexei Vladishev
        Creator of Zabbix, Product manager
        New York | Tokyo | Riga
        My Twitter

        Comment

        Working...