auto commit for vacuum

1 files changed, 3 insertions, 0 deletions

diff --git a/FS/FS/Cron/expire_user_pref.pm b/FS/FS/Cron/expire_user_pref.pm
index 7ab73d280..32269271e 100644
--- a/FS/FS/Cron/expire_user_pref.pm
+++ b/FS/FS/Cron/expire_user_pref.pm
@@ -12,6 +12,9 @@ sub expire_user_pref {
                                           " AND expiration < ?";
   my $sth = dbh->prepare($sql) or die dbh->errstr;
   $sth->execute(time) or die $sth->errstr;
+
+  dbh->commit or die dbh->errstr if $FS::UID::AutoCommit
+
 }
 
 1;