Answers.Body: <p>Please be aware that updating the membership with a new status should give implications when the status is manually overridden. So if you are going to update this via the database, it would be a bit safer to use the following and then run the Update Membership Statuses job:</p>
  
  <pre><code>UPDATE `civicrm_membership`
  SET    status_id = 1 
  WHERE  is_override is NULL
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-01T15:12:24.833Z
Answers.LastActivityDate: 2019-01-01T15:12:24.833Z
Answers.UserDisplayName: Webmaster COVS
Answers.Body: <p>Marilyn - I didn't see your CiviCRM version but from what I see (CiviCRM 4.4) status of members w/end date in the past is not changed from the initial status ('New') and the job logs 'success' every time after examining x 'memberships', updated 0 records. I suspect the job is only logging status- I'll try debugging, and send a patch. BTW, I tried this on the 'Demo' system (WP) and it seems to work.</p>
  
  <p>So - have you checked the 'Membership Status Rules' (Administer>CiviMember>Membership Status Rules)?  You have to set those rules up to make your memberships transition from one status to the next, there are optional grace periods etc.  Also, what is the weight of your pending status rule? The 'weight' governs the order your memberships transition, another post had an issue w/that: <a href="https://forum.civicrm.org/index.php?topic=13921.0" rel="nofollow">https://forum.civicrm.org/index.php?topic=13921.0</a></p>
  
  <p>Finally, there is this:
  <a href="http://wiki.civicrm.org:8090/confluence/display/CRMDOC22/Update+Pending+Memberships" rel="nofollow">http://wiki.civicrm.org:8090/confluence/display/CRMDOC22/Update+Pending+Memberships</a> (mind you this doc is from 2009)
  HTH</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-21T17:00:44.227Z
