Does the search and advanced search works?

More
11 years 8 months ago #27808 by Rooney
Yes, but then I get nor search results at all!

Rooney

Joomla! 3.9.24 and FC 3.3.9

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

More
11 years 8 months ago #27809 by ggppdk
You mean that the FLEXIcontent standard search plugin does not return results?

Have you sent me a PM with access to this site before, please resend?

Please give me your search scenario that shows the problem.

e.g. i search for words "word1 word2" and the items with id 457 and 946 should appear


-- 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
11 years 8 months ago #27811 by Rooney
Ok. If I am enabling only the FC standard search, I am getting results. Don't know what I did before.

Rooney

Joomla! 3.9.24 and FC 3.3.9

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

More
10 years 3 months ago #44573 by davidote
I have installed FLEXIcontent version 2.1.2 r1806 beta in Joomla 3.2.1. In the search for items of different categories module or search in a category module, when I search all categories (without going into any particular category) gives the following error:
Code:
Error: 1054 - Unknown column 'fi.item_id' in 'on clause' SQL=SELECT DATE_FORMAT(i.created, "%Y") AS value, DATE_FORMAT(i.created, "%Y") AS text, COUNT(DISTINCT i.id) as found FROM fcsjb_content AS i LEFT JOIN fcsjb_flexicontent_items_ext AS ie ON fi.item_id = ie.item_id WHERE 1 AND i.id IN(1,2,3,4) AND MATCH (ie.search_index) AGAINST ('+comisaria' IN BOOLEAN MODE) AND i.created IS NOT NULL GROUP BY DATE_FORMAT(i.created, "%Y") ORDER BY DATE_FORMAT(i.created, "%Y")

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

More
10 years 3 months ago #44583 by ggppdk
Hello

i believe this is reported and fixed in v2.1.3 r1837 (beta), please upgrade to :

docs.google.com/uc?export=downl ... VNJTHQ5V00


-- 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
10 years 3 months ago #44594 by davidote
Hello

I've upgraded to that version, but problem is still here.
Code:
Error: 1054 - Unknown column 'fi.item_id' in 'on clause' SQL=SELECT DATE_FORMAT(i.created, "%Y") AS value, DATE_FORMAT(i.created, "%Y") AS text, COUNT(DISTINCT i.id) as found FROM fcsjb_content AS i LEFT JOIN fcsjb_flexicontent_items_ext AS ie ON fi.item_id = ie.item_id WHERE 1 AND i.id IN(1,2,3,4) AND MATCH (ie.search_index) AGAINST ('+comisaria' IN BOOLEAN MODE) AND i.created IS NOT NULL GROUP BY DATE_FORMAT(i.created, "%Y") ORDER BY DATE_FORMAT(i.created, "%Y")

I've added all Flexicontent categories to option menú advanced search categories of Flexicontent.

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.569 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