CiviCRM Community Forums (archive)

I am having similar foreign key constraint issues from 3.0.2 to 3.1.4.  Full detail of error message is attached.

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`handson_devcivicrm/#sql-6d6_88e048`, CONSTRAINT `FK_civicrm_pcp_block_supporter_profile_id` FOREIGN KEY (`supporter_profile_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE SET NULL), 1452

Any help would be most appreciated.  I'm trying to upgrade a test version of the site at devtest.handson.org.

Thanks,
Annalee

Sorry, but what can you do if you have already done the upgrade (to 3.14) but you didn't use the approved technique and you are still getting the foreign key constraint fails errors?

Kindly,
Paul

I've found it's best not to skip versions or 'jump ahead' when upgrading.  On a couple of occasions this has been a cure for my FK errors.  One time I upgraded all the way from 2.2.3 to 3.1.5 one version at a time.  

Another time I found success by exporting and reimporting into a fresh, correct schema.  This is particularly effective on older sites from the 2.1 era.  Kurund taught me that one.

I did not include betas, but only because I avoid installing beta software in general. I go from stable release to stable release.

In your case I would upgrade from alpha to the last beta, and from the beta to the first stable.