Skip to main content
Share Your Experience: Take the 2024 Developer Survey
5 votes
Accepted

With the Job Report Sender can multiple reports be sent from the same job, e.g. instanaceId=1, instancesId=2, instanceId= 4

You will need to create a Schedule job for each report separately.
Pradeep Nayak's user avatar
4 votes

Send welcome message at signup date, not membership 'start date'

Another option if you are using civicrm v4.6 or higher would be to use the date of the activity type "Membership Signup" to trigger a 'reminder'.
JoAnne's user avatar
  • 3,450
4 votes

Send welcome message at signup date, not membership 'start date'

When a membership is created there is both a 'join date' (member since) and a 'start date' You should be able to set up a scheduled reminder to be triggered based on the 'join date' and you should ...
petednz - fuzion's user avatar
  • 28.3k
4 votes
Accepted

CV Scheduled jobs not firing from cron

Ok so this may seem like a silly issue to some but after some messing around I figured out cron didn't have access to the path where CV was installed so to fix it the crontab entry had to be changed ...
tanbog's user avatar
  • 317
4 votes

Scheduled job execution time is creeping

This is a problem that's popped up and been squashed a few times - it's a little trickier to fix than it seems. The current conversation about it is on Gitlab but CRM-17671 provides some historical ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

civimail sometimes stuck on running via Scheduled Jobs screen

Using "Execute Now" from Scheduled Jobs isn't safe because your web server settings (in php.ini) will specify a maximum amount of time a page can run before it times out. If you're ...
Jon G - Megaphone Tech's user avatar
3 votes
Accepted

Relationship disabled by end date but still enabled?

The "Disable expired relationships" scheduled job should set the is_active field to 0 for relationships with a past end date. A bit of history: Civi has always treated both past and disabled ...
davejenx's user avatar
  • 2,365
3 votes

Civi Event scheduled reminders error - missing date causes DB syntax error

Problem a result of a reminder that has no sending date. (see attached image) This error results in a syntax error that prevents all subsequent reminders from being sent. Solution is to add date or ...
Dave T's user avatar
  • 1,239
3 votes

Cron not working after forcing https

The most likely causes for breakage with this change are: Cron job is pointing to HTTP only curl by default will not follow 302 redirects, while wget will. If you're using curl, it won't work ...
Chris Burgess's user avatar
3 votes
Accepted

Is there any reason to not run the scheduled job Clean-up Temporary Data and Files every hour?

Check how long it takes to run on your system. if it doesn't take too long, I don't see any reason not to run it hourly.
Xavier's user avatar
  • 10.2k
3 votes

What causes the SMS system to stop working and throw DB errors?

This error does show up in Civi 4.7.8 on Drupal 7.x. @PeteRoss Thanks. Haven't had chance to upgrade to 4.7.9 yet. Had to send scheduled event SMS to members, so modified sql in if statement in CRM/...
Raj's user avatar
  • 41
3 votes

Process Inbound Emails Failed: No mail protocol

At Administer > CiviMail > Mail Accounts (civicrm/admin/mailSettings) you want to see two accounts configured, one for Bounce processing and one for Activity processing It's possible what you're ...
Chris Burgess's user avatar
3 votes

Manually started scheduled email not completing

Do you have a cron job configured for CiviCRM that runs periodically? Can you check CiviCRM and/or Apache Error log for any errors? Scheduled Mailing jobs are executed in batches of 1000 or the ...
Pradeep Nayak's user avatar
3 votes

My Scheduled Jobs Log doesn't display a date or time

The run_time field is set to current timestamp by default and its a not null field which mean that run_time will never NULL values. Can you please check you schema for civicrm_job_log. I am pasting ...
Pradeep Nayak's user avatar
3 votes
Accepted

Send Schedule Mailings job succeeds but scheduled mailing not completely sent

We found that applying this line's change from this PR to the mosaico extension solved our problem: https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/pull/182/files#diff-...
Joe Murray's user avatar
  • 6,741
3 votes

DB Error: connect failed when trying to call Job.execute using cli.php?

