Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13204

Confirmation link for petition is broken

    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

        Attachments

          Activity

            People

            • Assignee:
              ravish.nair Ravish Nair
              Reporter:
              kurund Kurund Jalmi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: