Bug in opscreen

[GldRush98]

http://exchange.nagios.org/directory/Ad ... nt/details

I was updating all my components and wizards yesterday, and ran in to a surprise in the opsceen. A bug in the code is preventing any Unhandled service problems from showing up in the list (eek)!
I use this as my main screen, so it caught my eye when I was restarting a server this morning and I didn't see the down services pop up on my opscreen.

Upon digging in to it, I found a bug on line 262 of merlin.php in this bit of the sql query:

WHERE nagios_servicestatus.scheduled_downtime_depth='0' nagios_servicestatus.problem_has_been_acknowledged='0' AND nagios_servicestatus.current_state!='0' AND nagios_hoststatus.problem_has_been_acknowledged='0' AND nagios_hoststatus.last_hard_state='0' AND nagios_hoststatus.current_state='0'

Should be:

WHERE nagios_servicestatus.scheduled_downtime_depth='0' AND nagios_servicestatus.problem_has_been_acknowledged='0' AND nagios_servicestatus.current_state!='0' AND nagios_hoststatus.problem_has_been_acknowledged='0' AND nagios_hoststatus.last_hard_state='0' AND nagios_hoststatus.current_state='0'

Once the query is fixed, the opscreen returns to operating like it should. Might want to update that file on the site guys

[tmcdonald]

Thank you, I will alert the devs to this.

EDIT: It looks like this has been fixed in a developer revision already and should be included in the next release.