web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit c6d8dda49e05d687116685c1642ea03069b6605d
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Wed Jul 27 09:07:31 2011 +0200
fixed ORA-00904 in remote commands
Error message:
RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904:
"X"."NAME":
invalid identifier (DBD ERROR: error possibly near <*> indicator at > char
614 in
'
select * from (
SELECT DISTINCT S.id,
S.name AS SERVER_NAME
FROM rhnServer S,
rhnClientCapabilityName CCN,
rhnClientCapability CC,
rhnSet ST,
rhnUserServerPerms USP
WHERE USP.user_id = :user_id
AND ST.user_id = :user_id
AND ST.label = 'system_list'
AND USP.server_id = ST.element
AND EXISTS(SELECT 1 FROM rhnServerFeaturesView SFV WHERE
SFV.server_id =
ST.element AND SFV.label = 'ftr_remote_command')
AND USP.server_id = CC.server_id
AND CC.capability_name_id = CCN.id
AND CCN.name = 'script.run'
AND USP.server_id = S.id
) X
ORDER BY UPPER(COALESCE(<*>X.name, '(none)')), X.id
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 5b8cfb0..5a23d57 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -20,7 +20,7 @@ SELECT DISTINCT S.id,
AND CCN.name = 'script.run'
AND USP.server_id = S.id
) X
-ORDER BY UPPER(COALESCE(X.name, '(none)')), X.id
+ORDER BY UPPER(COALESCE(X.server_name, '(none)')), X.id
</query>
<elaborator name="system_overview" />
Show replies by date