web/modules/rhn/RHN/DB/DataSource/xml/CustomInfo_queries.xml | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
New commits:
commit df09856f76dab0072fc692ecd6cc20a0b86c913f
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Mar 22 14:26:18 2011 +0100
Fixing custom_info_keys PostgreSQL issue.
Addressing
DBD::Pg::st execute failed: ERROR: syntax error at or near ")"
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/CustomInfo_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/CustomInfo_queries.xml
index 3fd7d79..0249296 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/CustomInfo_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/CustomInfo_queries.xml
@@ -7,10 +7,9 @@ SELECT CDK.id,
CDK.description,
(
SELECT COUNT(SCDV.server_id)
- FROM rhnServerCustomDataValue SCDV,
- rhnUserServerPerms USP
+ FROM rhnUserServerPerms USP left outer join rhnServerCustomDataValue SCDV
+ on USP.server_id = SCDV.server_id
WHERE USP.user_id = :user_id
- AND USP.server_id = SCDV.server_id (+)
AND SCDV.key_id = CDK.id
) as system_count,
TO_CHAR(CDK.modified, 'YYYY-MM-DD HH24:MI:SS') AS LAST_MODIFIED
@@ -42,4 +41,4 @@ ORDER BY UPPER(CDK.label)
</query>
</mode>
-</datasource_modes>
\ No newline at end of file
+</datasource_modes>
Show replies by date