Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-2919

2.0 migration script only migrates some membership ah records

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      – memberships
      The following query moves ah membership records to the activity table:

      SELECT @ov_id_membership := value FROM civicrm_option_value WHERE option_group_id = @og_id_at AND label='Membership Signup';

      INSERT INTO civicrm_activity (`source_contact_id`, `source_record_id`, `activity_type_id`, `subject`, `activity_date_time`, `due_date_time`, `duration`, `location`, `phone_id`, `phone_number`, `details`, `status_id`, `priority_id`, `parent_id`, `is_test`)
      SELECT ah.entity_id, ah.activity_id, @ov_id_membership, ah.activity_summary,
      ah.activity_date, NULL, NULL, NULL, NULL, NULL,
      ah.activity_summary, @ov_id_completed, NULL, NULL, ah.is_test
      FROM civicrm_activity_history ah
      WHERE ah.module IN ('CiviMember') AND ah.activity_type='Membership - New'
      GROUP BY ah.module, ah.entity_id;

      But what about all the records where activity_type != 'Membership - New'? See CRM-2914 for a list of such ah records.

      I caught this while working on another bug. But I won't have opportunity to work on it during this project since my current project has no membership data.

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              dalin dave hansen-lange
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: