I’m using IN 5.6.6 and I assume one of the updates from last months broke the reminders.
Here are my reminder settings for the first reminder:
Days: 4
Schedule: After the due date
Send Email: yes
The “Due Date” and “Next Send Date” are shown correctly on every invoice, but although no reminder has been sent to the customer. In the “Activity”-Tab there is also no sign of the reminder.
I can send the reminder manually, but the “Next Send Date” stays the same.
Customer settings for reminders are empty (default).
I’ve set two cronjobs for IN:
Laravel Scheduler (artisan schedule:run) every minute
Database Queue (artisan queue:work) every 5 minutes
But I didn’t touch the cronjobs for a long time, so that shouldn’t be the problem.
I looked it up. The reminder for invoice R-0136-0002 was not sent automatically at 2023-06-26, so I sent it manually at 2023-06-29 (that’s correctly in the activity-tab).
Unfortunately the “Next Send Date” still shows 2023-06-26.
But that’s not the big issue for me. More important is to sent the reminder automatically in the first place.
@david
For testing purposes, I created a new invoice “R-00000-0025” a few days ago. The reminder should have been sent today at 11 am.
No reminder was sent (automatically or manually). “Next Send Date” for the invoice still shows
09.07.2023. In invoiceninja.log, I found following error, although I have not manually sent a reminder:
[2023-07-09 11:00:06] production.INFO: caught a duplicate reminder for invoice R-00000-0025
if ($invoice->reminder_last_sent && Carbon::parse($invoice->reminder_last_sent)->startOfDay()->eq(now()->startOfDay())) {
nlog("caught a duplicate reminder for invoice {$invoice->number}");
return;
}
We watch for any invoices that were already sent on that day. If the query condition matches, we do not send an email twice to the user. This would mean that the last send date of this particular invoice was “today” What is the schedule you have configured for your reminders?
First reminder is set to 4 days after due date. Invoice R-00000-0025 was created at 2023-07-05. No reminder at all was sent yesterday (2023-07-09) automatically or manually.
I looked up some values in the table invoices for invoice R-00000-0025:
date: 2023-07-05
last _sent_date: 2023-07-10
due_date: 2023-07-05 00:00:00
next_send_date: 2023-07-09 09:00:00
created_at: 2023-07-04 23:30:58.025936
updated_at: 2023-07-10 00:00:18.641442
reminder1_sent: 2023-07-10
reminder_last_sent: 2023-07-10
Interestingly my other overdue invoice has also todays date (2023-07-10) for last_sent_date, reminder1_sent and reminder_last_sent. Further more it was also updated_at 2023-07-10 00:00:18.435063.
I have the exact same issue for several months now…
It was working as expected before.
Recurring invoices are still sent automatically without any issue, but not reminders.
With EXPANDED_LOGGING=true, I can confirm that invoiceninja.log also shows the error “caught a duplicate reminder for invoice XXXXX”, but no reminder e-Mail was sent. In the “invoices” table, I can also confirm the same behaviour at columns level.
It looks like the reminder is marked as sent without being sent, with the exception that the next_send_date is not updated. It stays stuck. No matter the number of reminders configured to being sent…
I would be very happy to get a solution for that issue too.
Log with no reminder sent, either automatically or manually for both invoices XXXX64 and XXXX65:
[2023-07-26 08:00:03] production.INFO: Sending invoice reminders on 2023-07-26 08:00:03
[2023-07-26 08:00:03] production.INFO: caught a duplicate reminder for invoice XXXX64
[2023-07-26 08:00:03] production.INFO: caught a duplicate reminder for invoice XXXX65
[2023-07-26 08:30:03] production.INFO: Cleaning Stale Invoices:
[2023-07-26 08:40:02] production.INFO: Updating calculated fields
I’ve just tried to set reminder1_sent and reminder_last_sent to NULL for invoice XXXX64. I’ve also tried to change the hour in next_send_date to something in the near future (next hour). Here comes the log after that change:
Nothing about XXXX64 in the log. After that, I’m back to the previous state at database level. reminder1_sent is set to today as well as reminder_last_sent for invoice XXXX64. However, no reminder e-Mail has been sent. No trace of it in activities or elsewhere. Is there something like “Invoice reminder send duration…” line missing in the log?
Unfortunately not. invoiceninja.log shows the following error:
Check
