CiviCRM Community Forums (archive)

This has been a problem since 3.4.2 thru 3.4.5.  Creating a CiviCRM view containing 2 custom fields.  One is a Description field, the other is a multi-select field.  Hershel had to create a custom template to get around the problem.

Here is the sql that is being generated and the dialog with Hershel about the problem.

user warning: Unknown column 'civicrm_contact.custom_16' in 'field list' query: SELECT civicrm_membership.id AS id, civicrm_contact.first_name AS civicrm_contact_first_name, civicrm_contact.id AS civicrm_contact_id, civicrm_contact.last_name AS civicrm_contact_last_name, civicrm_contact.organization_name AS civicrm_contact_organization_name, civicrm_contact.custom_16 AS civicrm_contact_custom_16, civicrm_contact.custom_15 AS civicrm_contact_custom_15 FROM `widny_civicrm`.civicrm_membership civicrm_membership LEFT JOIN `widny_civicrm`.civicrm_contact civicrm_contact ON civicrm_membership.contact_id = civicrm_contact.id LIMIT 0, 10 in /home/widny/www/www/sites/all/modules/views/includes/view.inc on line 771.

From Hershel:

These two fields:
CiviCRM Contacts: Organization Description
CiviCRM Contacts: Advertiser Categories
are causing the problem. Views is using the API format for custom fields instead of the SQL format. I have no idea why. the SQL is not JOINing civicrm_value_resource_directory_info_4 and I don't know why.

Is anyone else having this issue?

Is there a patch for 3.4.5?