beta7 issue #2

[crs9]

I created a host using a template and everything was created fine. When I deleted the host I got errors of:
Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']Error in query [select distinct c.actionid from conditions c, triggers t where c.conditiontype=CONDITION_TYPE_TRIGGER and c.value=t.triggerid] [Unknown column 'CONDITION_TYPE_TRIGGER' in 'where clause']

Upon looking around the only issue I found was the graphs for that host were not removed, everything else appears to be gone. It shows the graphs there, but the host column is blank.

Thanks

[bbrendon]

Good to hear i'm not the first one upgrading. :)

I always get a load of surprises when upgrading.

[mconigliaro]

i can confirm this problem.

[Alexei]

Thanks for reporting this. In order to fix replace:

" where c.conditiontype=CONDITION_TYPE_TRIGGER".

by

" where c.conditiontype=".CONDITION_TYPE_TRIGGER.


in triggers.inc.php

Fixed in CVS.

[crs9]

thanks for the quick fix. My question is I assume it fixes the error mesage, am I correct in assmuning the graph deleting is a different problem?

Thanks

[Alexei]

Removal of graphs is a different issue. I cannot confirm if it really exists yet.

[haxor]

I did that fix which took care of the errors, but I still get a bunch of warnings that are all the same. they are:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/localhost/htdocs/zabbix/include/db.inc.php on line 111

and ideas?