Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.4
-
Fix Version/s: 4.7.5
-
Component/s: Core CiviCRM
-
Labels:
-
Documentation Required?:None
-
Funding Source:Core Team Funds
Description
You can reproduce this on the 4.7 demo site. It works for 4.6.
- Click 'Search', 'Find Contacts'
- Click 'Search' to find them all.
- Click on the title 'Postal Code' to sort them on postal code.
- Click the radio button 'All X contacts', and select 'Mailing labels' from the actions menu.
- You get this error message:
Sorry but we are not able to provide this at the moment. DB Error: no such field
On my local instance, with debug turned on, I got more info:
Database foutcode: Unknown column 'civicrm_address.postal_code' in 'order clause', 1054
Aanvullende gegevens:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT contact_a.id as contact_id, civicrm_value_extra_info_14.id as civicrm_value_extra_info_14_id, civicrm_value_extra_info_14.type_abonnement_76 as custom_76 FROM civicrm_contact contact_a LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id )
LEFT JOIN civicrm_value_extra_info_14 ON civicrm_value_extra_info_14.entity_id = `civicrm_membership`.id WHERE ( civicrm_membership.status_id IN ("1", "2") AND civicrm_membership.membership_type_id = 2 AND civicrm_membership.is_test = 0 AND civicrm_value_extra_info_14.type_abonnement_76 IN ("2", "3") ) AND (contact_a.is_deleted = 0) ORDER BY civicrm_address.postal_code asc, contact_a.id [nativecode=1054 ** Unknown column 'civicrm_address.postal_code' in 'order clause']
[type] => DB_Error
[user_info] => SELECT contact_a.id as contact_id, civicrm_value_extra_info_14.id as civicrm_value_extra_info_14_id, civicrm_value_extra_info_14.type_abonnement_76 as custom_76 FROM civicrm_contact contact_a LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id )
LEFT JOIN civicrm_value_extra_info_14 ON civicrm_value_extra_info_14.entity_id = `civicrm_membership`.id WHERE ( civicrm_membership.status_id IN ("1", "2") AND civicrm_membership.membership_type_id = 2 AND civicrm_membership.is_test = 0 AND civicrm_value_extra_info_14.type_abonnement_76 IN ("2", "3") ) AND (contact_a.is_deleted = 0) ORDER BY civicrm_address.postal_code asc, contact_a.id [nativecode=1054 ** Unknown column 'civicrm_address.postal_code' in 'order clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT contact_a.id as contact_id, civicrm_value_extra_info_14.id as civicrm_value_extra_info_14_id, civicrm_value_extra_info_14.type_abonnement_76 as custom_76 FROM civicrm_contact contact_a LEFT JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id LEFT JOIN civicrm_contribution_recur ccr ON ( civicrm_membership.contribution_recur_id = ccr.id )
LEFT JOIN civicrm_value_extra_info_14 ON civicrm_value_extra_info_14.entity_id = `civicrm_membership`.id WHERE ( civicrm_membership.status_id IN ("1", "2") AND civicrm_membership.membership_type_id = 2 AND civicrm_membership.is_test = 0 AND civicrm_value_extra_info_14.type_abonnement_76 IN ("2", "3") ) AND (contact_a.is_deleted = 0) ORDER BY civicrm_address.postal_code asc, contact_a.id [nativecode=1054 ** Unknown column 'civicrm_address.postal_code' in 'order clause']"]
)