Body: <p>We suddenly lost about 75% of our contact's email and addresses. We've reset our SQL and it hasn't helped. In addition, some of the missing emails still work in our event registration section while others are not recognizing them as members. Has anyone else had this happen? Any known fixes? Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-16T05:56:02.070Z
Comments.Text: Sounds pretty unusual. Perhaps some more information would assist to attract a possible answer.
  What CMS are you using (Drupal /Wordpress / Joomla?) and what version. And what version CiviCRM. With the missing emails that "still work in our event registration section" it may help if you explain that a little more. How exactly do they still work? Perhaps you could check those contacts to see if the email or addresses are still on the record at all, like when you edit the contact. Or is that information available in Mysql ?
Comments.UserDisplayName: Chris Dubrow
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-16T14:34:38.663Z
Comments.Text: Also, are you using any extensions?
Comments.UserDisplayName: Dana
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-16T14:48:18.347Z
Comments.Text: If you look directly in the database tables, is that data still present? What do you mean by "reset our SQL"?
Comments.UserDisplayName: choster
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-17T03:10:37.473Z
Comments.Text: I think its time to look directly at the data tables ... and you have a backup, right?  Without knowing more about what is or is not in the mysql tables its really hard to make a diagnosis.
Comments.UserDisplayName: Eliot Mason
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-17T13:40:59.157Z
Comments.Text: Thanks for all your help. We were able to create a new DB from a backup. I probably should of posted this question here, but I started a new one. Maybe this log file can help me prevent loss in the future: http://civicrm.stackexchange.com/questions/3313/random-data-loss-data-breach-user-error-database-failure-anyone-have-an-idea Thanks again!
Comments.UserDisplayName: BraddC
Tags: <email><contacts>
Title: Email and Addresses Missing
ThreadText: # Email and Addresses Missing
  
  (Asked by: username_0 on 2015-06-15)
  
  We suddenly lost about 75% of our contact's email and addresses. We've reset our SQL and it hasn't helped. In addition, some of the missing emails still work in our event registration section while others are not recognizing them as members. Has anyone else had this happen? Any known fixes? Thanks!
  
  **Tags:** email, contacts
  
  > **Comments:**
  > **username_1**: Sounds pretty unusual. Perhaps some more information would assist to attract a possible answer. What CMS are you using (Drupal /Wordpress / Joomla?) and what version. And what version CiviCRM. With the missing emails that "still work in our event registration section" it may help if you explain that a little more. How exactly do they still work? Perhaps you could check those contacts to see if the email or addresses are still on the record at all, like when you edit the contact. Or is that information available in Mysql ?  
  > **username_2**: Also, are you using any extensions?  
  > **username_3**: If you look directly in the database tables, is that data still present? What do you mean by "reset our SQL"?  
  > **username_4**: I think its time to look directly at the data tables ... and you have a backup, right?  Without knowing more about what is or is not in the mysql tables its really hard to make a diagnosis.  
  > **username_0**: Thanks for all your help. We were able to create a new DB from a backup. I probably should of posted this question here, but I started a new one. Maybe this log file can help me prevent loss in the future: http://civicrm.stackexchange.com/questions/3313/random-data-loss-data-breach-user-error-database-failure-anyone-have-an-idea Thanks again!  
  
  ---
  
  ## 0 answers
  
  