Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.16
-
Fix Version/s: 4.7.16
-
Component/s: CiviReport
-
Labels:
-
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
Issue Links
Activity
Just updated the affected version as PR 9411 only went in in 4.7.16 cycle
Can confirm folloiwng PR 9861 being merged that this now works
Regression from https://github.com/civicrm/civicrm-core/pull/9411. It was a missing whitespace that caused the DB error.