diff options
| author | Christophe Romain <christophe.romain@process-one.net> | 2016-06-22 11:21:11 +0200 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2016-06-22 11:21:11 +0200 |
| commit | 2efa8677c9d512f2d2001de108fa281001ec3144 (patch) | |
| tree | 58066e5ce1417df31a63700b683282c82fbe7690 /src/mod_offline_sql.erl | |
| parent | XEP-0198: Apply cosmetic changes (diff) | |
Fix pgsql compatibility on delete_old_messages (#1137)
Diffstat (limited to 'src/mod_offline_sql.erl')
| -rw-r--r-- | src/mod_offline_sql.erl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/mod_offline_sql.erl b/src/mod_offline_sql.erl index a368e8e31..feefd3dd0 100644 --- a/src/mod_offline_sql.erl +++ b/src/mod_offline_sql.erl @@ -80,8 +80,8 @@ remove_old_messages(Days, LServer) -> LServer, [<<"DELETE FROM spool" " WHERE created_at < " - "DATE_SUB(CURDATE(), INTERVAL ">>, - integer_to_list(Days), <<" DAY);">>]) of + "NOW() - INTERVAL '">>, + integer_to_list(Days), <<"';">>]) of {updated, N} -> ?INFO_MSG("~p message(s) deleted from offline spool", [N]); _Error -> |