CiviCRM Community Forums (archive)

Hi, trying to upgrade to 2.2 and running into:

Database Error Code: Error on rename of './astdcasc_civicrm_local/civicrm_group_nesting' to './astdcasc_civicrm_local/#sql2-70-ac' (errno: 152), 1025
Tried running:
ALTER TABLE `civicrm_group_nesting`
    ADD CONSTRAINT `FK_civicrm_group_nesting_child_group_id` FOREIGN KEY (`child_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE;
As was suggested at this post, but got this error:

Error message from server:

Cannot add or update a child row: a foreign key constraint fails (`astdcasc_civicrm_local/#sql-70_1`, CONSTRAINT `FK_civicrm_group_nesting_child_group_id` FOREIGN KEY (`child_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)
Not sure where to go from here...