Reminder emails sent for zero balance invoices by Cron job

Hi - This morning at 5:00 AM, six client invoice reminder emails (first and second reminders) were sent to clients by the normally scheduled cron job. However, these invoices had already been paid (had no balance due, invoice.status_id=4 (STATUS_PAID), achieved (invoice deleted_at was not null). I have spent most of the day today reviewing, and I can’t figure out why these emails were triggered. I appreciate any help you can offer. For now, I’m going to switch off the reminder emails.

the six invoices:

App configuration:


Cron job log:

ReminderJob:

Cron Schedule:

I compared the code in our app vs the code on Github v5 stable for two php files:
File 1) ReminderJob.php: I noted differences as it relates to logging, but I’m not sure that would have caused this.

File 2) SendRemindersCron.php, no differences.

compared Github versions:
/v5-stable/app/Jobs/Util/ReminderJob.php
/v5-stable/app/Console/Commands/SendRemindersCron.php

Running v5.8.57
image

Hi,

@david do you have any thoughts?

@david - the system is also writing to the table that a reminder was sent this morning (May 21), but really wasn’t sent. I’m not sure if that’s by design. Log file I pulled this morning. I turned the reminders off yesterday, so for today (May 21) there is no entry for Firing reminder email:

mySQL db:

@hillel thanks.

“touching” a reminder is different to sending a reminder, it updates the column in the db but does not send.

Thanks. That makes sense. Let me know if you have any thoughts about the reminder emails (my initial post). Thank you.