CiviCRM Community Forums (archive)

+---------------------+-------------+----------------+----------------------------------------+
| log_date            | log_user_id | log_action     | contact_sub_type                       |
+---------------------+-------------+----------------+----------------------------------------+
| 2012-11-16 11:42:20 |        7768 | Initialization |
School
Further_Education_Institution
|
| 2014-05-29 16:29:31 |       38748 | Update         |
Further_Education_Institution
        |
| 2014-05-31 23:31:13 |       97799 | Update         |
School
Further_Education_Institution
|
| 2014-06-03 14:56:36 |       38748 | Update         |
Further_Education_Institution
        |
| 2014-06-05 11:59:33 |        NULL | Update         |
School
Further_Education_Institution
|
+---------------------+-------------+----------------+----------------------------------------+

This school is meant to be of type Further_Education_Institution, yet it somehow keeps reverting back to SchoolFurther_Education_Institution.

The third instance is someone who is a logged in user who is not meant to be able to change the contact's type. The fifth instance is bizarre - how can a change be made by someone who isn't logged in?

Is there a way of, when data is accessed, that somehow mutating the organisation's type? Or is the only way that this can be happening in our code somewhere there's some borky stupid hack to result in this insanity?

Thanks,

JohnFF

It turns out that this was caused by our webform settings!

If you set a contact's subtype for a contact that you're creating, it rightly creates the new contact as having that contact subtype.

What no one here realised is that it will adjust referenced existing contacts to match the types selected.

We have an Individual subtype Student, and two Organisation subtypes (Further Education Institution and School), either of which a Student can sign up to.

So if a Student signs up to a Further Education Institution, and you need the School to be referenced on the Student's custom field, then you might well set the webform contact's Organisation type to be School and Further Education Institution (as it can be either).

However, if the Student signs up to a Further Education Institution, then the webforms will set the related organisation subtypes to be School and Further Education Institution!