Answers.Body: <p>There was a botched install of CiviVolunteer that did not have all of its tables present.  It could not be installed or uninstalled. I copied over missing tables from an older db. Reran the install and ran the uninstall.  DB errors gone and manually ran the process_membership and all worked as expected.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-10T09:54:47.877Z
Answers.Text: If this answers your question, you can mark it as answered using the big green tick.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-07T22:08:14.063Z
Answers.LastActivityDate: 2021-08-07T22:08:14.063Z
Answers.UserDisplayName: Tim
Body: <p><em><strong>General Config:</strong></em>
  Wordpress 5.8
  CiviCRM 5.39.1
  Cron running ever 5 min successfully
  Segregated db from the wp install</p>
  <p><em><strong>Issue:</strong></em>
  We notice our memberships are not moving from one status to another:  New to Current to Grace to Expired. Rules seem to be properly configured.</p>
  <p>Entity: Job Action: process_membership
  Summary
  Finished execution of Update Membership Statuses with result: Failure, Error message: DB Constraint Violation - membership_type_id should possibly be marked as mandatory for Membership,create API. If so, please raise a bug report.
  Details</p>
  <p>Parameters parsed (and passed to API method):
  a:1:{s:7:&quot;version&quot;;i:3;}</p>
  <p>Full message:
  Finished execution of Update Membership Statuses with result: Failure, Error message: DB Constraint Violation - membership_type_id should possibly be marked as mandatory for Membership,create API. If so, please raise a bug report.</p>
  <p>According to the DB the membership_type_id does not allow nulls.</p>
  <p>Kinda lost on this one and not finding an online example here or through the googles.</p>
  
Tags: <civimember><upgrade><status>
Title: Entity: Job Action: process_membership Failing due to DB error
ThreadText: # Entity: Job Action: process_membership Failing due to DB error
  
  (Asked by: username_0 on 2021-08-07)
  
  ***General Config:***
  Wordpress 5.8
  CiviCRM 5.39.1
  Cron running ever 5 min successfully
  Segregated db from the wp install
  
  ***Issue:***
  We notice our memberships are not moving from one status to another: New to Current to Grace to Expired. Rules seem to be properly configured.
  
  Entity: Job Action: process\_membership
  Summary
  Finished execution of Update Membership Statuses with result: Failure, Error message: DB Constraint Violation - membership\_type\_id should possibly be marked as mandatory for Membership,create API. If so, please raise a bug report.
  Details
  
  Parameters parsed (and passed to API method):
  a:1:{s:7:"version";i:3;}
  
  Full message:
  Finished execution of Update Membership Statuses with result: Failure, Error message: DB Constraint Violation - membership\_type\_id should possibly be marked as mandatory for Membership,create API. If so, please raise a bug report.
  
  According to the DB the membership\_type\_id does not allow nulls.
  
  Kinda lost on this one and not finding an online example here or through the googles.
  
  **Tags:** civimember, upgrade, status
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2021-08-07. Score: 2
  
  There was a botched install of CiviVolunteer that did not have all of its tables present. It could not be installed or uninstalled. I copied over missing tables from an older db. Reran the install and ran the uninstall. DB errors gone and manually ran the process\_membership and all worked as expected.
  
  > **Comments:**
  > **username_1**: If this answers your question, you can mark it as answered using the big green tick.  
  
  ---
  
  