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@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" />
spacewalk-commits@lists.fedorahosted.org