Mailer not finding data

Kyle,

It should find 41 records. It's not finding the other 40. There something in the mailer search that is negating the inclusion of these 40 records. I can try to update my SQL if I know the other CBsubs table it is checking and the criteria. I checked the data (Subscription Expiry Date) and other condition requirements of the mailer and they are fine. It should be pulling the records. I need to find why they are getting excluded.

Thanks,
Joe

The mailer just queries _comprofiler and _cbsubs_subscriptions to build its list of recipients. Then they're added to the _cbsubs_mailer_mailqueue table and when sent added to _cbsubs_mailer_sentmails table. I'm not sure how this helps you any. What version of CBSubs where you on before migrating? Was it also the latest version?

You can see the actual query as well by enabling debug mode and maximum error reporting then accessing the URL without &format=raw and in Joomla's debug bar at the bottom the queue will be in the queue debug section.