Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6
-
Fix Version/s: 4.6
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
Description
In testing 4.6.alpha5, I tested an existing databnse upgrade from 4.5.6. The upgrade failed with the following information:
[Error: Add and update reference_date column for Schedule Reminders]
Error Field Error Value
Type DB_Error
Code -19
Message DB Error: no such field
Mode 16
UserInfo UPDATE civicrm_action_log reminder LEFT JOIN civicrm_membership m ON reminder.entity_id = m.id AND reminder.entity_table = 'civicrm_membership' AND ( m.is_override IS NULL OR m.is_override = 0 ) INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0 SET reminder.reference_date = m.join_date WHERE reminder.action_date_time >= DATE_SUB(reminder.action_date_time, INTERVAL 9 MONTH) AND m.membership_type_id IN (1, 2, 3, 4, 5, 6, 7, 8) [nativecode=1054 ** Unknown column 'e.contact_id' in 'on clause']
DebugInfo UPDATE civicrm_action_log reminder LEFT JOIN civicrm_membership m ON reminder.entity_id = m.id AND reminder.entity_table = 'civicrm_membership' AND ( m.is_override IS NULL OR m.is_override = 0 ) INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0 SET reminder.reference_date = m.join_date WHERE reminder.action_date_time >= DATE_SUB(reminder.action_date_time, INTERVAL 9 MONTH) AND m.membership_type_id IN (1, 2, 3, 4, 5, 6, 7, 8) [nativecode=1054 ** Unknown column 'e.contact_id' in 'on clause']