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

auto responder non-recoverable error when disabled

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.4
    • Fix Version/s: 1.4
    • 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://

      {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]
      [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=3 mode=callback callback=CRM_Core_Error::handle prefix="" 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]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              fen Fen Labalme
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: