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