Answers.Body: <p>It depends on what you are trying to do.
  If you want the complete removal of the contact, together with related entities (like address, activities, event participations etc.), then permanently deleting the contact will delete all the associated entities.</p>
  <p>If you just want to remove the change log for that 1 contact without deleting the contact, you can run a simple SQL query to delete it. For a contact with the contact id 57 you would run this:</p>
  <pre><code>DELETE FROM `civicrm_log` WHERE entity_table LIKE 'civicrm_contact' and entity_id = 57
  </code></pre>
  <p>Beware, if you used something like Drupal webforms, then the data can still be there in the webform submissions, even though you deleted it form CiviCRM.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-01T20:44:49.363Z
Answers.LastActivityDate: 2021-02-01T20:44:49.363Z
Answers.UserDisplayName: Marko
Body: <p>We are trying to delete the change log for 1 user. We want to complete remove their address and information on our system. There a way to delete the change log for 1 contact in CiviCRM?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-01T18:38:04.597Z
Comments.Text: You could take a look at what the GDPR extension offers but that seems a bit of a mission for a single contact.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-01T22:12:05.883Z
Comments.Text: I do actually have that extension installed and ran "Forget me" for the contact I wanted. It changed everything but kept the change log.
Comments.UserDisplayName: Scott Pulver
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-02T02:12:06.493Z
Comments.Text: https://civicrm.stackexchange.com/questions/22361/data-protection-gdpr-deleting-from-logging-tables/22421#22421 shed any light for you?
Comments.UserDisplayName: petednz - fuzion
Tags: <contacts><logging><civicontact>
Title: Delete Change Log for 1 contact
ThreadText: # Delete Change Log for 1 contact
  
  (Asked by: username_0 on 2021-02-01)
  
  We are trying to delete the change log for 1 user. We want to complete remove their address and information on our system. There a way to delete the change log for 1 contact in CiviCRM?
  
  **Tags:** contacts, logging, civicontact
  
  > **Comments:**
  > **username_1**: You could take a look at what the GDPR extension offers but that seems a bit of a mission for a single contact.  
  > **username_0**: I do actually have that extension installed and ran "Forget me" for the contact I wanted. It changed everything but kept the change log.  
  > **username_1**: https://civicrm.stackexchange.com/questions/22361/data-protection-gdpr-deleting-from-logging-tables/22421#22421 shed any light for you?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-02-01. Score: 3 | Accepted answer
  
  It depends on what you are trying to do.
  If you want the complete removal of the contact, together with related entities (like address, activities, event participations etc.), then permanently deleting the contact will delete all the associated entities.
  If you just want to remove the change log for that 1 contact without deleting the contact, you can run a simple SQL query to delete it. For a contact with the contact id 57 you would run this:
  DELETE FROM `civicrm_log` WHERE entity_table LIKE 'civicrm_contact' and entity_id = 57
  
  Beware, if you used something like Drupal webforms, then the data can still be there in the webform submissions, even though you deleted it form CiviCRM.
  
  
  ---
  
  