CiviCRM Community Forums (archive)

I'm running Drupal 5.6 and civiCRM 2.0 ... and can't get CiviMember to work with my CiviContribute pages.  I set up 3 membership types, all with Oceanic Society as the "group"  (which is the name of the website).

I can easily set up a contribution page with membership amounts, but when I use the CiviMember profile, I get the following error when processing.      I'd really appreciate any help on this, since it seems most people have no trouble using CiviMember:


unrecoverable error
    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

    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_membership (contact_id , membership_type_id , source , status_id , is_override ) VALUES ( 102 ,  4 , 'Online Contribution: Join the Oceanic Society - membership profile' ,  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 ( 102 ,  4 , 'Online Contribution: Join the Oceanic Society - membership profile' ,  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 ( 102 ,  4 , 'Online Contribution: Join the Oceanic Society - membership profile' ,  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)]"]
)




Thanks very much.  This is a big help.