CiviCRM Community Forums (archive)

View a contact and click on the membership tab.

Under the tab you see the following text:

"Current and inactive memberships for [Contact Name] are listed below. Click New Membership to record a new membership."

Clicking on New Membership throws an error

backTrace

/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Error.php, backtrace, 245
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/SelectValues.php, fatal, 392
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Member/Form/Membership.php, date, 218
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 314
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 195
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 95
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Controller.php, handle, 223
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Contact/Page/View/Membership.php, run, 165
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Contact/Page/View/Membership.php, edit, 188
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, run, 407
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, contact, 94
/var/www/drupal.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/drupal/civicrm.module, invoke, 321
, civicrm_invoke,
/var/www/drupal.civicrm.org/public/includes/menu.inc, call_user_func_array, 418
/var/www/drupal.civicrm.org/public/index.php, menu_execute_active_handler, 15

This looks like sandbox related issue (some setup issue). I was not able to replicate this. will get back once this is resolved.

kurund

Hi Kurund,

Thanks for fixing the sandbox....however, when I try and save a membership record I get the following error:

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm_sandbox/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL), 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_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 21 ,  4 ,  20070325 ,  20060326 ,  107 ,  20080114 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_sandbox/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 21 ,  4 ,  20070325 ,  20060326 ,  107 ,  20080114 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_sandbox/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_membership_log (membership_id , status_id , start_date , end_date , modified_id , modified_date ) VALUES ( 21 ,  4 ,  20070325 ,  20060326 ,  107 ,  20080114 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_sandbox/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]"]
)

Not sure if this is also a configuration issue so have posted here.

I'll post any other reports to the Dev Team Bug Report

must of been some kind of session issue. Works fine. Thanks. BTW v2 looks real good!