Im thinking this: /usr/local/pf/addons/database-cleaner.pl --table=locationlog --date-field=end_time --older-than="1 WEEK" --additionnal-condition="(end_time IS NOT NULL OR end_time <> 0)"
should be this: /usr/local/pf/addons/database-cleaner.pl --table=locationlog --date-field=end_time --older-than="1 WEEK" --additionnal-condition="(end_time <> 0)" When doing an SQL query, is not null matches the 00-00-0000 date, so its matching those as records to delete. On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike <[email protected]> wrote: > PF 5.7. Running the DB maint script seems to close out all location log > entries instead of purging out old entries. > > Unless I'm doing something wrong? >
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
