From c865adbb771ba9a275602ad2960f1189b7dac336 Mon Sep 17 00:00:00 2001 From: Frank Lichtenheld Date: Tue, 27 Oct 2009 14:28:04 +0000 Subject: [PATCH] Fix SQL syntax errors Signed-off-by: Frank Lichtenheld --- dak/clean_suites.py | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/dak/clean_suites.py b/dak/clean_suites.py index 49f488d0..3bc42294 100755 --- a/dak/clean_suites.py +++ b/dak/clean_suites.py @@ -211,8 +211,7 @@ def clean(now_date, delete_date, max_delete, session): q = session.execute(""" SELECT df.id, s.id, f.filename FROM source s, files f, dsc_files df WHERE f.last_used <= :deletedate - AND s.file = f.id AND s.id = df.source - AND df.id = dsc_files.id)""", {'deletedate': delete_date}) + AND s.file = f.id AND s.id = df.source""", {'deletedate': delete_date}) for s in q.fetchall(): Logger.log(["delete source", s[2]]) if not Options["No-Action"]: -- 2.39.2