4
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'.
4
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 get what you need.
4
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 here. I spent a day trying to find the problem before I came across the bug report, so hopefully this will save others some time looking for a misconfiguration ...
4
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 perspective.
Your best short-term solution is probably Xavier's answer on a very similar question.
answered Jan 18 '19 at 17:34
Jon G - Megaphone Tech
35.7k1 gold badge26 silver badges93 bronze badges
3
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 automatically when pointed to the non-SSL URL (not without -L, anyway). The 302 redirect can make this less obvious, since everything else that points to http "just ...
3
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
relationships as "inactive" however there were inconsistencies in some
of the code (reports maybe) that were not doing so. I believe Fuzion
contributed the ...
3
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 about reminders is gone:
3
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/Mailing/BAO/MailingJob.php
525 if ($mailing->sms_provider_id) {
....
....
546 OR contact_a.do_not_sms = 0 )
- 547 ...
3
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.
3
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 describing is what happens when there is no account configured for activity processing. If so, the error message is a bit misleading, but I suspect that's what you'...
3
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 disable reminder with no date. (ConfigAndLog error messages show the ID for the reminder that has the error.)
Will report as a bug with recommendation that ...
3
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 batch limit specified under Administer >> CiviMail >> Mailer Settings.
If the recent Schedule job log says 'Started' then the last job was terminated because of ...
3
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-d8205fe762b98a885815f3d4bb175886R294
3
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 that "connect failed" is a MySQL error. Is it possible that you have two civicrm.settings.php files in your path, one with the wrong MySQL password?
Finally -...
answered Jul 6 '18 at 20:08
Jon G - Megaphone Tech
35.7k1 gold badge26 silver badges93 bronze badges
3
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 to:
*/5 * * * * /usr/local/bin/cv api job.execute --user=admin --cwd=/var/www/html/siteroot
There was no error as the mailer deamon was not firing correctly so ...
3
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!
answered Jul 22 '19 at 20:16
Jon G - Megaphone Tech
35.7k1 gold badge26 silver badges93 bronze badges
3
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 the UI, you have to setup a separate job for each report. That is useful, because you may want some reports mailing at a different frequency.
3
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 is "6 months" after Dec 31? If you increment the month and leave the day of month fixed, you get "June 31". That doesn't exist, but if we ...
2
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.
Perhaps the automatic ones are not run as -u your webuser but as another user - different env - different drush?
My favourite/most stable/like clockwork (no ...
2
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 cvapi job.iatsverify
And see if there are any errors showing up. Make sure it's the same php version ...
My guess is some curious error that our code isn't ...
2
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 parameters to add format=print, which overrides the default option, which is to send the report as a PDF file attached to the e-mail.
See here for more information ...
2
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 scheduled job on your "main" site, it should look more or less identical to what you've posted above.
Crucially - when configuring Scheduled Jobs for multi-site, ...
answered Oct 20 '17 at 22:11
Jon G - Megaphone Tech
35.7k1 gold badge26 silver badges93 bronze badges
2
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 situation you would not want this happening)
2
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
$validTypes = array('contact', 'contribution', 'participant', 'relationship');
if (!isset($params['migrate_type'])) {
$entityTable = 'civicrm_contact';
} ...
2
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 permissions:
View all contacts
Access CiviCRM
Access CiviMail
Please see the documentation for more details: Scheduled jobs
You will need to set the site ...
2
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 below for CiviCRM version 4.7.29
mysql> DESCRIBE `civicrm_job_log`;
+-------------+------------------+------+-----+-------------------+------------------------...
2
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 particular are problematic:
./wp-content/uploads/civicrm/templates_c/en_US/%%31/313
./wp-content/uploads/civicrm/templates_c/en_US/%%D6/D67
We don't know what is ...
2
I assume you mean the job that is used to send Scheduled Mailings . You do not have to create it. It is part of the standard configuration. So the only thing to do is to enable it. But to be complete here is the configuration:
2
I was also going to add that there are alternatives, e.g. CiviHosting offer this method which can be done via the hosting control panel https://civihosting.com/blog/how-to-make-a-cron-job-for-civicrm/
And then you can also use an extension to use the Drupal cron to trigger the CiviCRM cron:
https://civicrm.org/extensions/civicrm-cron
Not quite as ...
2
And after all that, it looks like it was a password error after all, just not the password I thought.
cli.php is retrieving the Drupal MySQL username and password from CIVICRM_UF_DSN in civicrm.settings.php as Jon G suggested. The instructions in that file say 'If any of these contain a single quote or backslash, escape those characters with a backslash: \' ...
Only top voted, non community-wiki answers of a minimum length are eligible
