Author Topic: Changing the contact subtype of a custom data group after creation (Read 1892 times)

CiviTeacher.com · November 30, 2011, 04:37:28 pm

Someone created a custom data group for "Individuals" that should really be for a contact subtype of individuals called "Artists". The fields are blank - no data. I don't want to have to re-create the data group entirely that would be a lot of work.

I've tried making a change to the table civicrm_custom_group

Code: [Select]

update civicrm_custom_group set extends_entity_column_value = 'Artists' where id=1;

However this just hides the data field from all contacts, including the subtype 'Artists'. There must be another step that I am missing. Suggestions?

Thanks

Donald Lobo · November 30, 2011, 06:13:20 pm

1. check if extends_entity_column_value is a crtr-A delimited string (i think it is). if so, fix your update

2. also run: "truncate civicrm_cache" on the civicrmDB (if debug is set, u can do so by appending cacheCleanup=1 to a url)

lobo

CiviTeacher.com · December 02, 2011, 10:00:33 am

I used this query (which adds the ctrl-a) followed by a "truncate civicrm_cache" and that seems to work thanks.

Code: [Select]

UPDATE civicrm_custom_group
   SET extends_entity_column_value = CONCAT(CHAR(1), 'Artists', CHAR(1))
 WHERE id = 1

CiviCRM Community Forums (archive)

News:

Author Topic: Changing the contact subtype of a custom data group after creation (Read 1892 times)

CiviTeacher.com

Changing the contact subtype of a custom data group after creation

Donald Lobo

Re: Changing the contact subtype of a custom data group after creation

CiviTeacher.com

Re: Changing the contact subtype of a custom data group after creation