Answers.LastActivityDate: 2015-07-22T02:53:17.710Z
Answers.LastEditDate: 2015-07-22T02:53:17.710Z
Answers.UserDisplayName: Lesley Evensen
Answers.Body: <p>I was having this problem or one like it. Some memberships were Expired that should have been in Grace, and running the CRON job "Update Membership Statuses" (in Scheduled Jobs /civicrm/admin/job) had no effect, even after I fixed a problem with the status rules. I found a recommendation to set membership status to NULL, because once status is Expired it can't go back to Grace, but PHPMyAdmin/MySQL wouldn't allow that because of some relationship (I'm not an expert). Solution was in a PHPMyAdmin Query to reset all memberships to New status, and then run the CRON job. I used:</p>
  
  <pre><code>UPDATE `civicrm_membership`
  SET    status_id = 1 
  </code></pre>
  
  <p>Then I ran the CRON job manually from the Scheduled Jobs page (repeatedly until it stopped crashing from PHP timeout on shared hosting) until all 2300 memberships had processed—it worked! </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-02T18:31:20.067Z
Answers.LastActivityDate: 2018-05-02T18:47:35.127Z
Answers.LastEditDate: 2018-05-02T18:47:35.127Z
Answers.UserDisplayName: bigO
Body: <p>Our memberships aren't being updated from "pending" to "current".  I've done the following without success.</p>
  
  <p>The membership status rules are as follows:</p>
  
  <ul>
  <li>Pending--> start event is member since; end event is member since; ; </li>
  <li>Current--> start event is start date; end event is end date; start event adjustment is 1 day; end event adjustment is 1 year. </li>
  </ul>
  
  <p>I've run the job "update membership statuses" multiple times.
  There's a message under that job:</p>
  
  <p><strong><em>WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.
  API Entity: Job
  API Action: process_membership</em></strong> </p>
  
  <p>Summary of job is </p>
  
  <blockquote>
    <p>finished execution of update membership statuses with result: Success (processed 291 records. Updated 0 records.) </p>
  </blockquote>
  
  <p>I've also run the job "scheduled reminders", just in case</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-16T16:11:56.623Z
Comments.Text: Could you post details of your membership status rules, from /civicrm/admin/member/membershipStatus?reset=1 ?
  Were the memberships pending because linked to pending contributions? If so, have the contributions been updated & if so, how? Which CiviCRM version?
Comments.UserDisplayName: davejenx
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-16T20:30:29.657Z
Comments.Text: When you run the Scheduled Job (not reminder!) what do you get in its log? ie at civicrm/admin/joblog?jid=10&reset=1
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-17T23:10:52.727Z
Comments.Text: Here are the membership status rules:
Comments.UserDisplayName: Marilyn Schiffman
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-17T23:12:07.567Z
Comments.Text: Sorry for the last post, I thought I'd be able to paste to this window.
Comments.UserDisplayName: Marilyn Schiffman
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-17T23:17:51.640Z
Comments.Text: Sorry for the last post, I thought I'd be able to paste to this window.  The membership status rules are as follows:  Pending--> start event is member since; end event is member since; ;  Current-->start event is start date; end event is end date; start event adjustment is 1 day; end event adjustment is 1 year.  Summary of job is "finished execution of update membership statuses with result: Success (processed 291 records. Updated 0 records.)
Comments.UserDisplayName: Marilyn Schiffman
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-22T04:17:39.263Z
Comments.Text: not sure whether to repeat my question above - does your Scheduled Job  log give any errors?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-02T12:16:04.833Z
Comments.Text: does the status update when you edit the membership and save it without any changes? Maybe this is the same issue as this question https://civicrm.stackexchange.com/questions/9395/back-office-credit-card-contribution-membership-stays-pending ?
Comments.UserDisplayName: sleidig
Tags: <civimember><scheduled-reminders>
Title: membership statuses not being updated
ThreadText: # membership statuses not being updated
  
  (Asked by: username_0 on 2015-07-16)
  
  Our memberships aren't being updated from "pending" to "current". I've done the following without success.
  
  The membership status rules are as follows:
  
  * Pending--> start event is member since; end event is member since; ;
  * Current--> start event is start date; end event is end date; start event adjustment is 1 day; end event adjustment is 1 year.
  
  I've run the job "update membership statuses" multiple times.
  There's a message under that job:
  
  ***WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.
  API Entity: Job
  API Action: process\_membership***
  
  Summary of job is
  
  > finished execution of update membership statuses with result: Success (processed 291 records. Updated 0 records.)
  
  I've also run the job "scheduled reminders", just in case
  
  **Tags:** civimember, scheduled-reminders
  
  > **Comments:**
  > **username_1**: Could you post details of your membership status rules, from /civicrm/admin/member/membershipStatus?reset=1 ? Were the memberships pending because linked to pending contributions? If so, have the contributions been updated & if so, how? Which CiviCRM version?  
  > **username_2**: When you run the Scheduled Job (not reminder!) what do you get in its log? ie at civicrm/admin/joblog?jid=10&reset=1  
  > **username_0**: Here are the membership status rules:  
  > **username_0**: Sorry for the last post, I thought I'd be able to paste to this window.  
  > **username_0**: Sorry for the last post, I thought I'd be able to paste to this window.  The membership status rules are as follows:  Pending--> start event is member since; end event is member since; ;  Current-->start event is start date; end event is end date; start event adjustment is 1 day; end event adjustment is 1 year.  Summary of job is "finished execution of update membership statuses with result: Success (processed 291 records. Updated 0 records.)  
  > **username_2**: not sure whether to repeat my question above - does your Scheduled Job  log give any errors?  
  > **username_3**: does the status update when you edit the membership and save it without any changes? Maybe this is the same issue as this question https://civicrm.stackexchange.com/questions/9395/back-office-credit-card-contribution-membership-stays-pending ?  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_4 on 2019-01-01. Score: 1
  
  Please be aware that updating the membership with a new status should give implications when the status is manually overridden. So if you are going to update this via the database, it would be a bit safer to use the following and then run the Update Membership Statuses job:
  UPDATE `civicrm_membership`
  SET    status_id = 1 
  WHERE  is_override is NULL
  
  
  ---
  
  ### Answer by username_5 on 2015-07-21. Score: 1
  
  Marilyn - I didn't see your CiviCRM version but from what I see (CiviCRM 4.4) status of members w/end date in the past is not changed from the initial status ('New') and the job logs 'success' every time after examining x 'memberships', updated 0 records. I suspect the job is only logging status- I'll try debugging, and send a patch. BTW, I tried this on the 'Demo' system (WP) and it seems to work.
  
  So - have you checked the 'Membership Status Rules' (Administer>CiviMember>Membership Status Rules)? You have to set those rules up to make your memberships transition from one status to the next, there are optional grace periods etc. Also, what is the weight of your pending status rule? The 'weight' governs the order your memberships transition, another post had an issue w/that: <https://forum.civicrm.org/index.php?topic=13921.0>
  
  Finally, there is this:
  <http://wiki.civicrm.org:8090/confluence/display/CRMDOC22/Update+Pending+Memberships> (mind you this doc is from 2009)
  HTH
  
  
  ---
  
  ### Answer by username_6 on 2018-05-02. Score: 1
  
  I was having this problem or one like it. Some memberships were Expired that should have been in Grace, and running the CRON job "Update Membership Statuses" (in Scheduled Jobs /civicrm/admin/job) had no effect, even after I fixed a problem with the status rules. I found a recommendation to set membership status to NULL, because once status is Expired it can't go back to Grace, but PHPMyAdmin/MySQL wouldn't allow that because of some relationship (I'm not an expert). Solution was in a PHPMyAdmin Query to reset all memberships to New status, and then run the CRON job. I used:
  UPDATE `civicrm_membership`
  SET    status_id = 1 
  
  Then I ran the CRON job manually from the Scheduled Jobs page (repeatedly until it stopped crashing from PHP timeout on shared hosting) until all 2300 memberships had processed—it worked!
  
  
  ---
  
  