1.3.3 Bug? * Warning. Field [formula] is not double

[clahti]

I get this when attempting to edit an existing Item, this was also present in 1.3.2. When this message appears it prevents me from saving the Item. The strange thing is I can delete the item and re-create this as new, then I do not get the error message. I can even edit the "recreated" entry and this saves without the error. I will compare in the database to see what the difference is, this may be an artifact of upgrading from 1.3.2 to 1.3.3.

UPDATE:
I compared the values in the database for a working and non-working entry, the only difference is that the field "formula" has a value of 1 for the working Item, and an empty value for the non-working Item (note this is not NULL, but empty). I believe this field corresponds to the "Store Value" field, where 1 is "As is". Why would this be blank in previous releases? Should I update my table to store the value of 1 where the current value is ""? Is this a good or bad idea?

UPDATE items SET formula='1' WHERE formula = '';

Thanks!

/Christian

[Alexei]

Yes, I think this is because of 1.3.2 to 1.3.3 migration. ZABBIX 1.3.3 should be free of this issue.

[clahti]

Yes, I think this is because of 1.3.2 to 1.3.3 migration. ZABBIX 1.3.3 should be free of this issue.

ok, so my question still stands, Is this a good or bad idea?

UPDATE items SET formula='1' WHERE formula = '';

Do you see anything blowing up as a result of this? Am I correct in my thought that the formula field must not be null and the value of '1' is the default value? Thanks!

[Markus]

This is still a problem in SVN 4252. The SQL UPDATE statement mentioned in the other posts fixes this problem.

Markus