So we lost 2/3 of our email and addresses on 6/15 around 1pm. Everything else seemed fine. I was able to get the civi log that pointed to a deletion command (DELETE FROM civicrm_location_type) around the same time. We have no idea how this happened. Thankfully we were able to make a new database from a backup file and not much damage was done.
Does anyone know what could have caused this and how we could prevent it in the future? Thanks!
Here's the log:
Jun 15 13:11:01 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`gbapgh_civicrm`.`civicrm_mapping_field`, CONSTRAINT `FK_civicrm_mapping_field_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]
[type] => DB_Error
[user_info] => DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`gbapgh_civicrm`.`civicrm_mapping_field`, CONSTRAINT `FK_civicrm_mapping_field_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`gbapgh_civicrm`.`civicrm_mapping_field`, CONSTRAINT `FK_civicrm_mapping_field_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]"]
)
Jun 15 13:11:01 [info] $backTrace = #0 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(239): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: constraint violation", -3, 16, (Array:2), "DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [...")
#4 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-3, 16, (Array:2), "DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [...")
#5 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -3, NULL, NULL, "DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) [...", "DB_Error", TRUE)
#6 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-3, NULL, NULL, NULL, "1451 ** Cannot delete or update a parent row: a foreign key constraint fails ...")
#7 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) ")
#9 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) ")
#10 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1456): DB_DataObject->_query("DELETE FROM civicrm_location_type WHERE ( civicrm_location_type.id = 1 ) ")
#11 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/LocationType.php(179): DB_DataObject->delete()
#12 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Admin/Form/LocationType.php(96): CRM_Core_BAO_LocationType::del("1")
#13 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(328): CRM_Admin_Form_LocationType->postProcess()
#14 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(162): CRM_Core_Form->mainProcess()
#15 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_LocationType), "next", "Next")
#16 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_LocationType), "next")
#17 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_LocationType), "next")
#18 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("next")
#19 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(395): CRM_Core_Controller->run()
#20 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(178): CRM_Core_Page_Basic->edit(8, "1")
#21 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(331): CRM_Core_Page_Basic->run((Array:3), NULL)
#22 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#23 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#24 /usr/home/gbapgh/public_html/go-gba/wp-content/plugins/civicrm/civicrm.php(506): CRM_Core_Invoke::invoke((Array:3))
#25 [internal function](): CiviCRM_For_WordPress->invoke("")
#26 /usr/home/gbapgh/public_html/go-gba/wp-includes/plugin.php(505): call_user_func_array((Array:2), (Array:1))
#27 /usr/home/gbapgh/public_html/go-gba/wp-admin/admin.php(212): do_action("toplevel_page_CiviCRM")
#28 {main}
Jun 15 13:41:30 [info] r_authresponse X07
Jun 15 13:41:30 [info] r_code 03924D1557233524:YYYM:
Jun 15 13:41:30 [info] r_tdate 1434390089
Jun 15 13:41:30 [info] r_avs YYYM
Jun 15 13:41:30 [info] r_ordernum A7DEDC06-557F0E49-608-E0474
Jun 15 13:41:30 [info] r_error
Jun 15 13:41:30 [info] csp FDMS
Jun 15 13:41:30 [info] r_message APPROVED
Jun 15 13:41:30 [info] r_ref 1557233524
Jun 15 13:41:30 [info] r_time Mon Jun 15 13:41:30 2015
Jun 15 13:44:08 [info] $Fatal Error Details = Array