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

Upgrade process from 2.2.x to 3.0 incorrectly handles due_date_time/activity_date_time conversion

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.0
    • Component/s: CiviCase
    • Labels:
      None

      Description

      This line in the incremental upgrade file for 3.0 alpha 1 is backwards I think:

      UPDATE civicrm_activity ca INNER JOIN civicrm_case_activity cca ON ca.id = cca.activity_id
      SET activity_date_time = COALESCE( ca.due_date_time, ca.activity_date_time );

      Should be:

      UPDATE civicrm_activity ca INNER JOIN civicrm_case_activity cca ON ca.id = cca.activity_id
      SET activity_date_time = COALESCE( ca.activity_date_time, ca.due_date_time );

        Attachments

          Activity

            People

            • Assignee:
              rahulbile Rahul Bile
              Reporter:
              demeritcowboy Dave D
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: