Advanced search hangs in DB

More
10 years 7 months ago - 10 years 7 months ago #46064 by gfisch
FLEXIcontent version 2.1.3 r1857

I have indexed my content for Advanced Search. I created a menu to the Advanced Search. I turned off the normal search plugin and turned on Advnaced Search plugin.

However, when I try it it hangs in the database. I have to go into phpmyadmin and kill the process. It has the Staus of "Sending Data" but never returns.

any help would be appreciated.

Here is the SQL statement:
SELECT i.id, i.title AS title, i.created, i.id AS fc_item_id,
GROUP_CONCAT(ai.search_index ORDER BY f.ordering ASC SEPARATOR ' ') AS text,
CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias)
ELSE i.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug,
CONCAT_WS( " / ", 'Content', c.title, i.title ) AS section, c.access as category_access,
ty.access as type_access, 1 AS has_access
FROM ztzg_content AS i
JOIN ztzg_flexicontent_advsearch_index as ai ON ai.item_id = i.id
AND ai.field_id IN (6,29,1,31,16,17)
JOIN ztzg_categories AS c ON c.id = i.catid
JOIN ztzg_flexicontent_items_ext AS ie ON ie.item_id = i.id
JOIN ztzg_flexicontent_types AS ty ON ie.type_id = ty.id
JOIN ztzg_flexicontent_fields as f ON f.id=ai.field_id
WHERE 1 AND i.state IN (1,-5) AND c.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() )
AND ty.access IN (0,1,1) AND c.access IN (0,1,1) AND i.access IN (0,1,1)
AND ie.type_id IN ('1','2')
AND i.id IN ( SELECT item_id FROM ztzg_flexicontent_advsearch_index AS ts
WHERE MATCH (ts.search_index) AGAINST ('+CRRF-Ruckus*' IN BOOLEAN MODE)
AND field_id IN (6,29,1,31,16,17))
GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50
Last edit: 10 years 7 months ago by gfisch.

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

More
10 years 7 months ago #46074 by ggppdk
Replied by ggppdk on topic Advanced search hangs in DB
Hello

this sounds like a bug

some answers cannot be answered

without viewing the web-site, please see a PM that have sent you

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.

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