Answers.Body: <p>Yesterday, the scheduled reminders started working again!  This was after I had disabled and then re-enabled 'Membership Types' in Administer/Civimember and also upgraded to v 4.7.10
  Hope this helps anyone having the same problem.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-10T14:08:52.983Z
Answers.LastActivityDate: 2016-08-10T14:08:52.983Z
Answers.UserDisplayName: peterb
Body: <p>Just discovered that scheduled reminders have stopped working and appear to have done so since updating CiviCRM to v4.7.8 on 3rd June.  The following error message is in the scheduled jobs log:
  Summary
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@memberTypeValues" is unknown.
  Details
  Parameters parsed (and passed to API method): 
  a:1:{s:7:"version";i:3;}</p>
  
  <p>Full message: 
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@memberTypeValues" is unknown.</p>
  
  <p>Other points to note:</p>
  
  <ul>
  <li>Wordpress version 4.5.2</li>
  <li>Other CRON is working</li>
  <li>No extensions are installed</li>
  <li>Scheduled mailings are going out OK</li>
  </ul>
  
  <p>Can anyone tell me where I should be looking for errors or are there any known bugs?
  Many thanks</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-16T11:13:58.950Z
Comments.Text: look for civicrm Error logs in - .../sites/default/files/civicrm/ConfigAndLog - if you don't have any log then try to look for PHP error log
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-16T12:12:06.483Z
Comments.Text: Thanks Ramesh.  I appreciate your help.  Forgive my ignorance but I am a newbie on this kind of thing.  The only log in ConfigAndLog on 3rd June was on an ini. file (Config.IDS.ini) but there dont appeaer to be any errors.  Can you tell me where I should look for PHP errors please?
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-16T15:03:43.307Z
Comments.Text: it depends on the server setting but normally you can find the error against this folder /var/log/httpd/error
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-07T15:40:49.767Z
Comments.Text: Today, I've updated civicrm to v 4.7.9 but the error message "Cannot build query. Variable "@memberTypeValues" is unknown".is still appearing when running administer/system settings/scheduled jobs/send scheduled reminders.  All other scheduled jobs and CRON appear to be running normally.
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-22T17:24:00.583Z
Comments.Text: I've contacted my host to see if there are any php errors in the log.  Although there was initially a security issue whereby my IP address was blocked, they have cured that and said "now the security rule triggered is fixed, there seems to be a remaining issue and it looks to be to do with how CiviCRM is coded".  Scheduled reminders are still not going out as part of the CRON job, nor can the job be fired manually.
Comments.UserDisplayName: peterb
Tags: <wordpress><civimember><cron-job><scheduled-reminders>
Title: Scheduled reminders have stopped working in v.4.7.8
ThreadText: # Scheduled reminders have stopped working in v.4.7.8
  
  (Asked by: username_0 on 2016-06-16)
  
  Just discovered that scheduled reminders have stopped working and appear to have done so since updating CiviCRM to v4.7.8 on 3rd June. The following error message is in the scheduled jobs log:
  Summary
  Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@memberTypeValues" 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 "@memberTypeValues" is unknown.
  
  Other points to note:
  
  * Wordpress version 4.5.2
  * Other CRON is working
  * No extensions are installed
  * Scheduled mailings are going out OK
  
  Can anyone tell me where I should be looking for errors or are there any known bugs?
  Many thanks
  
  **Tags:** wordpress, civimember, cron-job, scheduled-reminders
  
  > **Comments:**
  > **username_1**: look for civicrm Error logs in - .../sites/default/files/civicrm/ConfigAndLog - if you don't have any log then try to look for PHP error log  
  > **username_0**: Thanks Ramesh.  I appreciate your help.  Forgive my ignorance but I am a newbie on this kind of thing.  The only log in ConfigAndLog on 3rd June was on an ini. file (Config.IDS.ini) but there dont appeaer to be any errors.  Can you tell me where I should look for PHP errors please?  
  > **username_1**: it depends on the server setting but normally you can find the error against this folder /var/log/httpd/error  
  > **username_0**: I've contacted my host to see if there are any php errors in the log.  Although there was initially a security issue whereby my IP address was blocked, they have cured that and said "now the security rule triggered is fixed, there seems to be a remaining issue and it looks to be to do with how CiviCRM is coded".  Scheduled reminders are still not going out as part of the CRON job, nor can the job be fired manually.  
  > **username_0**: Today, I've updated civicrm to v 4.7.9 but the error message "Cannot build query. Variable "@memberTypeValues" is unknown".is still appearing when running administer/system settings/scheduled jobs/send scheduled reminders.  All other scheduled jobs and CRON appear to be running normally.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-08-10. Score: 1
  
  Yesterday, the scheduled reminders started working again! This was after I had disabled and then re-enabled 'Membership Types' in Administer/Civimember and also upgraded to v 4.7.10
  Hope this helps anyone having the same problem.
  
  
  ---
  
  