Hi,

I have a new website with K2 and 1000 imported item from joomla content

Search engine is totally broken. I have this error :

Error: 1214 - The used table type doesn't support FULLTEXT indexes SQL=SELECT i.id, i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, i.created, CONCAT(i.introtext, i.fulltext) 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 catslug FROM xxx_k2_items AS i INNER JOIN xxx_k2_categories AS c ON c.id=i.catid AND c.access IN(1,1,5) WHERE (MATCH(i.title, i.introtext, i.`fulltext`,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('+android*' IN BOOLEAN MODE) ) AND i.trash = 0 AND i.published = 1 AND i.access IN(1,1,5) AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-09-22 15:18:27' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-09-22 15:18:27' ) GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

website: www.plugngeek.net/newpng/

K2 Version: 2.6.8
Joomla version : 3.3.x

Database is not modified.

Hi. This query is not part of K2. Check for any K2 related extensions installed on your system. If you enable the system debugger you will see which file is using this query.

Thank you for your help. I changed k2 search plugin for another. It works perfectly :) thank you.

You are welcome.