Reverse relation field language filtering problem after update

Hi,

I have a 3 year old website that I keep upgrading. It used to work fine but we noticed that the reverse relation field shows new items in both languages and I'm not sure since witch upgrade. Also some items do not show.

It's now running 3.2.1.5 on Joomla 3.8.1

Can someone help?

Thanks.

Hello

do you think there is a bug ?

Also some items do not show.

Are the items published and allowed access level ?
is the category and item type of the items published and of allowed access level ?

Can someone help?

of course if this is a bug , we will fix

It might be a bug, hard to tell. Others would have got the same problem by now I guess. Items that do not show in the reverse relation field show in category view so I guess access levels are good.

Hello

The reverse relation field inside the viewing TAB,
- has several filtering options that can exclude items that have been related !

so if you have some filters active there, then it is expected to see less files


So first check the above,
then to print the query that decide the items for relation field and for relation reverse field:

inside file
components/com_flexicontent/classes/flexicontent_fields.php
at line 5142 ( for v3.2.1.5)

//echo "<pre>".$query."</pre>";
return $query;

uncoment the echo statement by (temporarily) removing //

I have double checked the filtering options and everything is configured as it should. I'm on a french page with the reverse field showing french and english items and if I switch to english, no items shows up. I have noticed that this only happens with newly created items, old ones show up fine. So I guess it's the new items after I did the upgrade.

Following your instructions, here's the output:

SELECT i.*, ext.*, GROUP_CONCAT(c.id SEPARATOR ",") AS catidlist, GROUP_CONCAT(c.alias SEPARATOR ",") AS cataliaslist FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ext ON i.id=ext.item_id JOIN #__flexicontent_fields_item_relations AS fi_rel ON i.id=fi_rel.item_id AND fi_rel.field_id=33 AND CAST(fi_rel.value AS SIGNED)=253 LEFT JOIN #__flexicontent_fields_item_relations AS f ON f.item_id = i.id AND f.field_id=34 LEFT JOIN #__flexicontent_cats_item_relations AS rel ON i.id=rel.itemid LEFT JOIN #__categories AS c ON c.id=rel.catid WHERE 1 AND ext.type_id IN (3) AND i.catid IN (152) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) AND i.state IN (1,-5,2) GROUP BY i.id ORDER BY f.value DESC, i.title ASC
SELECT i.*, ext.*, GROUP_CONCAT(c.id SEPARATOR ",") AS catidlist, GROUP_CONCAT(c.alias SEPARATOR ",") AS cataliaslist FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ext ON i.id=ext.item_id JOIN #__flexicontent_fields_item_relations AS fi_rel ON i.id=fi_rel.item_id AND fi_rel.field_id=33 AND CAST(fi_rel.value AS SIGNED)=253 LEFT JOIN #__flexicontent_fields_item_relations AS f ON f.item_id = i.id AND f.field_id=34 LEFT JOIN #__flexicontent_cats_item_relations AS rel ON i.id=rel.itemid LEFT JOIN #__categories AS c ON c.id=rel.catid WHERE 1 AND ext.type_id IN (3) AND i.catid IN (155,279,280) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) AND i.state IN (1,-5,2) GROUP BY i.id ORDER BY f.value DESC, i.title ASC

Thanks for your help.

Hello

do the related items show in item form as related ?
i speak of relation field (not of reverse relation field)

Also about

shows new items in both languages

if they were added as related , why they should not be shown ?