[1.4.2] Error message creating graph

[NOB]

Hi,

we are using ZABBIX 1.4.2 (Postgresql 8.2.4, FreeBSD 6.2, i386).
Today I tried to create a graph with the 4 values.

The result of the "Save" opeation were the following error messages:

    * Graph "RPC / Disj Queue / CPU" added to hosts "T_Exch2007_MBX"
    * pg_query() [function.pg-query]: Query failed: ERROR: NEW used in query that is not in a rule[/usr/local/www/apache22/data/include/db.inc.php:293]
    * Error in query [select new.itemid from items new, items dest where dest.itemid=500000000019473 and new.key_=dest.key_ and new.hostid=500000000010052] [ERROR: NEW used in query that is not in a rule]
    * pg_fetch_array() expects parameter 1 to be resource, boolean given[/usr/local/www/apache22/data/include/db.inc.php:414]
    * Missed key "perf_counter[\MSExchangeIS\RPC Averaged Latency]" for host "i15.xxx.org"
    * Skipped coping of graph "RPC / Disj Queue / CPU" to host "i15.xxx.org"
    * pg_query() [function.pg-query]: Query failed: ERROR: NEW used in query that is not in a rule[/usr/local/www/apache22/data/include/db.inc.php:293]
    * Error in query [select new.itemid from items new, items dest where dest.itemid=500000000019473 and new.key_=dest.key_ and new.hostid=500000000010053] [ERROR: NEW used in query that is not in a rule]
    * pg_fetch_array() expects parameter 1 to be resource, boolean given[/usr/local/www/apache22/data/include/db.inc.php:414]
    * Missed key "perf_counter[\MSExchangeIS\RPC Averaged Latency]" for host "i16.xxx.org"
    * Skipped coping of graph "RPC / Disj Queue / CPU" to host "i16.xxx.org"
    * pg_query() [function.pg-query]: Query failed: ERROR: NEW used in query that is not in a rule[/usr/local/www/apache22/data/include/db.inc.php:293]
    * Error in query [select new.itemid from items new, items dest where dest.itemid=500000000019473 and new.key_=dest.key_ and new.hostid=500000000010050] [ERROR: NEW used in query that is not in a rule]
    * pg_fetch_array() expects parameter 1 to be resource, boolean given[/usr/local/www/apache22/data/include/db.inc.php:414]
    * Missed key "perf_counter[\MSExchangeIS\RPC Averaged Latency]" for host "i14.xxx.org"
    * Skipped coping of graph "RPC / Disj Queue / CPU" to host "i14.xxx.org"
    * pg_query() [function.pg-query]: Query failed: ERROR: NEW used in query that is not in a rule[/usr/local/www/apache22/data/include/db.inc.php:293]
    * Error in query [select new.itemid from items new, items dest where dest.itemid=500000000019473 and new.key_=dest.key_ and new.hostid=500000000010048] [ERROR: NEW used in query that is not in a rule]
    * pg_fetch_array() expects parameter 1 to be resource, boolean given[/usr/local/www/apache22/data/include/db.inc.php:414]
    * Missed key "perf_counter[\MSExchangeIS\RPC Averaged Latency]" for host "i13.xxx.org"
    * Skipped coping of graph "RPC / Disj Queue / CPU" to host "i13.xxx.org"

I looks like "new" might be a reserved word in Postgresql.
I'll try to fix it and report the result.

Regards,

Norbert.

[Alexei]

I believe it is already fixed in pre 1.4.3 code.

[NOB]

I believe it is already fixed in pre 1.4.3 code.

Thanks.

Replacing the keyword "new" by "newone" in include/graphs.inc.php
lines 209 and 211 fixed it for me.
(just for the other users).

Regards,

Norbert.