CiviCRM Community Forums (archive)

Using PayPal Sandbox - this is what I get on the final submission for a test payment. I've seen a lot of posts referencing "foreign key restraint" - what gives? If somebody could give me explicit instructions if there's database manipulation involved that would be spectacular; I'm a designer, not a coder. Thank you much in advance for your help - the whole installation process has been pretty unbearable, but I'm hoping it will be worth it in the end. Thanks much!

   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 home page.

Error Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  102 , 'civicrm_contact,102' ,  102 ,  20080328104946 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  102 , 'civicrm_contact,102' ,  102 ,  20080328104946 )  [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_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  102 , 'civicrm_contact,102' ,  102 ,  20080328104946 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)
[/code]

Thank you - thank you! You were, indeed, correct. Hopefully this will be the last of the "speed bumps" - many thanks!