CiviCRM Community Forums (archive)

Hi All,
I am unable to successfully run updatemembershiprecord.php. I'm running 2.2.8 on Drupal - had the same issue with previous versions and didn't bother too much as the client worked around it - they now need it.... The backtrace I get is as follows:

Updating ...
backTrace

/home/salt8064/public_html/ssic/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 258
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/CRM/Core/DAO.php, fatal, 707
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/api/v2/MembershipContact.php, getFieldValue, 279
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/api/v2/MembershipContact.php, _civicrm_membership_format_params, 74
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/api/v2/Membership.php, civicrm_membership_contact_create, 85
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php, civicrm_contact_membership_create, 139
/home/salt8064/public_html/ssic/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php, updateMembershipStatus, 267

I have 5,739 "Individual" records (12,272 including "Households") - doesn't seem like it should be excessive or difficult for the script to deal with...?? I have commented out the email send portion of the file, as we don't want reminders sent from this system. I have commented out as follows:
/*
//send reminder for membership renewal
            if ( $dao->reminder_date && ( $reminder_date <= $today_date ) ) {
...
...
...
            }
*/
            // CRM_Core_Error::debug( 'fEnd', count( $GLOBALS['_DB_DATAOBJECT']['RESULTS'] ) );

Make sense?
 
It takes approximately 5 seconds to return me the "Non Recoverable Error" message, so is not (apparently) timing out!

Help - I must be missing something obvious?
Cheers,
Marty.

hi Marty,

can u please copy this code to membership cron ( bin/UpdateMembershipRecord.php ) at line around 138 just after "if statement".
crm_core_error::debug( 'deceasedMembership', $deceasedMembership );
exit();

also can u check that "Deceased" membership status is present and is having 'is_active' = true in your membership statuses.
(do check civicrm_membership_status table )


thanks

kiran

I don't see a deceased membership rule (see screenshot) and I'm not quite sure what details I would add to create one. I added the debug statement and then the UpdateMembershipRecord.php script gave this result:

Updating ..

deceasedMembership

Array
(
    [id] => 6
    [status_id] =>
    [contact_id] => 73
    [membership_type_id] => 2
    [join_date] => 2007-03-05
    [start_date] => 2007-03-05
    [end_date] => 2007-12-04
    [reminder_date] =>
    [source] => Check
    [skipStatusCal] => 1
    [createActivity] => 1
)

I created a new rule named "Deceased" and made it admin only and activated.

The script gave an error when I tried to run it next, but it seems to have run the next time I ran it.

Should this be added to the wiki or is it more of a special case? I'm happy to add it but don't want to clutter it up if it would be more beneficial to just leave it in the forum.

Done: I added a line to the upgrade wiki page.