Query failed:Unknown column

[tucows31]

Hi All.....

I am getting this error in zabbix_serverd.log:

Query::insert into trends (clock,itemid,num,value_min,value_avg,value_max) values (1171472400,17669,1,inf,inf,inf)
003652:20070214:185602 Query failed:Unknown column 'inf' in 'field list' [1054]
003652:20070214:185707 Query::insert into history (clock,itemid,value) values (1171475827,17669,inf)
003652:20070214:185707 Query failed:Unknown column 'inf' in 'field list' [1054]

I updated Zabbix to 1.1.6 one week ago. It was working very well but I'm getting this error for 2 days.

I reinstalled Zabbix(server and agent) 1.1.6 again, but i am getting the error again.


Thanks for any ideas you folks may have.

Jesus.

[globlalways]

I get the same error message:

Unknown column 'inf' in 'field list' [1054]
  1402:20070926:100206 Query failed: [insert into history (clock,itemid,value) values (1190793726,18848,inf)] Unknown column 'inf' in 'field list' [1054]
  1402:20070926:100206 Query failed: [update trends set num=22, value_min=1759.200000, value_avg=inf, value_max=inf where itemid=18848 and clock=1190793600]

mysql> describe history;
+--------+---------------------+------+-----+---------+-------+
| Field  | Type                | Null | Key | Default | Extra |
+--------+---------------------+------+-----+---------+-------+
| itemid | bigint(20) unsigned | NO   | MUL | 0       |       |
| clock  | int(11)             | NO   |     | 0       |       |
| value  | double(16,4)        | NO   |     | 0.0000  |       |
+--------+---------------------+------+-----+---------+-------+

Using mysql 5.0