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

Upgrade problem [Unknown column 'e.contact_id' in 'on clause']

    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

      When I try to upgrade to 4.6 alpha 4 I get the following error:

      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 = event_start_date WHERE reminder.action_date_time >= DATE_SUB(reminder.action_date_time, INTERVAL 9 MONTH) AND m.membership_type_id IN (38, 39, 32, 33, 34, 35, 36, 37) [nativecode=1054 ** Unknown column 'e.contact_id' in 'on clause']

      One was a drupal 7.34 on 4.6 alpha 2 and another one a joomla 3.3 site on 4.5.5. Both with an existing set of memberships.

      Would this more likely point to a problem in our database? Of a problem in the upgrade script? I get this error on two independent sites.

      forum topic: http://forum.civicrm.org/index.php/topic,35589.msg151256.html

        Attachments

          Activity

            People

            • Assignee:
              pratiksha pratiksha
              Reporter:
              magnolia61 Richard
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: