CiviCRM Community Forums (archive)

For some reason I cannot select multiple records, and Print PDF letter.

I was able to do it about 6 hours ago, but now nothing. 

This is mostly gibberish to me.. can someone help point me in the right direction?

Here's the backtrace..
#0 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB.php(968): PEAR_Error->PEAR_Error("DB Error: constraint violation", -3, 16, (Array:2), "INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...")
#4 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-3, 16, (Array:2), "INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...")
#5 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\common.php(1903): PEAR->raiseError(NULL, -3, NULL, NULL, "INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...", "DB_Error", TRUE)
#6 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-3, NULL, NULL, NULL, "1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp...")
#7 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...")
#9 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\DataObject.php(2421): DB_common->query("INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...")
#10 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\DB\DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES...")
#11 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\DAO.php(287): DB_DataObject->insert()
#12 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Activity\BAO\Activity.php(289): CRM_Core_DAO->save()
#13 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Contact\Form\Task\PDFLetterCommon.php(361): CRM_Activity_BAO_Activity::createActivityTarget((Array:2))
#14 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Contact\Form\Task\PDFLetterCommon.php(318): CRM_Contact_Form_Task_PDFLetterCommon::createActivities(Object(CRM_Contact_Form_Task_PDF), "", (Array:2))
#15 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Contact\Form\Task\PDF.php(114): CRM_Contact_Form_Task_PDFLetterCommon::postProcess(Object(CRM_Contact_Form_Task_PDF))
#16 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\Form.php(246): CRM_Contact_Form_Task_PDF->postProcess()
#17 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\StateMachine.php(159): CRM_Core_Form->mainProcess()
#18 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\QuickForm\Action\Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Form_Task_PDF), "next", "Next")
#19 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\HTML\QuickForm\Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Form_Task_PDF), "next")
#20 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\packages\HTML\QuickForm\Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Task_PDF), "next")
#21 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\Controller.php(289): HTML_QuickForm_Page->handle("next")
#22 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm\CRM\Core\Invoke.php(228): CRM_Core_Controller->run((Array:3), (Array:0))
#23 D:\xampp\htdocs\wp-content\plugins\civicrm\civicrm.php(271): CRM_Core_Invoke::invoke((Array:3))
#24 [internal function](): civicrm_wp_invoke("")
#25 D:\xampp\htdocs\wp-includes\plugin.php(403): call_user_func_array("civicrm_wp_invoke", (Array:1))
#26 D:\xampp\htdocs\wp-admin\admin.php(151): do_action("toplevel_page_CiviCRM")
#27 {main}
Here's the Error it's throwing at me..
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`wp_civicrm_internal`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`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] => INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES ( 1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_civicrm_internal`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_activity_target (activity_id , target_contact_id ) VALUES ( 1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_civicrm_internal`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`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_activity_target (activity_id , target_contact_id ) VALUES ( 1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_civicrm_internal`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE)]"]
)

The main part of the message is:

Cannot add or update a child row: a foreign key constraint fails (`wp_civicrm_internal`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`id`)

which means that it's trying to refer to an activity ID which doesn't exist. Did you delete any activities?

No, recreating won't help because IDs are consecutive and never repeated. Seems that activity id 1 is missing. Do you know how to examine your database via phpMyAdmin or similar?

If so, look for the first id in the civicrm_activity table and see if it's NOT 1.

I looked at a backup of my database, and it looks like the activities start with 384 on that one as well.. so i'm guessing that's not it.

SUCCESS  Thank you Hershel

I created a new record with ID 1 as suggested, and now it just works... now.. WHY does this work? Seems like something fishy is going on.

well.. do we go by the old addage if it ain't broke don't fix it?

or are you really curious?

Thanks again Hershel. Our members will be getting their renewal letters on time. 

For some reason I cannot select multiple records, and Print PDF letter.

Hello. This still seems to be a problem, and is reproducable on the (Joomla) demo. If you select multiple contacts and "Print PDF letter for contacts" with a template, the result is blank. Did anyone ever get to the bottom of this?

Thanks.