CiviCRM Community Forums (archive)

Hi friends,
Iam getting an error while registering for an event in civicrm.the error log is given below , can anybody help me.
Iam using drupal 5.7 and civicrm 2.0.5

Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`mydb_test/civicrm_financial_trxn`, CONSTRAINT `FK_civicrm_financial_trxn_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE), 1452

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_financial_trxn (domain_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 ,  20080825103547 , 'Debit' ,  10 ,  10 , 'USD' , 'Dummy' , 'test00000005' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydb_test/civicrm_financial_trxn`, CONSTRAINT `FK_civicrm_financial_trxn_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_financial_trxn (domain_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 ,  20080825103547 , 'Debit' ,  10 ,  10 , 'USD' , 'Dummy' , 'test00000005' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydb_test/civicrm_financial_trxn`, CONSTRAINT `FK_civicrm_financial_trxn_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`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_financial_trxn (domain_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 ,  20080825103547 , 'Debit' ,  10 ,  10 , 'USD' , 'Dummy' , 'test00000005' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`mydb_test/civicrm_financial_trxn`, CONSTRAINT `FK_civicrm_financial_trxn_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE)]"]
)
Feature[/b]

Binoy:

Before posting It's always a good practice to search forum for similar errors, few links that might be helpful:

http://forum.civicrm.org/index.php/topic,2283.0.html
http://forum.civicrm.org/index.php/topic,3760.0.html

HTH

Kurund

Hi friend,
I create a event in  http://drupal.demo.civicrm.org/ with name new event for the demo, also registered in the same with a email id, it was a a successful registration. I didn't get the error from that, can u tell me what may be the problem with mine installation. i pasted the sql query in phpmysql ,that outputed in the error log , there also iam getting same error that foreign key contraints.

Iam using drupal 5.7 and civicrm 2.0.5

Hey,

Could you try to set up similar event registration page on http://drupal.demo.civicrm.org/ and try to reproduce this error?

Thx,
m

Hi Friends,
Thanks for your help, Now the registration is working without giving any error,

I think the following procedure gives me the result
1. First delete all test participant records.
2. Empty civicrm_financial_trxn table.
 then i created new event and joined in that event , then i didn't get any error from there.
Thanks freinds.

Binoy