Drop Tables Error

[linkx]

Trying to clean up my Drupal Database after uninstalling CiviCRM 1.7

Using PHPmyAdmin I'm trying to drop all civicrm_* tables. I can drop some tables, but others return this error:

Code: [Select]

#1217 - Cannot delete or update a parent row: a foreign key constraint fails
There does not seem to be any rhyme or reason to which will drop and which will not.

Any suggestions?

Thanks!

[Donald Lobo]

table with foreign key constraints are probably causing you the problem. You can set this to 0 by executing:

SET FOREIGN_KEY_CHECKS=0

in your sql window on PMA

lobo

[linkx]

Thanks for the reply. I successfully executed the query in PMA but my problem remains. Any other suggestions?

[speleo]

Hi Linkx, This method does work as I've used it myself before. Did you issue the command as a one off or in the scope of a chain of commands.

eg

mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> DROP TABLE  civicrm_*;
mysql> SET FOREIGN_KEY_CHECKS = 1;

[linkx]

 

Thanks a bunch! I just had to use your suggestion and run it all at once. I could not get the wildcard to work with a DROP query so I just listed them all with SHOW TABLES LIKE 'civicrm_%' and then comma-separated the list and ran this query:

THANK YOU SO MUCH!

Code: [Select]

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE
civicrm_contribution_page,
civicrm_contribution_recur,
civicrm_contribution_type,
civicrm_country,
civicrm_currency,
civicrm_custom_field,
civicrm_custom_group,
civicrm_custom_option,
civicrm_custom_value,
civicrm_dedupe_rule,
civicrm_dedupe_rule_group,
civicrm_domain,
civicrm_email,
civicrm_entity_file,
civicrm_entity_tag,
civicrm_event,
civicrm_file,
civicrm_financial_trxn,
civicrm_group,
civicrm_household,
civicrm_im,
civicrm_individual,
civicrm_line_item,
civicrm_location,
civicrm_location_type,
civicrm_log,
civicrm_mailing,
civicrm_mailing_bounce_pattern,
civicrm_mailing_bounce_type,
civicrm_mailing_component,
civicrm_mailing_event_bounce,
civicrm_mailing_event_confirm,
civicrm_mailing_event_delivered,
civicrm_mailing_event_forward,
civicrm_mailing_event_opened,
civicrm_mailing_event_queue,
civicrm_mailing_event_reply,
civicrm_mailing_event_subscribe,
civicrm_mailing_event_trackable_url_open,
civicrm_mailing_event_unsubscribe,
civicrm_mailing_group,
civicrm_mailing_job,
civicrm_mailing_trackable_url,
civicrm_mapping,
civicrm_mapping_field,
civicrm_meeting,
civicrm_membership,
civicrm_membership_block,
civicrm_membership_log,
civicrm_membership_payment,
civicrm_membership_status,
civicrm_membership_type,
civicrm_msg_template,
civicrm_note,
civicrm_option_group,
civicrm_option_value,
civicrm_organization,
civicrm_participant,
civicrm_participant_payment,
civicrm_payment_processor,
civicrm_payment_processor_type,
civicrm_phone,
civicrm_phonecall,
civicrm_preferences,
civicrm_premiums,
civicrm_premiums_product,
civicrm_price_field,
civicrm_price_set,
civicrm_product,
civicrm_relationship,
civicrm_relationship_type,
civicrm_saved_search,
civicrm_state_province,
civicrm_tag,
civicrm_task,
civicrm_uf_group,
civicrm_validation;
SET FOREIGN_KEY_CHECKS = 1;