Support Forum

Please note that this forum is only available to you in read only mode. In order to contribute to this conversation you will need to renew your subscription.

Search function problem

zentoolsIf you use Zentools please post a review at the Joomla! Extensions Directory.

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
  • Harlequin's Avatar
  • Harlequin
  • LIfetime Developer - Big Bamboo
  • 206 posts
  • 2 Thanks
  • Karma: 0
The administrator has disabled public write access.
Hi

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

Cheers
Paul
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.
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
  • Harlequin's Avatar
  • Harlequin
  • LIfetime Developer - Big Bamboo
  • 206 posts
  • 2 Thanks
  • Karma: 0
The administrator has disabled public write access.
ah ok there is something wrong with the sample data

I'll check on this

Cheers
Paul
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.
Are you able to create a ticket?

Cheers
Paul
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.
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
  • Harlequin's Avatar
  • Harlequin
  • LIfetime Developer - Big Bamboo
  • 206 posts
  • 2 Thanks
  • Karma: 0
Last Edit: 2 years 6 months ago by Harlequin.
The administrator has disabled public write access.
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
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.
Will do, thanks. Sorry I'm not clear do you need my site on line?
Thanks
  • Harlequin's Avatar
  • Harlequin
  • LIfetime Developer - Big Bamboo
  • 206 posts
  • 2 Thanks
  • Karma: 0
The administrator has disabled public write access.
Yes we need to look at the site via a ticket

Cheers
Paul
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.
Hi Paul
Big thanks as always, I have now raised a ticket for the search function thanks
  • Harlequin's Avatar
  • Harlequin
  • LIfetime Developer - Big Bamboo
  • 206 posts
  • 2 Thanks
  • Karma: 0
The administrator has disabled public write access.
Thanks
  • manh's Avatar
  • manh
  • Moderator
  • 45248 posts
  • 2106 Thanks
  • Karma: 603
The administrator has disabled public write access.

zentoolsIf you use Zentools please post a review at the Joomla! Extensions Directory.

Happy Campers