Uninstall CiviCRM from WordPress, is creating me a big issue.
I needed to uninstall CiviCRM (5.31.1) from a production site, saving all theme and others settings. CiviCRM went away without uninstall its db data. So:
- I tried to delete the tables using phpmyadmin, failing
- From command line, I dropped the db and I recreated it from a dump, cutting away the CiviCRM part, maining all tables without
wp_prefix; doing this the Wordpress site operate all as well.
Some days ago it was necessay to reinstall CiviCRM... All was good until we clicked the plugin enable link, recieving this page:
Initialization Error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => simpleHandler
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
[nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]
[type] => DB_Error
[user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
[nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
[nativecode=1146 ** Table 'sat_wp2020.civicrm_setting' doesn't exist]"]
Where old CiviCRM data are still inside db?
Did someone prepare a SQL script performing correct db uninstall?
Could be possibile to add the data delete checkbox during plugin uninstall process, like in many others Wordpress plugins?
TIA -- Francesco
