Reminder texts are not sending
Hi,
can you please check in database if there is a column named reminder
in table <wp_prefix>ea_twilio_reminder
?
Best regards,
Nikola
Yes, the column exists and all values are ‘null’.
easy-appointments-connect/src/cron/twilio_cron.php
and change line 88 from:
t.reminder IS NOT NULL";to
t.reminder IS NULL";This should solve the issue. This was added in last version. Best regards, Nikola
Keep in mind that you will have to wait until cron job run one more time until you can see if this is working or not.
Best regards,
Nikola
Yes, after testing out the suggestion, setting it to “t.reminder is NULL” starts reminder texts to appointments that are “pending” but not to appointments already “confirmed,” because of the “IS NULL” in line 87. If I also change line 87 to “t.id IS NOT NULL AND”, then it no longer sends reminder text to “pending” appointments (good) and sends reminder texts to “confirmed” appointments (also good), but the “reminder” field does not get set in this case and remains “null.” As a result, the reminder texts for the “confirmed” appointments are sent out repeatedly every time the cron job is run (very bad).
Also, I just checked the scenario where I have a “confirmed” appointment and then “canceled” it. Because the “canceled” appointment’s entry is still in ea_twilio_reminder and with a null “reminder” flag, it still gets send a reminder text even though it’s a canceled appointment.
^ That scenario is with line 87 changed to “is NOT NULL”, that is.
Please login or Register to submit your answer