CiviCRM Community Forums (archive)

I have a Civi install on 2.2. I had tried to upgrade it recently and was getting FK issues, so my plan was to do the database procedure to cleanse the data and then try again.

In the meantime, I'm seeing some odd membership behavior. I first see it when I was trying to run the civimember cron; it runs for about a minute and then outputs this debug statement:
backTrace

/home/naaeenet/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 258
/home/naaeenet/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, fatal, 707
/home/naaeenet/public_html/sites/all/modules/civicrm/CRM/Activity/BAO/Activity.php, getFieldValue, 1070
/home/naaeenet/public_html/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, addActivity, 307
/home/naaeenet/public_html/sites/all/modules/civicrm/api/v2/Membership.php, create, 395
/home/naaeenet/public_html/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php, civicrm_contact_membership_create, 168
/home/naaeenet/public_html/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php, updateMembershipStatus, 256

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    We experienced an unexpected error. Please file an issue with the backtrace

    Return to home page.


It does seem to be updating membership records until it gives that. To try to debug this, I took a look at the membership types and they all appear to be connected to the 'Employer of' relationship. However, I can't edit that field, nor can I edit renewal reminder settings (please see attached screenshot for what it looks like). Then I went to look at the employer of relationship, and that also does not offer me an edit option as it should (nor does household relationships). I am attaching a second screenshot of this view as well. I am pretty certain this should not be the case. Any idea on what's going on and how I might fix my db to resolve all of this?

FYI -- this org was originally on a 'caravan' installation of civi but wanted to leave and use straight civi. the caravan folks said the db should function the same in regular civi and gave a dump of the civi database for us. i wonder if this is a bad side effect...

Help is greatly appreciated.

OK, slowly making progress. I set renewal_msg_id in civicm_membership_type to NULL for all my entries, and that popped that part of my form back. It seemed to have a corrupted id number in it. 

I then tried to set relationship_type_id to NULL as well, but I just get a blank on my config screen with no selector (see attached screenshot). I cleared my templates_c folder and tried directoryCleanup but nothing seems to get this popup back. What else would I need to reset to see it? If I start a NEW membership type, I can see the selector. Ideas?