Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Audit trail not self cleaning
04-28-2020, 03:09 AM,
#1
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?

Thanks!
Reply
04-28-2020, 07:35 AM,
#2
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.

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


Forum Jump:


Users browsing this thread: 2 Guest(s)