Module: nagvis Branch: master Commit: 012099af0dddd610dd106edebe54f6f7a6e54126 URL: http://nagvis.git.sourceforge.net/git/gitweb.cgi?p=nagvis/nagvis/nagvis;a=commit;h=012099af0dddd610dd106edebe54f6f7a6e54126
Author: Roman Kyrylych <[email protected]> Date: Fri Sep 4 16:47:43 2009 +0300 Fixed ambiguous field in SQL query in Merlin backend Signed-off-by: Roman Kyrylych <[email protected]> --- .../includes/classes/GlobalBackendmerlinmy.php | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/share/nagvis/includes/classes/GlobalBackendmerlinmy.php b/share/nagvis/includes/classes/GlobalBackendmerlinmy.php index 89cc6b3..68b323c 100755 --- a/share/nagvis/includes/classes/GlobalBackendmerlinmy.php +++ b/share/nagvis/includes/classes/GlobalBackendmerlinmy.php @@ -591,7 +591,7 @@ class GlobalBackendmerlinmy implements GlobalBackendInterface { { $arrReturn = Array(); - $QUERYHANDLE = $this->mysqlQuery('SELECT host_name, last_hard_state, current_state, state_type' + $QUERYHANDLE = $this->mysqlQuery('SELECT host.host_name, last_hard_state, current_state, state_type' .' FROM host LEFT JOIN scheduled_downtime AS sdt ON sdt.host_name = host.host_name' .' AND NOW() > sdt.start_time AND NOW() < sdt.end_time' .' LEFT JOIN host_hostgroup AS hhg ON hhg.host = host.id' ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Nagvis-checkins mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagvis-checkins
