Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Audit trail not self cleaning
04-28-2020, 03:09 AM,
Audit trail not self cleaning
Hi Folks

weberp version 4.14.1

I have my audit trail "Months of Audit Trail to Retain:" set to 1 but despite this I just noticed today that I have 1.5 million records in it, everything for the past two years

Could you point me to the file where the trimming is supposed to happen?

04-28-2020, 07:35 AM,
RE: Audit trail not self cleaning
It is executed in the includes/UserLogin.php

I suspect you have the perform database maintenance at login set to "Never" and the audit trail deletion won't occur if that is set. I would move the lines 165-172 outside of that conditional statement. Line 154 looks a good bet. The next time you login it might take a short while to delete all that audit trail but after that it shouldn't be an issue.

I'm not sure why the audit trail deletion was put there anyway.

04-28-2020, 07:43 AM,
RE: Audit trail not self cleaning
Thanks Tim!

Forum Jump:

Users browsing this thread: 2 Guest(s)