Open menu

Does the search and advanced search works?

Rooney
Offline
Moderator

12 years 3 months ago #27808 by Rooney

Replied by Rooney on topic Does the search and advanced search works?

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.

ggppdk
Offline
Administrator

12 years 3 months ago #27809 by ggppdk

Replied by ggppdk on topic Does the search and advanced search works?

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.

Rooney
Offline
Moderator

12 years 3 months ago #27811 by Rooney

Replied by Rooney on topic Does the search and advanced search works?

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.

davidote
Offline
Premium Member

10 years 9 months ago #44573 by davidote

Replied by davidote on topic Does the search and advanced search works?

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.

ggppdk
Offline
Administrator

10 years 9 months ago #44583 by ggppdk

Replied by ggppdk on topic Does the search and advanced search works?

Hello

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

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

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

davidote
Offline
Premium Member

10 years 9 months ago #44594 by davidote

Replied by davidote on topic Does the search and advanced search works?

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.