CiviCRM Community Forums (archive)

When trying to add a member in our organization, we now get the following errors:  How do we fix this?
It was working.

This is Civi 2.0.2 with Drupal 5

------------------------------------------
Sorry. A non-recoverable error has occurred.

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`userweb11146a/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE), 1452



Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_membership (contact_id , membership_type_id , source , status_id , is_override ) VALUES ( 145 ,  4 , 'Online Contribution: Join the Oceanic Society' ,  5 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`userweb11146a/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_membership (contact_id , membership_type_id , source , status_id , is_override ) VALUES ( 145 ,  4 , 'Online Contribution: Join the Oceanic Society' ,  5 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`userweb11146a/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`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_membership (contact_id , membership_type_id , source , status_id , is_override ) VALUES ( 145 ,  4 , 'Online Contribution: Join the Oceanic Society' ,  5 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`userweb11146a/civicrm_membership`, CONSTRAINT `FK_civicrm_membership_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]"]
)