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 ?

I have a FLEXIcontent menu item category with the relation field as a filter and everything shows perfectly. On the french side, only the french items and on the english side, only the english items.

What I ment about "shows item in both languages" is if I'm on the french side, the reverse field list the french AND the english items. If I'm on the english side, it shows no items... I don't know if it matters but french is the default language.

Thanks.

Hello

I have a FLEXIcontent menu item category with the relation field as a filter and everything shows perfectly. On the french side, only the french items and on the english side, only the english items.

What I ment about "shows item in both languages" is if I'm on the french side, the reverse field list the french AND the english items. If I'm on the english side, it shows no items... I don't know if it matters but french is the default language.

Thanks.

can you send me a PM super admin access to the website ?
and also give me steps (page that contain the links, and where to click, etc) to reproduce the above
also an example of related item B that is related to A that is not shown in the above pages ?

Hello

1. please note that for relation field
- there are parameters for filtering items during selection

2. and then for both fields, relation and relation reverse fields
- there are parameters for filtering the alreading related items

these (for both field types) are inside TAB:
Viewing TAB / Related items TAB / Filter items TAB

3. also there is no "language filter" during viewing (this exists only during editing / selecting related items)
all items should be shown regardless of language

1 and 2: I know and I played with them quite a bit before posting in here. There's so much possibilities that I might have overlooked something but I have triple checked everything I could think of.

3. I do not understand. In the related field -> Editing -> Selectable items, there's a setting for Same Language Only that is set to "yes". Is that what you are reffering to?

I'll PM you the info about the site.

Thanks.