cache log displays only the latest

The cache log page displays only onw row for the latest run report. This is probably because there is a bug in function log_cache_event($text) in ameta-cache.php, where it deletes old log records before adding the new one. It’s supposed to delete day-old records, but it deletes everything due to a bug in the where clause:

/* clean up oldder log entries first  if there are any */
$old = date_create();
$old = clone $datetime;   // 20161011 don't use as a function, it's a keyword
date_modify($old, '-1 day');
$sql = "DELETE FROM " . $this->eventlog_table .
    " WHERE eventtime <= '%s'";
$sql = $wpdb->prepare($sql,
    date_format($datetime,'Y-m-d H:i:s'));	

The $datetime in where clause should have been $old.

• This topic was modified 4 years, 1 month ago by muratgu. Reason: formatted the code