Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-20324

Scheduled reminders fail to run

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.17
    • Fix Version/s: 4.7.27
    • Component/s: CiviEvent
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      Installation Details

      WordPress 4.7.3
      CiviCRM 4.7.17
      CiviVolunteer 4.6-2.2.1
      Angular Profiles 4.6-1.0.2
      SparkPost 1.1 (verified working, bug happens with sendmail() as well)

      Problem Description

      I have a CiviEvent set up with a schedule reminder. The variables in the email template are:

      • {event.title}
      • {contact.display_name}
      • {event.title}
      • {event.start_date}
      • {event.summary}
      • {event.description}
      • {event.info_url}

      When the cron job runs, the email is not sent and I get this error in the scheduled jobs log and no emails are sent:

      Entity: Job Action: send_reminder
      Summary
      Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@selectedValues" is unknown.
      Details

      Parameters parsed (and passed to API method):
      a:1:{s:7:"version";i:3;}

      Full message:
      Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@selectedValues" is unknown.

      I've tried a number of things to debug this, including turning off WordPress plugins in batches, turning off all Civi extensions.

        Attachments

        1. Screen Shot 2017-09-26 at 9.34.59 AM.png
          39 kB
          Michael LaMorte
        2. Screenshot 2017-10-06 16.46.25.png
          51 kB
          Eileen McNaughton
        3. var-log.txt
          11 kB
          Michael LaMorte

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mlamorte Michael LaMorte
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: