CiviCRM Community Forums (archive)

I have a C 4.0.5 D 7.8 site which had some 20K contacts, 6K were in the Trash. I want to start fresh with this site b/c the imports someone else did are bad, so I first tried the export.php and import.php into a fresh install, but that failed with a PHP error (I hope to report about that elsewhere).

So instead I used the regular web interface to permanently delete all contacts, and then all from the Trash. Now civicrm_contacts has one row. Problem is that civicrm_group_contact has 19K rows. I would expect that permanently deleting a contact would remove his rows in that table.

Also custom data tables for data groups marked as "All Contact Types" have hundreds of records--they should have just one.

Seems to be these are bugs.

most of contact deletion is actually done by the DB via cascaded constraints

Ah, right, of course. Anyhow they are all InnoDB and have all the FKs.

But, for some reason, I now see that they are all missing the constraints such as

  ADD CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
and that's the issue.

I will try to add those to a fresh copy and then re-delete everyone.

Thanks!