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

More
6 years 6 months ago - 6 years 6 months 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:
Last edit: 6 years 6 months ago by ggppdk.

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

More
6 years 6 months 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...

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

More
6 years 6 months 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.

More
6 years 6 months 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...

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

More
6 years 6 months ago #69604 by labidis
Excellent, it works!
Thank you

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.283 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline