web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 01595ed07a3db9bc51a14d74a0b031378c12d3b0
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Wed Dec 1 19:44:47 2010 +0100
Revert "658256 - Error 500 - ISE - when scheduling remote commands"
No, this is really not a proper fix.
This reverts commit 5db2eedb1f8247360da182983dbf012dfd09e57b.
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index 9ac2135..d330308 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -1033,7 +1033,7 @@ ORDER BY UPPER(NVL(S.name, '(none)')), S.id
( SELECT CASE
MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN
2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN
5 END)
WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3
THEN 'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END
ST
- FROM rhn_probe_state PS, rhnServerOverview OV
+ FROM rhn_probe_state PS
LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
GROUP BY OV.server_id ) MONITORING_STATUS,
Show replies by date