web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit a570dff3c34fac655c86f10c48f56f3cfbc5a9cd
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 24 13:59:32 2011 +0100
Fixing previous taggable_systems_in_set fix (Oracle, this time).
Addressing
ORA-00904: "S"."NAME": invalid identifier (DBD ERROR: error
possibly near <*> indicator at char 500 in
[...]
ORDER BY UPPER(coalesce(<*>S.NAME, '(none)')), S.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 911ac83..4400d10 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -132,7 +132,7 @@ SELECT DISTINCT S.id,
AND USP.server_id = SS.server_id
AND USP.server_id = S.id
) S
-ORDER BY UPPER(coalesce(S.NAME, '(none)')), S.ID
+ORDER BY UPPER(coalesce(S.SERVER_NAME, '(none)')), S.ID
</query>
<elaborator name="system_overview" />
</mode>
Show replies by date