CiviCRM Community Forums (archive)

I'm working through fixing a number of errors on upgrading from 3.1.1 - It appears that a previous attempt was partially successful or something - anyway I've busily been dropping tables and have got as far as a constriant violation:

Cannot add or update a child row: a foreign key constraint fails (`ablaze_civicrm`.`civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`) ON DELETE SET NULL

Someone else with this problem successfully completed upgrade by hacking the .tpl file in modules/civicrm/CRM/Upgrade/Incremental/sql

(post: http://forum.civicrm.org/index.php?topic=14884.0)

But there is no .tpl for 3.1.1, just lots of betas

Any idea which to hack? Is there an easy way of working out which one I am using?

Or is there another solution to this problem?

Thanks for looking,

Myles

PS - at the start of upgrade the version field in civicrm_domain is 3.1.1 at the point it fails the field is 3.2.beta3.upgrade

This issue is still happening - the upgrade script for the alpha release of 4.5 includes an insert statement that has location_type_id's hardcoded - changing the values manually overcomes the problem.