CiviCRM Community Forums (archive)

I just upgraded to the latest version of CiviCRM and it seems this broke CiviUser.  When a new user tries to register (who is a member), I get the following error:

insert error DB function failed with error number 1452
Cannot add or update a child row: a foreign key constraint fails (`farmfox_jo151`.`civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)) SQL=INSERT INTO civicrm_uf_match (uf_id, uf_name, contact_id, language) VALUES ( 102,'sag3c@virginia.edu',2409, NULL)

Any ideas?

I was able to get my installation working by changing line 447 of com_civiuser/controller.php to include domain_id:

FROM:

$sql = "INSERT INTO civicrm_uf_match (uf_id, uf_name, contact_id, language) VALUES ( ".$joomlaId.",'".$user->email."',".$civiId.", NULL) ";


TO:

$sql = "INSERT INTO civicrm_uf_match (uf_id, uf_name, contact_id, language, domain_id) VALUES ( ".$joomlaId.",'".$user->email."',".$civiId.", NULL, 1) ";

try checking the apache error log to see the main reason for the blank page

lobo