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

DB Error on Activity Details Report

    Details

    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Core Team Funds
    • Verified?:
      No

      Description

      It looks like a recent regression. On demo master, run a search
      http://dmaster.demo.civicrm.org/civicrm/report/instance/3

      [message] => DB Error: no such table
      [mode] => 16
      [debug_info] =>
      ALTER TABLE civireport_activity_temp_target
      MODIFY COLUMN civicrm_contact_contact_target_id VARCHAR(128),
      ADD COLUMN civicrm_contact_contact_assignee VARCHAR(128),
      ADD COLUMN civicrm_contact_contact_source VARCHAR(128),
      ADD COLUMN civicrm_contact_contact_assignee_id VARCHAR(128),
      ADD COLUMN civicrm_contact_contact_source_id VARCHAR(128),
      ADD COLUMN civicrm_phone_contact_assignee_phone VARCHAR(128),
      ADD COLUMN civicrm_phone_contact_source_phone VARCHAR(128),
      ADD COLUMN civicrm_email_contact_assignee_email VARCHAR(128),
      ADD COLUMN civicrm_email_contact_source_email VARCHAR(128)

        Attachments

          Activity

            People

            • Assignee:
              jitendra.purohit Jitendra Purohit
              Reporter:
              yashodha Yashodha Chaku
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: