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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.4 Release Testing »
  • 4.4alpha2: Can't run any cron tasks for process_mailing
Pages: [1]

Author Topic: 4.4alpha2: Can't run any cron tasks for process_mailing  (Read 1505 times)

richmahn

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.4alpha2
  • CMS version: Drupal 7.23
  • MySQL version: 5.3
  • PHP version: 5.3
4.4alpha2: Can't run any cron tasks for process_mailing
August 27, 2013, 04:51:39 am
I am using the same crontab script as I did for 4.3.5, changed it to have my new Drupal website, no other cron jobs but process_mailing and fetch_bounces, and it doesn't process the mailing list I have schedule in the queue. I have sent many mailing lists just fine with my cron setup in 4.3.5 and am a sysadmin so know what I'm doing. Now if I go to a report of the mailing it is still scheduled (not running) and none have been sent.

Has anyone successfully gotten 4.4alpha1 or 4.4alpha2 sending mailing list jobs??? Thanks.

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
August 27, 2013, 01:49:31 pm
Same for me with 4.4Alpha2, I just tried a test mailing - the cron task ran but without any emails being sent.  The mailing is still showing as Scheduled, and also I notice that the cron job has a  "Started" message but no "Finished" message so it looks like maybe it crashed?
« Last Edit: August 27, 2013, 01:53:58 pm by clarkac »
Andy Clark

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
August 28, 2013, 04:07:09 am
We 'll investigate this and get back to you.

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
August 28, 2013, 06:52:46 am

Here's the patch :
https://github.com/civicrm/civicrm-core/pull/1531.patch

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
August 29, 2013, 05:17:44 am
This problem is now fixed in Alpha3 - thanks!
Andy Clark

richmahn

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.4alpha2
  • CMS version: Drupal 7.23
  • MySQL version: 5.3
  • PHP version: 5.3
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 11, 2013, 05:41:56 am
I'm on 4.4beta now, but still my cron task for sending mail and checking bounce mail doesn't seem to be working. Are these the right params for cron mailing still? (this is on Drupal 7, script takes me to the civicrm directory, then executes this with php)

bin/cli.php -j -sdefault -u <drupal_civicrm_user> -p <user_password>  -e Job -a process_mailing
bin/cli.php -j -sdefault -u <drupal_civicrm_user> -p <user_password>  -e Job -a fetch_bounces

Doesn't work for me...no mails get sent. If I do it manually with this:
http://example.com/civicrm/admin/job?action=export&id=1&reset=1

It sends 10 emails still and then gives me this error:

Sorry but we are not able to provide this at the moment.
DB Error: no such table
Return to home page.

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 11, 2013, 07:47:41 am
I'm on beta1, using Drupal 7 and here's my cron which is working ok

wget  -O - -q   -t 1 http://www.example.com/sites/all/modules/civicrm/bin/cron.php?name=admin\&pass=xxxxxxxx\&key=012345678901234
Andy Clark

richmahn

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.4alpha2
  • CMS version: Drupal 7.23
  • MySQL version: 5.3
  • PHP version: 5.3
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 11, 2013, 06:24:20 pm
So is it just better to use the wget method and not the cli.php method?

Is anyone getting the "Table not found" error if you send mailings manually from the CiviCRM admin menu?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 12, 2013, 12:19:49 am
richmahn :

We 'll investigate this and get back to you soon.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 12, 2013, 12:34:39 am
For your reference :
http://issues.civicrm.org/jira/browse/CRM-13381
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

ravish

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: CiviCRM 4.3
  • CMS version: Drupal 7.19
  • MySQL version: 5.5.29
  • PHP version: 5.4
Re: 4.4alpha2: Can't run any cron tasks for process_mailing
September 12, 2013, 04:10:05 am
Hi

I ran the cron job for "Send Scheduled Mailings" from civicrm scheduled Jobs page (civicrm/admin/job?reset=1) but was not able to replicate the "Table not found" error you mentioned.
I also tried running it through cli which also worked fine at my end. The mails are sent and the mailing status also gets updated to "Completed" from "Scheduled".
To run the cron through cli, I did the following:
Through terminal, I went inside the bin folder i.e. cd <drupal_folder_name>/sites/all/modules/civicrm/bin
Then I ran the following command:
php cli.php -j -sdefault -u  <drupal_login_username> -p  <drupal_login_password>  -e Job -a process_mailing
Could you follow the above steps and check if it works at your end?
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.4 Release Testing »
  • 4.4alpha2: Can't run any cron tasks for process_mailing

This forum was archived on 2017-11-26.