CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't see custom relationships when creating custom field set
Pages: [1]

Author Topic: Can't see custom relationships when creating custom field set  (Read 715 times)

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Can't see custom relationships when creating custom field set
May 17, 2012, 07:40:07 am
Hello,

I recently upgraded from 4.0.7 to 4.1.0 and am having an issue.  When creating (or editing) a custom field set through the admin, when I select "Relationships", only some of the relationships show up.  What I found when looking at the data was that the ones who had a contact subtype in the "B" slot of the relationship (for example: "Organization - Committee") didn't show up.

The existing data that was set up still works in other areas (the field set shows up only for the proper relationship when viewing), but I'm unable to edit these field set settings because the drop-down no longer contains the relevant relationship, and therefore upon saving it saves it as being for the standard Relationship object.

I tried creating a new Relationship from scratch ("Individual" to "Organization - Committee") and it didn't show up either.  I also went to the demo site and tried to recreate this, but was unable to.. the new relationship shows up there.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 08:07:17 am
Hard to see what the issue is without looking at the site.....the contact types have not changed and the contact subtypes came over correctly?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 08:22:03 am
Yes, the functionality in the site works.. the custom field sets show up for the correct relationships, the subtypes are working correctly, and the custom data is there.  It's just that the relationships no longer show up in the drop down when "Relationships" is selected for "Used For" in the Custom Field Set add/edit screen.

I accidentally saved while editing one custom field set and it seems to have set it to extending the base Relationship object (it changed civicrm_custom_group.extends_entity_column_value from 11 to NULL).  I've tried manually setting the column back to 11 and so far it's not showing back up under the correct relationship type.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 09:00:36 am
No, changing that column manually will not work. There are more tables to consider, it is better to create the field again in the set? At least I gather from your description the field was deleted or something like that? Could well be that is the reason it is getting confused.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 09:18:08 am
Not exactly.. here is a better description.

I edited an existing custom field set (selected the field set and selected "Settings").  I went to change the name of the set, and when I went to save it notified me that "One or more subtypes has been un-selected from the list.  Any custom data associated with un-selected subtype would be removed.  Click OK to proceed."  That was when I noticed that the sub-types of Relationship were not showing up in the drop-down, as mentioned above.

These sub-types of Relationship also do not show up in the drop down when creating a new custom field set, and when I created a new Relationship with data like the above mentioned (where the "B" object was a subtype of Organization), that Relationship did not show up either.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 10:04:19 am
As said before, hard to give any suggestions without actually seeing the site, especially as you can not reproduce the problem at the demo site. How are your PHP/debugging skills?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 10:28:15 am

try upgrading to 4.1.2. We'v fixed a few contact sub-type issues there

You might need to re-create the relationships

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 11:22:14 am
The 4.1.2 upgrade fixed it!

Thanks all.. as an aside, I've worked with quite a few open source communities, and I must say the ease of use and communication with Civi is bar none!  Being able to get such a quick response from contributors and creators so quickly is something that is certainly unique :)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't see custom relationships when creating custom field set
May 17, 2012, 11:38:49 am

Please do pay it forward and help other folks on the forums and/or IRC and/or contributing to an MIH: http://civicrm.org/participate/mih.

It makes it a lot easier if everyone helps as much as they can :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't see custom relationships when creating custom field set

This forum was archived on 2017-11-26.