CiviCRM Community Forums (archive)

This picks up the conversation on topic http://forum.civicrm.org/index.php/topic,21885.msg92463.html#msg92463

Ive got a bunch of custom field groups and Ive copied all the db stuff to settings.php

When I am adding custom fields to the view, all these custom field groups show up except the one with ID = 1.

Instead, those fields that are supposed to show up in the custom field  group show up in the contacts group.

This breaks the view because the custom fields do not belong in the contacts group. So the SQL I get is

SELECT users.uid AS uid,
   civicrm_contact.first_name AS civicrm_contact_first_name,
   civicrm_contact.id AS civicrm_contact_id,
   civicrm_contact.custom_83 AS civicrm_contact_custom_83
 FROM users users
 LEFT JOIN `lscd7_civ`.civicrm_uf_match civicrm_uf_match ON users.uid = civicrm_uf_match.uf_id
 LEFT JOIN `lscd7_civ`.civicrm_contact civicrm_contact ON civicrm_uf_match.contact_id = civicrm_contact.id
 WHERE users.uid = 28

When it should be

SELECT users.uid AS uid,
   civicrm_contact.first_name AS civicrm_contact_first_name,
   civicrm_contact.id AS civicrm_contact_id,
   civicrm_value_lsc_members_1.custom_83 AS civicrm_value_lsc_members_1_custom_83
 FROM users users
 LEFT JOIN `lscd7_civ`.civicrm_uf_match civicrm_uf_match ON users.uid = civicrm_uf_match.uf_id
 LEFT JOIN `lscd7_civ`.civicrm_contact civicrm_contact ON civicrm_uf_match.contact_id = civicrm_contact.id
 WHERE users.uid = 28

So the view breaks.

Any ideas how I can fix this?

I optimised the table and it then appeared. Phew.