5

Using CiviMail in Civi 4.7.29, any bulk email is delayed by 5 hours. The cron commands are received every 30 minutes, and are acknowledged by Civi on the status page. Have checked that php, joomla and civi are all set to London time zone. These are small test mailings of about six users. Any ideas? Thanks in anticipation. John

  • I have learnt enough, I think, after 6 months to solve my problem. I inserted a single line in clip.php: "date_default_timezone_set("Europe/London");" and now emails are sent straight away. This is probably obvious, but it took me so long to find a solution. – John A Mar 21 '18 at 17:18
3

I would look at the scheduled_date on the mailings in your database: SELECT name,scheduled_date FROM civicrm_mailing; If the scheduled_date is off, then it might be that MySQL has a time mismatch - or that specific users in Joomla have a different timezone setting than the default (not sure if this is possible in Joomla, but it can be done in WordPress/Drupal).

If the scheduled_date is correct, then I'd check to see that your cron user is running in the same time zone. E.g. if cron is triggered by root and not the web server user, I'd expect this sort of issue to creep in.

EDIT: You mention that you're running cron via the "cli.php" tool. That means that PHP is using a different php.ini file than when you do web-based PHP, and your timezone might be different. If you have terminal access, check your timezone with php -i | grep zone.

Since you're using Siteground, I doubt they allow you to control the php.ini timezone. Since that's the case, I would recommend using the HTTP Method of running cron, which will set the timezone based on the web-based timezone.

  • Thanks for your answer. I looked at the scheduled date, and that was fine. SiteGround have confirmed that the server time is 5 hours behind. I don't understand how to investigate the second part of your answer. Could you explain further? Thanks. – John A Mar 2 '18 at 19:33
  • Do you know how your cron is set up? If so, please give more detail and I can give you suggestions on investigating further. – Jon G - Megaphone Tech Mar 3 '18 at 5:52
  • Cron runs from the from SiteGround cpanel: "php /home/site/public_html/administrator/components/com_civicrm/civicrm/bin/cli.php \-u user \-p pwd \-e Job \-a execute". – John A Mar 3 '18 at 13:00
  • @JohnA See my edit above. – Jon G - Megaphone Tech Mar 5 '18 at 15:17
  • Thanks Ed. Have tried this. Used the command : https://<URL>/administrator/components/com_civicrm/civicrm/bin/cron.php?name=username&pass=pwd&key=key but email says"https://<URL>/administrator/components/com_civicrm/civicrm/bin/cron.php?name=username" no such file or directory. I can't get the syntax quite right. – John A Mar 6 '18 at 12:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.