CiviCRM Community Forums (archive)

I have someone donating a recurring monthly amount. It posted the first one fine but none of the recurrings show up after processed by paypal. After the first do I have to add the monthly's manually?

the recurring has posted in paypal for three months but my civicrm still only shows the first. Have I missed a step in setting up my contribution page? Where is the log? am I possibly not running a cronjob to process the IPN?

Joomla 1.0.15 CiviCRM 2.0.5
I looked in the log file and found this error. Any Ideas?

Sep 23 08:21:02  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

     => -1
   

[message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contribution (domain_id , contribution_page_id , receive_date , total_amount , fee_amount , net_amount , trxn_id , invoice_id , receipt_date , source , contribution_recur_id , contribution_status_id ) VALUES ( 1 ,  1 ,  20080923082102 ,  20.00 ,  0.74 ,  19.26 , '2YL941335B104840W' , '95c1b15cb3eabccefd3510cf322638bd' ,  20080923082102 , 'Online Contribution: Donations' ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`**********/civicrm_contribution`, CONSTRAINT `FK_civicrm_contribution_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contribution (domain_id , contribution_page_id , receive_date , total_amount , fee_amount , net_amount , trxn_id , invoice_id , receipt_date , source , contribution_recur_id , contribution_status_id ) VALUES ( 1 ,  1 ,  20080923082102 ,  20.00 ,  0.74 ,  19.26 , '2YL941335B104840W' , '95c1b15cb3eabccefd3510cf322638bd' ,  20080923082102 , 'Online Contribution: Donations' ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`*********/civicrm_contribution`, CONSTRAINT `FK_civicrm_contribution_contact_id` FOREIGN KEY (`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_contribution (domain_id , contribution_page_id , receive_date , total_amount , fee_amount , net_amount , trxn_id , invoice_id , receipt_date , source , contribution_recur_id , contribution_status_id ) VALUES ( 1 ,  1 ,  20080923082102 ,  20.00 ,  0.74 ,  19.26 , '2YL941335B104840W' , '95c1b15cb3eabccefd3510cf322638bd' ,  20080923082102 , 'Online Contribution: Donations' ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`********/civicrm_contribution`, CONSTRAINT `FK_civicrm_contribution_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)