Skip to main content

Relationship addition error ‘The subject must not be younger than the relation’

In this article, we explain the error that occurs when adding a relationship where the subject is younger than the related person.

Y
Written by Yusef Abulaynain

When you’re creating a relationship between two people, Mosaic enforces age restrictions in place if it's a parent-child relationship. This is based on the data in the relationship_type_group column. If the information is not right, you'll see the error message 'The subject must not be younger than the relation'.
​
If this error message pops up, here's what you do, depending on whether we're hosting your database or you are:

Hosted

Please raise a case and reference the title of this article providing the name of the relationship that causes the error.

Self-Hosted

You’ll need to find the relationship type that isn’t working within the table mo_relationship_types. Check the information within the column called relationship_type_group.


For example, if the relationship is mother:Child then the relationship_type_group should be Parent:Child. If this is incorrect, then you’ll have to correct the data.
​
To fix the relationship type issue, here’s what you’ve got to do:

  1. Identify the Incorrect Relationship Type: You’ll need to query the mo_relationship_types table to find the relationship type that’s not working correctly.

  2. Check the relationship_type_group Column: Have a look at the info in the relationship_type_group column for the identified relationship type.

  3. Correct the data if necessary: Make sure the relationship_type_group column contains the correct value. For example, if the relationship is mother-child, the relationship_type_group should be Parent:Child.


Example of code used for the change:

UPDATE mo_relationship_types
SET relationship_type_group = 'CHILD:PARENT'
WHERE relationship_type_id IN (xxxxx ) –Enter the IDs that need updating
Did this answer your question?