backend/server/configFilesHandler.py | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
New commits:
commit 25dd5837f6352c24d150adac680f12e2fa2709fd
Author: Joshua Roys <joshua.roys(a)gtri.gatech.edu>
Date: Thu Mar 4 16:11:48 2010 +0000
568371 - fix an ORA-00918 on config file import
diff --git a/backend/server/configFilesHandler.py b/backend/server/configFilesHandler.py
index fca9484..3882a70 100644
--- a/backend/server/configFilesHandler.py
+++ b/backend/server/configFilesHandler.py
@@ -222,12 +222,12 @@ class ConfigFilesHandler(rhnHandler):
return result
_query_content_lookup = rhnSQL.Statement("""
- select id, c.checksum_type, c.checksum, file_size, contents, is_binary
- from rhnConfigContent, rhnChecksumView c
- where c.checksum = :checksum
- and c.checksum_type = :checksum_type
+ select cc.id, cv.checksum_type, cv.checksum, file_size, contents, is_binary
+ from rhnConfigContent cc, rhnChecksumView cv
+ where cv.checksum = :checksum
+ and cv.checksum_type = :checksum_type
and file_size = :file_size
- and checksum_id = c.id
+ and checksum_id = cv.id
""")
_query_insert_content = rhnSQL.Statement("""
Show replies by date