Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.4
-
Fix Version/s: 1.4
-
Component/s: Technical infrastructure
-
Labels:None
Description
civicrm v1.4 rev 6012 - uncheck Default and Enabled from autoresponder mailing component page results in:
Sorry. A non-recoverable error has occurred.
Database Error Code: Cannot add or update a child row: a foreign key constraint fails, 1216
Return to CiviCRM menu.
error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , unsubscribe_id , optout_id , name , from_name , from_email , replyto_email , subject , body_text , body_html , is_template , url_tracking , forward_replies , auto_responder , open_tracking , is_completed ) VALUES ( 1 , 1 , 2 , 5 , 6 , 'jul12.2' , 'fen jul12.2' , 'fen@civicactions.com' , 'fen@civicactions.com' , 'jul12.2' , 'this is a test message - if you received it, you can ignore it\n\ncheck out CivicActions <http://www.civicactions.com/> (test link).\n\nPlease log in and edit your personal information:\nhttp://
/user/
{contact.external_identifier}/edit/\">log in and\n edit</a> your personal information\n<hr>\n<ul>\n<font size=\"small\">\nBrought to you by {domain.address}\n<li>To opt out of receiving these messages,\n<a href=\"{action.optOut}\">click here</a></li>\n<li>To unsubscribe from this mailing list,\n<a href=\"{action.unsubscribe}\">click here</a></li>\n</font>\n</ul>\n' , 0 , 0 , 1 , 0 , 1 , 0 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails][type] => DB_Error
[user_info] => INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , unsubscribe_id , optout_id , name , from_name , from_email , replyto_email , subject , body_text , body_html , is_template , url_tracking , forward_replies , auto_responder , open_tracking , is_completed ) VALUES ( 1 , 1 , 2 , 5 , 6 , 'jul12.2' , 'fen jul12.2' , 'fen@civicactions.com' , 'fen@civicactions.com' , 'jul12.2' , 'this is a test message - if you received it, you can ignore it\n\ncheck out CivicActions <http://www.civicactions.com/> (test link).\n\nPlease log in and edit your personal information:\nhttp://{domain.name}/user/{contact.external_identifier}
/edit/\n\n----\nBrought to you by
{domain.address}\n\nTo opt out of receiving these messages, send email to\n{action.optOut}\n\nTo unsubscribe from this mailing list, send email to\n{action.unsubscribe}\n' , '<p>\nthis is a test message - if you received it, you can ignore it\n</p>\n<blockquote>\ncheck out <a href=\"http://www.civicactions.com/\">CivicActions</a> (test link).\n</blockquote>\nPlease <a href=\"http://{domain.name}/user/{contact.external_identifier}/edit/\">log in and\n edit</a> your personal information\n<hr>\n<ul>\n<font size=\"small\">\nBrought to you by {domain.address}\n<li>To opt out of receiving these messages,\n<a href=\"
{action.optOut}\">click here</a></li>\n<li>To unsubscribe from this mailing list,\n<a href=\"{action.unsubscribe}\">click here</a></li>\n</font>\n</ul>\n' , 0 , 0 , 1 , 0 , 1 , 0 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails][to_string] => [db_error: message="DB Error: constraint violation" code=
\n\nTo unsubscribe from this mailing list, send email to\n
{action.unsubscribe}\n' , '<p>\nthis is a test message - if you received it, you can ignore it\n</p>\n<blockquote>\ncheck out <a href=\"http://www.civicactions.com/\">CivicActions</a> (test link).\n</blockquote>\nPlease <a href=\"http://{domain.name}/user/{contact.external_identifier}/edit/\">log in and\n edit</a> your personal information\n<hr>\n<ul>\n<font size=\"small\">\nBrought to you by {domain.address}\n<li>To opt out of receiving these messages,\n<a href=\"{action.optOut}\">click here</a></li>\n<li>To unsubscribe from this mailing list,\n<a href=\"{action.unsubscribe}\">click here</a></li>\n</font>\n</ul>\n' , 0 , 0 , 1 , 0 , 1 , 0 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)