Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.5
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
1.5 Beta on demo.civicrm.org
Click into a contact record.
Click on Membership Tab
Click on "new membership"
save
yields 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 (`demo_civicrm/civicrm_membership`, CONSTRAINT `civicrm_membership_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`)), 1452
Return to CiviCRM menu.
error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_membership (contact_id , membership_type_id , join_date , start_date , end_date , source , status_id , is_override ) VALUES ( 101 , 2 , 20060820 , 20060820 , 20060827 , NULL , 0 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`demo_civicrm/civicrm_membership`, CONSTRAINT `civicrm_membership_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`))]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_membership (contact_id , membership_type_id , join_date , start_date , end_date , source , status_id , is_override ) VALUES ( 101 , 2 , 20060820 , 20060820 , 20060827 , NULL , 0 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`demo_civicrm/civicrm_membership`, CONSTRAINT `civicrm_membership_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`))]
[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 , join_date , start_date , end_date , source , status_id , is_override ) VALUES ( 101 , 2 , 20060820 , 20060820 , 20060827 , NULL , 0 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`demo_civicrm/civicrm_membership`, CONSTRAINT `civicrm_membership_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`))]"]
)