CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Schedule mailings not working; test emails and scheduled reminders working
Pages: [1]

Author Topic: Schedule mailings not working; test emails and scheduled reminders working  (Read 5630 times)

andyg8

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
  • CiviCRM version: 4.3.2
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.30-cll
  • PHP version: 5.3.22
Schedule mailings not working; test emails and scheduled reminders working
August 06, 2013, 01:31:14 pm
Hi folks,
I've read the previous post: 'If you have a problem with the cron job/bounces/ can't send...' and didn't find an answer so I hope I haven't missed something obvious.

Our scheduled reminders are working, as is our test out going email and all other email tasks such as receipts, confirmations etc.

However, Scheduled emails are not sending. The process of setting up a Schedule mailing appears to be working fine, and test emails sent during the process work perfectly. It shows the expected number of recipients. However, when we approve the email for scheduled send two things aren't right:
1. We don't get the email
2. In the table of Scheduled and Sent mailings the columns for Scheduled, Started and Complete are completely blank. The status field says 'scheduled' and all other things appear ok.

This unhelpful behaviour occurs whether the schedule is for 'send immediately' or some later time.

The cron job is set for 10 minutes in our Cpanel, and the Send Scheduled Mailings job in System Settings>Scheduled Jobs is set to run 'whenever the cron job is run'.

We only have one cron job on our site (its for civicrm) and we know it is working because Scheduled Reminders are working. It's format is: wget '[path to our site]/drupal/sites/all/modules/civicrm/bin/cron.php?name=[user]&pass=[password]&key=[our key]'. Time is Minute: '0,10'.

There may be some clue in this observation: while the Scheduled reminders do work, they arrive anywhere within 10 - 50 minutes. The Scheduled Reminders job is set to run 'whenever cron job is run'. We can't reconcile that 10 - 50 mins with a cron job setting of '0,10'.

We'd be grateful for your help. Thanks.

sibro

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 2
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Schedule mailings not working; test emails and scheduled reminders working
November 18, 2013, 02:59:56 pm
I am seeing a very similar problem. The test works well, but the email is never sent. In addition the email is neither in the sent or draft list. We tested on 4.2.7 and it worked fine. After upgrading to 4.3.7 it fails.  I had to give it Schedule authority on 4.3 so the schedule tab showed.  I removed approval authority as it was taking a mysql error.

Has anybody gotten around this issue and got the mail to go out.
Bruce

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Schedule mailings not working; test emails and scheduled reminders working
November 18, 2013, 10:03:29 pm
You might find it hard to get support on these unless you at least upgrade to the latest 4.3 version - otherwise this all might have already been sorted - though these problems are not usually 'civi' problems per se rather than with the cron or another step
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

sibro

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 2
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Schedule mailings not working; test emails and scheduled reminders working
November 19, 2013, 05:53:21 am
I am at 4.3.7, 4.3.8 was a security update.

The cron job runs every 10 minutes, but misses the the mass mailings
Bruce

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Schedule mailings not working; test emails and scheduled reminders working
November 19, 2013, 08:25:55 am

is the process mailing job enabled on your jobs page?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

sibro

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 2
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Schedule mailings not working; test emails and scheduled reminders working
November 19, 2013, 08:51:58 am
Donald, Yes Send Scheduled Mailings is marked Always and is running every 10 minutes from the log.
Code: [Select]
Scheduled Mailings
0
Summary
Finished execution of Send Scheduled Mailings with result: Success (a:0:{})
Details


Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:0:{}
I saw the records in the database but for the job I am trying to run it does not show on either the draft or sent page.
Bruce

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Schedule mailings not working; test emails and scheduled reminders working
November 19, 2013, 09:27:16 am

sorry dont know :( I suspect your next step would be to get into the code and debug the issue

Please do update this forum post when you figure it out, so others can benefit

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

andyg8

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
  • CiviCRM version: 4.3.2
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.30-cll
  • PHP version: 5.3.22
Re: Schedule mailings not working; test emails and scheduled reminders working
December 13, 2013, 07:44:04 am
Hi folks, looks like you may have resolved this, but in case this is useful:

We did have this problem a little while ago - we did resolve it by trying a number of clean up activities.
The process below might help.
Some of these are things we do as part of general tidy up and you can also try an update.
Obviously take a file and Db back up first.

 Access the Db - locate the CiviCRM mailing (civicrm mailing & civicrm mailing_job) tables - have you started using mailings yet? If not you are probably OK to clear all mailings. Or just clear the scheduled ones
 Access the Db - then empty/truncate all CiviCRM cache entitled tables
 Run the CiviCRM scheduled job (Admin>System settings>Scheduled jobs) - clean up temporary data and files
 Then access FTP, and empty:
<drupal-root>/sites/default/files/civicrm/templates_c/*
<drupal-root>/sites/default/files/civicrm/ConfigAndLog/Config.IDS.ini
<drupal-root>/sites/default/files/civicrm/ConfigAndLog/*
<civicrm_custom_extension_folder>/cache/*
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Schedule mailings not working; test emails and scheduled reminders working

This forum was archived on 2017-11-26.