Hi All, I have Newstream 2 on a local server for development. the search function throws the error below, the Joomlabamboo demo site also gives the same response.
Thanks for any help.

Can't find FULLTEXT index matching the column list SQL=SELECT 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 #__k2_items AS i INNER JOIN #__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 ('+garden*' 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 <= '2017-01-23 12:15:53' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-01-23 12:15:53' ) GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

Hi

Is Joomla and the database up to date?
Any issues with k2?

Cheers
Paul

Hi Paul, thanks for the quick response, Joomla is up to date, I'm not using the K2
I checked the database said it was up to date, seems strange that your demo site i showing the same error?
Thanks for the help

ah ok there is something wrong with the sample data

I'll check on this

Cheers
Paul

Are you able to create a ticket?

Cheers
Paul

Hi Paul I can move to a ticket but the site is off line and on a local server for now, I can put it on line some time towards the end of the week as it should be almost finished then and just need the search sorted. Do you want me to move it to a ticket now or when its on line?
Thanks

Rob will need to look at it - he is quite busy as we've had a flurry of tickets and updates

I'd probably leave it till the end of week

Cheers
Paul

Will do, thanks. Sorry I'm not clear do you need my site on line?
Thanks

Yes we need to look at the site via a ticket

Cheers
Paul

Hi Paul
Big thanks as always, I have now raised a ticket for the search function thanks

Thanks