Joomla 3.9.2
MySQL 5.6.40
PHP 5.6.40
CB 2.4.0
CBSubs 4.3.0 latest

---

We noticed a significant drop in membership the last 3 months or so. We use the mailer function to send out a renewal reminder a week before membership expiry and we send out an expiry mail.

It seems that a large number of expiries are not getting the renewal reminder. I correlated the table #__cbsubs_mailer_sentmails with #__cbsubs_subscriptions for expired subscriptions (status X) in the month of December 2018. Of expired 199 expired subscriptions, only 126 emails were sent (matching on user_id). It went across plans, that is, it wasn't that some plans were sending reminders and others weren't.

I also set up a test case of a new subscription which I adjusted to expire in 10 days, and the 1-week email was never sent (not in the log), although others a day before and a day after were.

I am also wondering whether the emails on expiry are being sent, but I haven't found a way to check that, as it doesn't seem to go through the mailer function. Error logs show nothing of interest.

Mailer config is attached.

The vast majority of missing emails are for the first membership expiring, so earlier emails would not have been sent.

How will a member not qualify for any mailers?

Here's the config for the specific mailer.

Some of our problem is due to specifying 1 email per user.

However, I have found many users with a single subscription who were never sent an email 1 week prior to expiry.