CiviCRM Community Forums (archive)

When I go from the first page of the CiviMail wizard new mailing to the second page, I get this error:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: constraint violation

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`cctvcivicrm/civicrm_mailing`, CONSTRAINT `FK_civicrm_mailing_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_mailing (name , created_id ) VALUES ('test mailing' ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cctvcivicrm/civicrm_mailing`, CONSTRAINT `FK_civicrm_mailing_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_mailing (name , created_id ) VALUES ('test mailing' ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cctvcivicrm/civicrm_mailing`, CONSTRAINT `FK_civicrm_mailing_created_id` FOREIGN KEY (`created_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="INSERT INTO civicrm_mailing (name , created_id ) VALUES ('test mailing' ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`cctvcivicrm/civicrm_mailing`, CONSTRAINT `FK_civicrm_mailing_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

I just upgraded from 2.1 to 2.2 on Monday. I am pretty sure we have started and sent multiple mailings since then. This one just started showing up this morning. Ideas?

oh. yup. thanks!