First, you can view the error with greater detail if you enable "Debug and Backtrace", or view the CiviCRM log. The troubleshooting documentation will tell you how to do both. Second, I would assume ...
Jon G - Megaphone Tech's user avatar
3 votes

Is there a way NOT to email if a report with no result

As suggested by Demerit you can use alterMailParams to abort the email if the report has 0 rows. It will work on simple use case but would be difficult or need to add more logic you passing any ...
Pradeep Nayak's user avatar
3 votes
Accepted

How to stop Mailing Queue from civirules?

Rules run by delayed action should be in the civicrm_queue_item table. Please be sure not to delete any other rows that may be in there!
Jon G - Megaphone Tech's user avatar
3 votes
Accepted

Modify emailed reports content

UPDATE: Since 5.29 you can do this in an extension do like the override example at https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar In the extension's main file example.php: ...
Demerit's user avatar
  • 23.1k
3 votes
Accepted

How do you properly setup scheduled job for report mailings?

The format is instanceId=1 format=csv No brackets. The format parameter value can also be print for printer-friendly HTML. If no format is specified it will send as PDF. If you are doing this in ...
Andy Burns's user avatar
  • 3,681
3 votes
Accepted

Not receiving email from Scheduled Reminder for Activity

OK, answering my own question after much investigation. This was a bitnami civiCRM stack and the crontab to run Job.execute was running as the bitnami user (our error), but needed to run as daemon. ...
danielrobertson's user avatar
3 votes
Accepted

Membership status changing from Grace to Expired a day later than expected

The 'Fixed Period Rollover Date' relates to the start of memberships and is not relevant here. This is about date maths ... Grace is defined as End Date (Dec 31) to End Date + 6 months. So what date ...
Aidan's user avatar
  • 13.5k
3 votes
Accepted

How do I access drush commands specific to CiviCRM?

The readme for cv needs updating. It's now tested pretty well with drupal 8. I would use cv instead. See also https://lab.civicrm.org/dev/drupal/-/issues/76
Demerit's user avatar
  • 23.1k
3 votes

Scheduled Job -- Mail report - cannot find InstanceID

You have instanceID with a capital D. It wants instanceId.
Demerit's user avatar
  • 23.1k
3 votes

Cronjob for CiviCRM with drush 10: The "-u" option does not exist

I don't know if there still is a way to use drush but I got the cronjob working with cv: composer require civicrm/cv And then the crontab is: * * * * * /var/www/path_to_civi_project/vendor/civicrm/cv/...
Tobias Krause's user avatar
3 votes

CIVICRM_TEMPLATE_COMPILEDIR / template_c folder becomes too large. How to empty it periodically?

The action Job.cleanup has a parameter tplCache which is set to 0 by default. When the action is called with the parameter set to 1 the folder gets emptied. Create a new scheduled job Choose "...
Tobias Krause's user avatar
3 votes

Create automation to add membership for all in group

Welcome to CiviCRM SE. You can use Civi Rules extension, and create a rule with trigger > 'Contact is Added to the Group' Condition > Group = ABC Action > Add membership HTH Pradeep
Pradeep Nayak's user avatar
2 votes
Accepted

Error Fetching HTTP headers - iATS Recurring contribution

Sorry - we've not seen this (yet) - best to post an issue on our GitHub queue: https://github.com/iATSPayments/com.iatspayments.civicrm - so that both Alan and myself as well as iATS staff sees this. ...
KarinG - Semper IT's user avatar
2 votes
Accepted

iATS ACH/EFT payment verification scheduled job not finishing

Your symptoms suggest that the issue is some kind of fatal error happening during the job execution itself. I'd recommend you run the job directly via the command line, i.e. something like drush -u 1 ...
Alan Dixon's user avatar
  • 6,851
2 votes
Accepted

Can a Scheduled Job using mail_report send Reports as HTML in the e-mail body, rather than as a PDF attached to the e-mail?

Yes, you can send a report as printer-friendly HTML, in the body of a Scheduled Job e-mail, using mail_report. Go to Administer -> System Settings -> Scheduled Jobs. Edit the Scheduled Job ...
Joe McLaughlin's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible