Upgrade 1.1.7 to 1.4 - bugs in patch.sql

[n0mad44]

Hello,

I've troubles to upgrade from 1.1.7 to 1.4 (1.4.4). My zabbix server is a virtual machine so I made a clone to test the upgrade. In this clone, I simply run the command "cat mysql/patch.sql | mysql -uroot zabbix". After one hour, the upgrade complete with no errors.

Then, I copied the 1.4 frontend and see the result. I found at least 3 bugs :

1. Configuration > Items. The "Trends" value for some items is not properly copied. I had some item which trends was 90...and now it's 1161788861 !!!

2. Configuration > Triggers (view all). The is some triggers which are not correctly upgraded. I mean I just have "*ERROR*>0" for example in the expression field. Such expression are never assign to any host. That's wired!

3. Monitoring > Screens. Some graphs seems to had disappear. I just have "ERROR: No graph defined" message !

Are this known bugs ? Any trick to do before upgrading ? Any Help ?!

Thanks,
n0mad

[n0mad44]

Solved !

Hi,

I found why I was not able to migrate my base : my existing one (1.1.7) is corrupted. For example, in the table "functions" there is some row having itemid=0.

I think that's explain too why some triggers where not working.

However, I don't know where do this issue come from!

n0mad.