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'.
user avatar
  • 3,440
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 ...
user avatar
  • 27.2k
4 votes
Accepted

Mailings are started but not sent - What is the difference between a scheduled job and "Run it now"?

It seems that there is a bug in CiviCRM 4.7, 4.7.1 and 4.7.2 which causes these symptoms (scheduled mailing stuck at "running" without actually sending, but will send using Execute Now). See here and ...
user avatar
  • 1,222
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 ...
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 ...
user avatar
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 ...
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 ...
user avatar
  • 2,345
3 votes

Update membership status automatically

I think the reminders portion of the memberships has migrated to "Scheduled Reminders" but I believe the status update portion remains in the "Scheduled Jobs" area. Once you get to 4.7 that warning ...
user avatar
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/...
user avatar
  • 41
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.
user avatar
  • 10.1k
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 ...
user avatar
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 ...
user avatar
  • 1,139
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 ...
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-...
user avatar
  • 6,671
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 ...
user avatar
3 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 ...
user avatar
  • 323
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!
user avatar
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 ...
user avatar
  • 2,914
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 ...
user avatar
  • 11k
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
user avatar
  • 17.9k
3 votes

Scheduled Job -- Mail report - cannot find InstanceID

You have instanceID with a capital D. It wants instanceId.
user avatar
  • 17.9k
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. ...
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 ...
user avatar
  • 5,994
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 ...
user avatar
2 votes

Schedule Jobs Page on Multisite

This is actually the correct interface. I believe you're trying to compare the "List Scheduled Jobs" interface with the "Edit a single Scheduled Job" interface. If you press "Edit" next to any ...
user avatar
2 votes
Accepted

Update Membership Statuses

the warning is about how Reminders are managed. In terms of the Scheduled Job - yes you need that enabled if you want to have the Membership Status automatically updating (and it would a rare ...
user avatar
  • 27.2k
2 votes
Accepted

How can I get $params into my own scheduled job?

This is what I have: (I know you can read it :-) And in my code: function civicrm_api3_note_Migrate($params) { // param migrate_type determines what will be selected, defaulted to contact $...
user avatar
2 votes

I am trying to set up easycron

The username and password are for a WordPress user. I would recommend setting up a user specifically for this purpose and don't use it for anything else. You will need to give the user the correct ...
user avatar
2 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 ...
user avatar
2 votes

CIVICRM mailing links not working properly in schedule job

We are having this problem as well, also in WordPress 4.9.2. We have discovered that the issue arises because permissions get corrupted. According to SiteGround, our host, these permissions in ...
user avatar

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