zabbix 1.4.1. Is discovery action repaired?

[Dmitriy Kirhlarov]

I'm update zabbix to 1.4.1 and try again enabling action for discovery event, but zabbix_server can't start with message in log file:
77934:20070706:185919 Query failed:PGRES_FATAL_ERROR:ERROR: column i.key does not exist LINE 1: ...s i, hosts h, items i2 where i2.itemid=21981 and i.key=i2.k...

When I disabling action, zabbix_server starting and working.
My action conditions:
Service type = "SNMPv2 agent"
Discovery status = "Up"
Received value like "FreeBSD"

And Operations:
Link to template "dimma template"

I can dump and restore zabbix database and think it's OK.
My be, my data not consistent? How I can check and repair it?

FreeBSD 6.2
zabbix 1.4.1
PostgreSQL 8.2

[Alexei]

Don't you mind to provide a complete text of the failed SQL statement?

[petteja]

I've got the same problem. Upgraded from 1.1.2 to 1.4.1.

4892:20070807:163621 Query::select i.itemid from items i, hosts h, items i2 where i2.itemid=18204 and i.key=i2.key_ and i.hostid
=h.hostid and h.templateid=i2.hostid
4892:20070807:163621 Query failed:PGRES_FATAL_ERROR:ERROR: column i.key does not exist
LINE 1: ...s i, hosts h, items i2 where i2.itemid=18204 and i.key=i2.k...

4861:20070807:163621 One child process died. Exiting ...
4861:20070807:163623 ZABBIX Server stopped

I do not know if it worked in 1.1.2. Is the query in src/libs/zbxdbhigh/host.c wrong?

Cheers,
Petter Jacobsen

[Alexei]

This is fixed in pre 1.4.2 code. You may download it from http://www.zabbix.com/developers.php