[Fixed in v3.2.1.4] getFilterValues() Filter for : Document type error

6 months 4 weeks ago - 6 months 4 weeks ago #69599 by labidis
Hi,
I'm using the filter module for articles display and I got an error using document type filter.
When I select another filter, the document type filters are greyed and the following error pops up: (cf attached screenshot)

Warning
getFilterValues() Filter for : Document type cannot be displayed, SQL QUERY ERROR:
Unknown column 'i.id' in 'IN/ALL/ANY subquery'
SELECT ict.id AS value, ict.name AS text, COUNT(DISTINCT i.item_id ) as found
FROM #__flexicontent_items_ext AS i
JOIN #__flexicontent_types AS ict ON i.type_id = ict.id
WHERE 1
AND i.item_id IN(SELECT id FROM fc_view_iids_0)
AND i.id IN (SELECT id FROM fc_filter_iids_19) AND i.id IN (SELECT id FROM fc_filter_iids_17)

GROUP BY ict.id

ORDER by text



I'm using joomla 3.8.0 and FC 3.2.1.2
Any clue?
Thanks
Attachments:

Please Log in or Create an account to join the conversation.

6 months 4 weeks ago #69600 by ggppdk
Hello

we have fixed this here:
v3.2.1.3

github.com/FLEXIcontent/flexicontent-cck/releases


-- FLEXIcontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

6 months 4 weeks ago #69601 by labidis
Thanks for the reply.
My mistake, I was already using v3.2.1.3 and teh error was there. I installed again the v3.2.1.3 package and the error is still persistent.

Please Log in or Create an account to join the conversation.

6 months 4 weeks ago #69602 by ggppdk
Hello

i have just made new release ,
please try v3.2.1.4,

github.com/FLEXIcontent/flexicontent-cck/releases


-- FLEXIcontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

6 months 4 weeks ago #69604 by labidis
Excellent, it works!
Thank you

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.