From 3a7b32ff9f679cfbff21dff88fdc7839e011f583 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Sat, 5 Sep 2015 19:42:54 +0200 Subject: [server] Fix delete old lectures query --- .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'dozentenmodulserver/src/main/java') diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java index e5e7fe4f..97c79f5e 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java @@ -477,7 +477,7 @@ public class DbLecture { public static void deleteOld(int minAgeDays) throws SQLException { try (MysqlConnection connection = Database.getConnection()) { - MysqlStatement stmt = connection.prepareStatement("DELETE FROM lecture WHERE enddate < :cutoff"); + MysqlStatement stmt = connection.prepareStatement("DELETE FROM lecture WHERE endtime < :cutoff"); stmt.setLong("cutoff", Util.unixTime() - TimeUnit.DAYS.toSeconds(minAgeDays)); stmt.executeUpdate(); connection.commit(); -- cgit v1.2.3-55-g7522