Innacurate relationships showing in Craft 3.9.10

[stevehurst]

We're seeing some entries related to each other where there is no actual relation. The entries in question share some Title and Slug similarities with other entries that are related, but they have unique entry IDs, so should not be showing in the list.

I don't know how to detail this issue further. Please let me know what level of detail you would need to support.

[reganlawton]

@stevehurst I think I might need abit information.

• Some info would be what try of object is being Lin led wrong (entry, category, user, etc)?
• Is it linked in a matrix somewhere?
• etc

Basically some images might be useful too I really need to found out HOW to cause the "bug".

[stevehurst]

@reganlawton

Both objects are entries, one is a structure and the other a channel.

We're using matrix fields to relate these using a standard "Entries" field within the block.

In my screenshots below, you'll see two Case Studies entries, with the same naming structure, but one is for "Water Conservartion", the other for "Mining". Both show a relationship to the two Services entries "Sustainability" and "Autonomous Manufacturing", but in reality only the "Water Conservation" Case Study entry is related via a Matrix field. The "Mining" Case Study isn't related in any way. One of my Services entries ("Sustainability") doesn't even show the Case Study that is really related ("Water Conservation").

[reganlawton]

The whole plugin uses relatedTo which is a CraftCMS feature via the ORM. As seen in the below code.

/** @var Element $element */
$element = Craft::$app->elements->getElementById($elementId);
/** @var Element $elementType */
$elementType = Craft::$app->elements->getElementTypeById($elementId);

$query = MatrixBlock::find()->site($selectedSite);
$query->relatedTo = $element;
$query->anyStatus();
/** @var MatrixBlock[] $blocks */
$blocks = $query->all();

$matchingBlocks = [];
foreach ($blocks as $block) {
    $owner = $block->getOwner();
    if ($owner) {
        $matchingBlocks[$owner->id] = $owner;
    }
}

/** @var Query $query */
$query = Entry::find()->site($selectedSite);
$query->relatedTo = $element;
$query->anyStatus();
/** @var Element[] $entries */
$entries = $query->all();

The relationship has been picked up in the system. I'm wondering you need to rebuild the search and cache 🤔

[stevehurst]

I will try that. Which specific command line commands should I run?

[reganlawton]

I believe it might be in setting and be called "Rebuild Search Indexes" and "Clear Caches" -> "Data caches" I'm not 100% sure where the relatedTo gets its data from without looking under the hood but it could be a good start.

If not, I'm convinced it's linked somehow.

[stevehurst]

Updating the search indexes worked! Is there a more consistent maintenance, less-intensive wey to stay on top of this? Is it just junk data that collects over time?

…

On Jan 17, 2024, at 5:50 PM, Regan Lawton ***@***.***> wrote: I believe it might be in setting and be called "Rebuild Search Indexes" and "Clear Caches" -> "Data caches" I'm not 100% sure where the relatedTo gets its data from without looking under the hood but it could be a good start. If not, I'm convinced it's linked somehow. — Reply to this email directly, view it on GitHub <#26 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAE43IT33ZZESYA3Q5GPQDYPBPUVAVCNFSM6AAAAABB5IV6IWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOJXGUYDKNRYGA>. You are receiving this because you were mentioned.

[reganlawton]

I'm glad to hear! 🙌

You can do it via Craft CLI I believe and set up a cronjob.