[SOLVED] Mailers stopped working after upgrade

1) just to make sure: Did you also update all the CBSubs integration plugins to the nightly ?

Yes. I also copied and pasted the cron URL into the cron job again in case it had changed.

2) On local site: Is it an identical clone of the live site in exact same state where the live site didn't queue the mails ?

Yes. Loaded from a site backup using Kickstart.

3) On live site: Maybe the same mailers have been already sent or failed maximum number of sends due to mail server config (in sent list) ?

None of the emails were queued or sent - I get copies of those that are sent. Maximum would be 20-30 per day. I did a live test today with an expected output of 6-10 emails and they weren't queued on the live site. I don't know what the email server limit is but I don't have a problem using CB Mass Mail which I think is batches of 50.

4) CB 2 and CBSubs 4 require at least PHP 5.4. Which versions do you have on site and on localhost ? if different, is it easy for you to switch your XAMPP PHP version on localhost to match the server one ? Just want to narrow down differences.

PHP Live Site version 5.6.14
PHP Local Site version 5.6.15

I wouldn't know how to downgrade my local version of PHP.

Issue could be with how you packaged and deployed your localhost to a live environment. Typically I do a straight full database export using phpmyadmin then import it. Then using FTP simply upload the files directly. Assuming you didn't hardcode in any file paths or live site URLs anywhere it should instantly work exactly how your localhost does.

I've no experience with kickstart, but the random issues reported from users who used it leads me to believe it's not entirely reliable.

The live site was deployed using Kickstart in July 2014 and the mailers all worked exactly as expected. Since then, all updates to Joomla/CB/CBSubs have been done in situ. I apply all updates to my localhost site and test before updating the live site. The mailers all worked fine until July 2015, then stopped.

I needed an up-to-date copy of the website on my localhost so backed up the live site using Akeeba Backup and used that backup with Kickstart to set up the localhost site so that I was sure everything was the same when I tested the mailers.

Mailers work on localhost but not on the live site.

I'm beginning to think the problem must be environmental, so I'm going to compare the two environments in detail and see if I can track down exactly what triggered the problem.

I'm beginning to think the problem must be environmental, so I'm going to compare the two environments in detail and see if I can track down exactly what triggered the problem.

That has to be the case as I can't imagine why it works on localhost, but not live with exact same configuration other than something server related. What is the MYSQL version on localhost compared to live site? If you were going localhost to live then it could've been the cloning software, but since it's live to localhost it's even weirder.

Are the queries on live usage stuck in an impossible state? You can test this by enabling debug mode and maximum error reporting in Joomla global configuration. Next click the process queue URL and remoe &format=raw from the URL. Now at the bottom of the page expand debugging and find queries related to _cbsubs_subscriptions.

I don't believe this! I checked the queries on the live site using debug after applying the nightly build and all the integrations; the date ranges were correct, valid and possible. So, I ran it again just now with debug as you suggested and got this:

SELECT * FROM `abs_cbsubs_subscriptions` AS m WHERE (m.`expiry_date` <= '2016-02-04 21:30:36') AND (m.`expiry_date` >= '2016-02-19 21:30:36') AND m.`plan_id` = 3 AND m.`status` = 'A' ORDER BY m.`id` DESC

Unless I am reading this wrong (it's getting late here!) it's testing for EARLIER THAN/EQUAL 4th February 2016 AND EQUAL/LATER THAN 19th February 2016 which is impossible!

I checked all the other _cbsubs_subscriptions queries and they are all impossible.

Shall I try applying the latest nightly build and the integrations again tomorrow?

autobahn wrote: I don't believe this! I checked the queries on the live site using debug after applying the nightly build and all the integrations; the date ranges were correct, valid and possible. So, I ran it again just now with debug as you suggested and got this:

SELECT * FROM `abs_cbsubs_subscriptions` AS m WHERE (m.`expiry_date` <= '2016-02-04 21:30:36') AND (m.`expiry_date` >= '2016-02-19 21:30:36') AND m.`plan_id` = 3 AND m.`status` = 'A' ORDER BY m.`id` DESC

Unless I am reading this wrong (it's getting late here!) it's testing for EARLIER THAN/EQUAL 4th February 2016 AND EQUAL/LATER THAN 19th February 2016 which is impossible!

I checked all the other _cbsubs_subscriptions queries and they are all impossible.

Shall I try applying the latest nightly build and the integrations again tomorrow?

Apply latest nightly CBSubs and mailer, and also check the conditions of the mailer, obviously there is an incompatibility. Read carefully texts and descriptions of conditions, yes better tomorrow, once you are well-rested