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) »
  • Scheduled mail is sent at next CRON job instead of at scheduled time
Pages: [1]

Author Topic: Scheduled mail is sent at next CRON job instead of at scheduled time  (Read 999 times)

hwdornbush

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 0
Scheduled mail is sent at next CRON job instead of at scheduled time
June 23, 2010, 11:34:02 am
I am running with Drupal 6 and have seen this problem on both CiviCRM 3.0 and 2.2.

I set up a mailing and set a schedule time in the future.  I check the schedule and it shows correctly.  But the mailing goes out the next time CRON runs.

For example, I set up a test mailing this morning to be processed tomorrow, June 24, at 1 am.  The Scheduled and Sent Mailings showed it as scheduled then.  A few minutes later, the test mailing showed up in my inbox, and the Scheduled and Sent mailings listing showed it as scheduled at the time I created the schedule, June 23 at 11:23 am, rather than June 24, and it was sent 7 minutes later, at 11:30 am, when CRON ran.

The database and code run on the same server, and I checked the date with the date command, and it shows correctly.

What could be causing this?

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Scheduled mail is sent at next CRON job instead of at scheduled time
June 24, 2010, 11:18:38 am
Quote from: hwdornbush on June 23, 2010, 11:34:02 am
I set up a mailing and set a schedule time in the future.  I check the schedule and it shows correctly.  But the mailing goes out the next time CRON runs.

I assume that by this you mean that the mailing is sent earlier than the scheduled time.

Can you try scheduling a mailing a couple of days in advance and seeing whether it will actually be sent on the next cron run, or only later, when the scheduled time gets ‘closer’?

If so, my guess is that your Apache/PHP and your MySQL timezones differ.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

hwdornbush

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 0
Re: Scheduled mail is sent at next CRON job instead of at scheduled time
June 24, 2010, 11:43:45 am
I first ran into this two months ago, when I scheduled a newsletter to be sent in a week, and it was sent on the next Cron run, much to the dismay of my customer.  I just tested it again, to schedule a newsletter to be sent on June 29 (it is now June 24) and the newsletter was mailed when Cron ran.  I attach two screen shots.  "Scheduled" was taken when I scheduled the newsletter, and "Actual" was taken just a minute ago, after Cron ran.  Note the difference in the time and date scheduled vs. actual.

It doesn't happen when the time is close.  It happens days in advance.

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: Scheduled mail is sent at next CRON job instead of at scheduled time
June 24, 2010, 12:00:02 pm

both the dates show june 24th, i.e today?

are u saying the the scheduled date is disregarded and today is recorded instead?

if so, can u run a small test on demo and see if the problem occurs there

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

hwdornbush

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 0
Re: Scheduled mail is sent at next CRON job instead of at scheduled time
June 26, 2010, 08:41:02 am
Yeah, the screen shot was not correct.

However, I tried it again and this time, it worked just fine.  I can't explain the earlier attempts but it seems to be working fine now.

capoyeti

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
Re: Scheduled mail is sent at next CRON job instead of at scheduled time
December 13, 2010, 11:18:57 am
Rather than start a new topic - I'm experiencing a similar problem. Scheduled mails go out on the next cron run, and not on the scheduled time. This is both with scheduled date/time set a couple of hours (after the next cron job run), as well as several days in the future.

While this OP seems to have 'fixed itself' does anyone have any other input to assist?

Thanks
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Scheduled mail is sent at next CRON job instead of at scheduled time

This forum was archived on 2017-11-26.