Category Component Search Error | Page Not Found | SQL error

More
10 years 9 months ago #44633 by uwwandrew
I have both text search enabled with fields selected (description, title) and field search (document type-checkbox). Enabled individually they work fine but together they throw a page not found and msg:

If difficulties persist, please contact the System Administrator of this site and report the error below.

0 SQL=SELECT ict.id AS value, ict.name AS text, COUNT(DISTINCT i.id) as found FROM databse8_content AS i LEFT JOIN database_flexicontent_items_ext AS ie ON fi.item_id = ie.item_id JOIN database_flexicontent_items_ext AS iext ON iext.item_id = i.id JOIN database_flexicontent_types AS ict ON iext.type_id = ict.id WHERE 1 AND i.id IN(185) AND MATCH (ie.search_index) AGAINST ('+test' IN BOOLEAN MODE) AND ie.search_index LIKE '%test%' GROUP BY ict.id ORDER BY text ASC

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

More
10 years 9 months ago #44634 by ggppdk
Hello

the actual error message is missing from your message,

but looking at the query it look likes the bug fixed in r1838 (reported in another thread), so next beta build should has a fix will be available today or tomorrow

Regards


-- 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 9 months ago #44638 by uwwandrew
I've been looking for that other thread and cannot find it. Should I worry about the next beta build overwriting the com_flexicontent_v2.1.2_r1806_J25_J32_beta.zip you gave me to make the universal module category list work like a menu? That has been great. Thanks a bunch gg.

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

More
10 years 9 months ago #44648 by ggppdk
Hello

custom templates are not overwritten,

if you have changed a built-in template (that comes with FLEXIcontent package) then it will be overwritten

-- e.g. if you have modified 'blog' template,
then
1. duplicate (in template ) the 'blog' template to make a new template called blog1
2. edit your categories and set them to use 'blog1'


-- 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.

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