CiviCRM Community Forums (archive)

Sorry. A non-recoverable error has occurred.

DB Error: unknown error

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`eurofutb_crm/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

2.0.3 Civicrm.

I've got an admin group that I want to send the test email to. I tried that, and then tried sending to my email numerous times. I get this error.
Is there a way to easily test the smtp settings without having to run through a test email?
I am not sure the two coincide, however I would like to know both please -if anyone can assist.

Thank you kindly.

Adam

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_activity (source_contact_id , source_record_id , activity_type_id , subject , activity_date_time , status_id ) VALUES ( 1 ,  30 ,  3 , 'Test Mailing: Copy of test 5' ,  NULL ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`eurofutb_crm/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_activity (source_contact_id , source_record_id , activity_type_id , subject , activity_date_time , status_id ) VALUES ( 1 ,  30 ,  3 , 'Test Mailing: Copy of test 5' ,  NULL ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`eurofutb_crm/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_activity (source_contact_id , source_record_id , activity_type_id , subject , activity_date_time , status_id ) VALUES ( 1 ,  30 ,  3 , 'Test Mailing: Copy of test 5' ,  NULL ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`eurofutb_crm/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)




Looks like your user session is invalid (pointing to an invalid contact_id). Logging out and logging back in should correct this.