I just checked why the index is not there. And I found the reason in the
file
/upgrades/dbpatches/1.6/mysql/patch.sql
which reads (among many other SQL queries)
alter table alerts drop triggerid;
I'm not sure why the Zabbix developers added that. I tested an upgrade
from Lenny (1.4) to Squeeze (1.8) though and that worked for me. Could
you try to run the upgrade procedure to 1.8 if you still have the problem?
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
