When looking at event details with 1.6.3pre from yesterday I get the following error:
* Error in query [SELECT DISTINCT i.hostid FROM events e, functions f, items i WHERE e.eventid=8118 AND f.triggerid=e.objectid13782 AND i.itemid=f.itemid limit 1] [Unknown column 'e.objectid13782' in 'where clause']
I guess it was a copy/paste error and suggest the fix attached.
Regards,
Simon
* Error in query [SELECT DISTINCT i.hostid FROM events e, functions f, items i WHERE e.eventid=8118 AND f.triggerid=e.objectid13782 AND i.itemid=f.itemid limit 1] [Unknown column 'e.objectid13782' in 'where clause']
I guess it was a copy/paste error and suggest the fix attached.
Regards,
Simon
Comment