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

Changes in domain table schema causing fatal query error in CiviMail New Mailing wizard

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: Accounting Integration
    • Labels:
      None

      Description

      New Mailling - click continue from step 3 (Mailing Content), I get fatal error:
      Database Error Code: Unknown column 'ev.loc_block_id' in 'where clause', 1054
      DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
      ph.id as phone_id, ph.location_type_id as locationTypeId
      FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
      WHERE ev.id = 1
      AND loc.id = ev.loc_block_id
      AND ph.id IN (loc.phone_id, loc.phone_2_id)
      AND ltype.id = ph.location_type_id
      ORDER BY ph.is_primary DESC, phone_id ASC [nativecode=1054 ** Unknown column 'ev.loc_block_id' in 'where clause']

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: