[SOLVED] [#6906] Auto Email Reminders - 7, 14, 28 days

Ah, I see the issue. It's not working for users with as lastvisitDate of 0000-00-00 00:00:00 in the database. Math against that will be far more than 5 years old. This means "But do not send message if it's later than" needs to be set to "And no other date condition" for that to work, but you can't select "And no other date condition" due to validation bug. Will be fixing that bug and in the mean time bypassed the jQuery validation by modifying the DOM so "And no other date condition" could be saved.

This fixed it on my local tests, but your install still isn't adding to the queue. After enabling debug mode and removing &format=raw from the URL the below are thrown.

#6876


Your install is hitting memory limits and can't process all those users into the queue. Sending emails has batching capabilities, but queuing emails does not. Have added a feature ticket for this. I don't have a workaround to suggest beyond increase memory limits from 128mb to maybe 256mb.

#6875

Hi Kirelon

I had a look at this yesterday thank you for finding the issue i wuold have never found that. I upped the memory limit to 256mb and ran the email queue. I did get a 504 timeout error however over 6000 users were put into the mail queue.
The problem is now however, none of the emails in the queue are being sent it just keeps saying there is no emails in the email queue even though there is over 6000 records.

Are you using the link that triggers actual sending of the queue? There's 3 URLs. 1 adds to queue, 1 sends queue, 1 does both.

I used the first link and queued the emails. I try the second email and it says there isn't any emails in the queue.
Also we have the third link set up as a cron job which seems to be adding the emails to the queue but not sending the emails.

Have reviewed your install and I'm not sure why the queue isn't sending. I'm not seeing any errors output either. Looks like there's a conditional check to see if it's too soon or too late to send the email. Within the _cbsubs_mailer_mailqueue database table review both time_to_mail and time_too_late to ensure they're not empty or too far in the past/future. Looks like if the current datetime is greater than time_too_late then it won't send that mail.

Hi Krileon

I have checked the database, having looked at the first 100 records and the last 100 records, all the time_too_late fields are set to NULL. By the sounds of it this field should be populated? Is there a certain value we need to enter to fill this field or should it be populated automatically?