Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.4.4
-
Fix Version/s: 4.7
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
After upgrading to 4.4.4, I'm seeing DB Error: no such field errors on teh Change Log tab for all contact records that have activities recorded with them.
Backtrace includes the following:
#0 /home/administrator/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /usr/share/php/PEAR.php(890): call_user_func((Array:2), Object(DB_Error))
#3 /home/administrator/drupal/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\nSELECT activity_type_id\n FROM `peat-civicrm`.log_civicrm_activity_contact...")
It looks like it's looking for a column called activity_type_id, but the actual name in the DB is activity_id. Renaming the field leads to a new set of errors where the query is looking for activity_id, so I'm guessing that something got renamed in some places but not others within the code.