Answers.Body: <p>1/ unlikely to be upgrade related</p>
  
  <p>2/ assuming you have access to 'log' tables you can write an sql query to identify records where the first/last names have changed from the previous log record</p>
  
  <p>3/ if you mean how to find and prevent in future, use the logs to try and identify who/when and figure out what the person was trying to do and train them otherwise (assuming user error at backend) OR if problem occured by front-end process then perhaps check your Matching rules</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-26T22:57:47.933Z
Answers.Text: thanks this is very helpful.
Answers.UserDisplayName: LaurynnLowe
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-26T18:04:02.387Z
Answers.LastActivityDate: 2019-11-26T18:04:02.387Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>A common cause of that experience is when administrators are doing backend work on contacts but using "front-end" forms - in those cases, the administrators will sometimes inadvertendly overwrite contact information in confusing ways.</p>
  
  <p>Using "front-end" forms as an administrator is possible, but you have to be aware of the automation that sometimes is lurking in the back.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-05T20:00:29.073Z
Answers.Text: seconded, in some cases we've found records with changed names
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-05T15:24:03.127Z
Answers.LastActivityDate: 2019-12-05T15:24:03.127Z
Answers.UserDisplayName: Alan Dixon
Body: <p>Recently we noticed a several contacts and their contributions were missing from our database. These contacts and contributions were not manually deleted. The contacts are not in trash (I believe civi does not allow contacts with contributions to be permanently deleted. The contributions would need to be deleted first).</p>
  
  <p>I suspect that the data was overwritten. Can anyone advise:</p>
  
  <p>(1) What change to the server or database could allow data to be overwritten? I am the site admin, not the sys admin (we are on shared server). Would an upgrade be a likely cause? Or would I need to ask the sysadmin about an actual move from one server to another?</p>
  
  <p>(2) Is there a best practices for recovering data? I think the best approach would be to pinpoint the date the data was lost, export contacts and contributions that are in the backup but not the current version, and import to current version. But I am open to suggestions.</p>
  
  <p>(3) Does anyone have suggestions on how to catch this kind of issue?</p>
  
Tags: <backups>
Title: What would cause contributions and contacts to go missing?
ThreadText: # What would cause contributions and contacts to go missing?
  
  (Asked by: username_0 on 2019-11-26)
  
  Recently we noticed a several contacts and their contributions were missing from our database. These contacts and contributions were not manually deleted. The contacts are not in trash (I believe civi does not allow contacts with contributions to be permanently deleted. The contributions would need to be deleted first).
  
  I suspect that the data was overwritten. Can anyone advise:
  
  (1) What change to the server or database could allow data to be overwritten? I am the site admin, not the sys admin (we are on shared server). Would an upgrade be a likely cause? Or would I need to ask the sysadmin about an actual move from one server to another?
  
  (2) Is there a best practices for recovering data? I think the best approach would be to pinpoint the date the data was lost, export contacts and contributions that are in the backup but not the current version, and import to current version. But I am open to suggestions.
  
  (3) Does anyone have suggestions on how to catch this kind of issue?
  
  **Tags:** backups
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-11-26. Score: 2
  
  1/ unlikely to be upgrade related
  
  2/ assuming you have access to 'log' tables you can write an sql query to identify records where the first/last names have changed from the previous log record
  
  3/ if you mean how to find and prevent in future, use the logs to try and identify who/when and figure out what the person was trying to do and train them otherwise (assuming user error at backend) OR if problem occured by front-end process then perhaps check your Matching rules
  
  > **Comments:**
  > **username_0**: thanks this is very helpful.  
  
  ---
  
  ### Answer by username_2 on 2019-12-05. Score: 1
  
  A common cause of that experience is when administrators are doing backend work on contacts but using "front-end" forms - in those cases, the administrators will sometimes inadvertendly overwrite contact information in confusing ways.
  
  Using "front-end" forms as an administrator is possible, but you have to be aware of the automation that sometimes is lurking in the back.
  
  > **Comments:**
  > **username_3**: seconded, in some cases we've found records with changed names  
  
  ---
  
  