Hi,
as soon as I select Monitoring/Actions the following message is displayed:
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.
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]
* 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]
to PostgreSQL.
It looks like there is a problem in the DB-Schema or the PHP-Code or both

Regards
Norbert.
Comment