Loading...
 
Features / Usability

Features / Usability


serch box

posts: 20 Italy

hi, i have a problem whit mod-search_box.. when i search the response is:
Warning: mysql error: Can't find FULLTEXT index matching the column list in query:
SELECT COUNT(*) FROM tiki_blog_posts p LEFT JOIN tiki_blogs b ON b.blogId = p.blogId WHERE b.use_find = "y" AND MATCH(p.data) AGAINST ('s')
in /http/www/portale/tikiwiki-1.8/lib/tikidblib.php on line 125
Values:

$result is false
$result is empty

somebody have a suggestion for me???

posts: 2881 United Kingdom

See the same post from user phpsharma,

replace your search module with the search_new module

Damian


posts: 32 Greece

It' s too late of course for an advice but I think I have to post this for general use.

So, this error depends on the version you have installed. There is a full text index on table tiki_blog_posts by the name ft. If this index contains only data column you must drop it and build a new one full text too, containing data and title columns.

Your problem will be resovled.

Spyk


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting