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

NULL is fine. Means there's no end time. I'm unsure what's preventing the mailer queue from sending at this time. The time_to_mail should be less than or equal to the datetime the mailer is being processed. time_too_late should be less than the current datetime (NULL is fine). Finally state should be "A". Those seam to be the only conditions being checked for the mailer queue processing. Do all 3 columns look ok in your database?

Here's a screenshot - screenshots.firefox.com/iqSd2L80NTfjwU2y/sau-0ee6c-or.servercontrol.com.au

Everything looks fine in the database. I changed the first record date to a date in the future to just test but still nothing is being sent from the queue.

Ok, I've confirmed it's time_too_late being NULL causing it. I removed that check and it was able to find mailer queues to send. The query is as follows, which you can run directly on your database

.

Remove the time_too_late check and it'll find results. I don't think time_too_late is actually supposed to be NULL. Best I can suggest is as a workaround is to run an update query to set time_too_late to time_to_mail if NULL. Example as follows.


I've added a bug ticket to further look into this.

#6906

Okay I ran the select query and it returned nothing. Removed the time_to_late and returned all records.

I ran the update command but it still did nothing. I needed to make the time_to_late a date in the future not the same, so I set it to roughly +1 year (just changed it to 2018). The cron job seemed to have ran and 100 emails were sent so I can confirm it is working now with a time_to_late set into the future, is that correct?

Could you let us know if it indeed is a problem with NULL and if it is let us know when the patch is released so we can apply it to the website?

Thanks for all your help.

New nightly release with fix is now in downloads, please make sure to updated both the main CBSubs plugin as well as the CBSubs Mailer plugin.

Thanks we will add these both to our installs on Monday.
Since we have been able to get some messages out we have now had another issue, Yahoo and a server based in Russia have not blocked our server and will not allow emails to be sent through there system.

We are in the process of appealing these bans, but part of the requirement to lift the ban is that we MUST have an option to opt out of messages.
How can we manage this within the system of Community Builder?

Examples of unsubscribe facilities that are clearly worded and easy to use include:
- Email—'Unsubscribe: if you no longer want to receive messages from us, simply reply to this email with the word "unsubscribe" in the subject line.'
- Email—'If you no longer want to receive these messages, please click the "unsubscribe" button below.'

www.acma.gov.au/Industry/Marketers/Anti-Spam/Ensuring-you-dont-spam/spam-spam-act-2003-faqs
www.acma.gov.au/Industry/Marketers/Anti-Spam/Ensuring-you-dont-spam/mandatory-unsubscribe-ability-ensuring-you-dont-spam-i-acma
www.lsoft.com/resources/optinlaws.asp