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) »
  • Scheduling mail "immediately" schedules it four hours in the future
Pages: [1]

Author Topic: Scheduling mail "immediately" schedules it four hours in the future  (Read 800 times)

holmesg

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 0
  • CiviCRM version: CiviCRM 4.3.4
  • CMS version: Joomla! 2.5.8
  • MySQL version: 5.1.70
  • PHP version: PHP Version 5.3.22
Scheduling mail "immediately" schedules it four hours in the future
September 19, 2013, 06:12:33 am
When I schedule a mailing to send "immediately" in Civimail, it is actually scheduled to run four hours in the future.

Changing the "Server Time Zone" in Joomla from UTC to the server's actual time zone doesn't change anything. "Immediately" still equals "four hours from now".

Is there anything I can do to fix this?

holmesg

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 0
  • CiviCRM version: CiviCRM 4.3.4
  • CMS version: Joomla! 2.5.8
  • MySQL version: 5.1.70
  • PHP version: PHP Version 5.3.22
Re: Scheduling mail "immediately" schedules it four hours in the future
September 19, 2013, 06:33:40 am
I tried scheduling the mail in the near future as a workaround. No dice ... "Start date cannot be earlier than the current time".

I don't have control over the server time zone. Is there a way to fix this issue, perhaps in the configuration?

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: Scheduling mail "immediately" schedules it four hours in the future
September 19, 2013, 07:06:00 am

unfortunately civi does not deal with timezones at all :( So no config options here. This is one of those projects which has been on the plate for a long time but not worked on :(

Did u try changing the timezone in php.ini to match the db server time zone?

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

holmesg

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 0
  • CiviCRM version: CiviCRM 4.3.4
  • CMS version: Joomla! 2.5.8
  • MySQL version: 5.1.70
  • PHP version: PHP Version 5.3.22
Re: Scheduling mail "immediately" schedules it four hours in the future
September 19, 2013, 07:54:42 am
Quote from: Donald Lobo on September 19, 2013, 07:06:00 am
Did u try changing the timezone in php.ini to match the db server time zone?

That seems to do the trick!  Thanks :)

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Scheduling mail "immediately" schedules it four hours in the future
October 14, 2013, 10:13:55 am
I'm encountering that issue as well. I'm working locally via WAMP.

Being unable to adjust the time makes it next to impossible to do any testing - having to wait 3 hours to see if a mailing works is not conducive to productivity.

Quote from: Donald Lobo on September 19, 2013, 07:06:00 am
Did u try changing the timezone in php.ini to match the db server time zone?

Yes, tried that. Not changing anything (yes, i've restarted the service). Tried adjusting the time in the WP settings as well.

Any other work around suggestions would be greatly appreciated.

I saw from the bug tracker that this was something that was listed in 2007. And it was closed in 2012 as one of "too many bugs to address". It may not be my place as a newcomer to CiviCRM to say this, but frankly, it seems to me to be a rather critical issue to fix, which should receive some priority.

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: Scheduling mail "immediately" schedules it four hours in the future
October 14, 2013, 10:52:39 am

a few comments:

a. for most folks who host at ISP's / locally their webserver and mysql server are on the same timezone.

b. agreed that if you encounter this issue, this is a fairly critical issues. Any chance you/your org can contribute resources to fix this issue? As a FLOSS project, we do rely on folks helping out to "scratch their own itch".

We can help you get started on IRC. The developer handbook is a also a good first step

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

vavroom

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 4
    • Part of a Whole
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Scheduling mail "immediately" schedules it four hours in the future
October 14, 2013, 11:00:14 am
My organisation can't contribute resources, unfortunately.

I've been quite involved with FLOSS projects (was even on the Core Joomla! team for a while), so am familiar with the idea of contribution. Myself, I'd be happy to help, however this is way beyond my area of knowledge. My area of expertise is along the lines of accessibility/HTML/CSS. 

Thanks
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Scheduling mail "immediately" schedules it four hours in the future

This forum was archived on 2017-11-26.