themak1985
commented
1 year ago I manually removed custom fields and manually deleted an option via phpmyadmin and I was able to uninstall without issue via gui. Thanks!
Closed themak1985 closed 1 year ago
themak1985
commented
1 year ago I manually removed custom fields and manually deleted an option via phpmyadmin and I was able to uninstall without issue via gui. Thanks!
I am trying to find a way to fully uninstall this extension without breaking my site. I cannot do it via gui because of the following issues.
When enabled, I cannot access any contacts, this is what I get in the logs
[error] $Fatal Error Details = array:3 [ "message" => "DB Error: no such field" "code" => null "exception" => CRM_Core_Exception {#9697 -errorData: array:6 [ "error_code" => "no such field" "sql" => """ SELECT a.id asid, a.subject assubject, a.activity_date_time asactivity_date_time, a_to_civicrm_value_data_policy_acceptance_2.terms_conditions_2 ascustom_2\n FROM civicrm_activity a\n LEFT JOINcivicrm_value_data_policy_acceptance_2`a_to_civicrm_value_data_policy_acceptance_2ONa_to_civicrm_value_data_policy_acceptance_2.entity_id =a.id\n WHERE (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHERE record_type_id = 3 AND contact_id = "563")) AND (a.activity_type_id = "55")\n ORDER BY a.activity_date_time DESC\n LIMIT 1\n OFFSET 0\n [nativecode=1054 Unknown column 'a_to_civicrm_value_data_policy_acceptance_2.terms_conditions_2' in 'field list'] """ "tip" => "add debug=1 to your API call to have more info about the error" "is_error" => 1 "error_message" => "DB Error: no such field" "debug_information" => """ SELECT a.id asid, a.subject assubject, a.activity_date_time asactivity_date_time, a_to_civicrm_value_data_policy_acceptance_2.terms_conditions_2 ascustom_2\n FROM civicrm_activity a\n LEFT JOINcivicrm_value_data_policy_acceptance_2a_to_civicrm_value_data_policy_acceptance_2ONa_to_civicrm_value_data_policy_acceptance_2.entity_id =a.id\n WHERE (a.id IN (SELECT activity_id FROM civicrm_activity_contact WHERE record_type_id = 3 AND contact_id = "563")) AND (a.activity_type_id = "55")\n ORDER BY a.activity_date_time DESC\n LIMIT 1\n OFFSET 0\n [nativecode=1054 Unknown column 'a_to_civicrm_value_data_policy_acceptance_2.terms_conditions_2' in 'field list'] """ ]cause: null
} ] `
When I try to uninstall i get this error in the log:
[error] $Fatal Error Details = array:3 [ "message" => "DB Error: not found" "code" => null "exception" => CRM_Core_Exception {#12402 -errorData: array:6 [ "error_code" => "not found" "sql" => " ALTER TABLE civicrm_value_data_policy_acceptance_2 DROP COLUMNterms_conditions_2[nativecode=1091 ** Can't DROP 'terms_conditions_2'; check that column/key exists]" "tip" => "add debug=1 to your API call to have more info about the error" "is_error" => 1 "error_message" => "DB Error: not found" "debug_information" => " ALTER TABLE civicrm_value_data_policy_acceptance_2 DROP COLUMNterms_conditions_2` [nativecode=1091 ** Can't DROP 'terms_conditions_2'; check that column/key exists]" ]cause: null
} ] `