web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 6e34bd693fd826f85e48a9ef464ef2d13466728a
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Jul 31 08:06:25 2012 +0200
fix outer join syntax
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml
index 50d0e55..63d32fb 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/config_queries.xml
@@ -87,7 +87,7 @@ SELECT CFN.path,
rhnConfigFileName CFN,
rhnActionConfigFileName ACFN
LEFT JOIN rhnConfigFileFailure CFF
- AND ACFN.failure_id = CFF.id
+ ON ACFN.failure_id = CFF.id
WHERE ACFN.server_id = :sid
AND ACFN.action_id = :aid
AND ACFN.config_file_name_id = CFN.id
Show replies by date