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']