Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.0
-
Fix Version/s: 4.4.0
-
Component/s: None
-
Labels:None
Description
confirmation link for the petitions throw below error:
http://cv44/civicrm/petition/confirm?reset=1&cid=341&sid=6&h=00c934ca65516be9&a=718&p=3
DB Error: constraint violation
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm_44`.`civicrm_group_contact`, CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] =>
REPLACE INTO civicrm_group_contact ( group_id, contact_id, status )
VALUES
( 26, 341, 'Added' ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_44`.`civicrm_group_contact`, CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] =>
REPLACE INTO civicrm_group_contact ( group_id, contact_id, status )
VALUES
( 26, 341, 'Added' ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_44`.`civicrm_group_contact`, CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="
REPLACE INTO civicrm_group_contact ( group_id, contact_id, status )
VALUES
( 26, 341, 'Added' ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_44`.`civicrm_group_contact`, CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)
After fixing this error verify/fix webtest: WebTest_Campaign_PetitionUsageScenarioTest