CiviCRM Community Forums (archive)

I have a small group of about 20 members (within a database of hundred of members) whose memberships are 'stuck' in a certain status. Initially they were stuck as 'current' even though the expiration date was past.

Manually editing a membership to change the status via override fails to save the status change, even though CiviCRM claims the change was saved successfully.

Using "Batch update members via profile" I can get the status to change, but that does solve the underlying problem: manual editing still fails, and the membership scheduled job does not work on these memberships.

I am thinking the most likely cause is some sort of foreign key constraint that has got out of whack during a long database import/export/schema issue I had last year.

Any ideas how I can get these memberships to auto-update again, other than simply deleting and re-entering them?

Following an update of CiviCRM to the latest version, I am now getting a bit more information about the problem.

When trying to manually set the status of a membership from 'current' to 'grace' from the edit membership screen, I get the following error:

Mandatory key(s) missing from params array: one of (activity_name, activity_type_id, activity_label)
Any idea what might be causing this error? I appear to have a growing number of memberships stuck in this status.

I thought it might be manual overrides, which are desigined not to update automatically, however I have established that that is not the issue.

Hi Joanne, thanks for the reply.

It appears to affect all memberships.

I've checked the membership status rules multiple times (check them again to be sure) and they all look good to me. They're basically the CiviCRM defaults

Current Membership Ends > Grace for 1 month > Expired starts one month after end of membership.

Is there anything else that could stop it working? The error above looks almost like a bad API call or something.

I finally worked out the problem.

A missing entry in the  civicrm_option_value table triggered a fatal error when called from civicrm/CRM/Member/BAO/Membership.php (line 152).

CiviCRM was trying to record the 'activity' when a membership changes status and breaking because of the missing entry.

Solution was to put an entry into the civicrim_option_value table with the following values:

INSERT INTO `civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`) VALUES
(977, 2, 'Change Membership Status', '18', 'Change Membership Status', NULL, 1, NULL, 18, 'Change Membership Status.', 0, 1, 1, 3, NULL, NULL);
The key element being the presence of the 'Change Membership Status' name ... other values may change from database to database, and I have to admit to guessing values for some columns, however if stops the membership update cron, etc, from failing.

Do you have the scheduled job enabled and a Cron job running on your server to trigger it?  And have you run into the same error as the original poster when trying to manually change one of the membership statuses?

No problem, that is an easily missed thing and you aren't alone .