Re-build Search Index [message #22788] |
Wed, 16 February 2005 09:09 |
juboy309
Messages: 17 Registered: May 2003
Karma:
|
Junior Member |
|
|
Hi, we have a FUD forum at www.avtalk.co.uk with 121,531 messages.
The search function hasn't worked properly for about a year but people are now finding it really frustrating.
Using the Re-build link in the Admin global settings area doesn't work, it always times out.
Currently the search function doesn't work at all, giving the following error message:
Quote: |
(index.php:1160 ) 1016: Can't open file: 'av_index.MYD'. (errno: 144)
Query: INSERT IGNORE INTO av_search_cache (srch_query, query_type, expiry, msg_id, n_match) SELECT '67676235d6c53df2d8e7a114b9e61749', 0, 1108544847, msg_id, count(*) as word_count FROM av_search s INNER JOIN av_index i ON i.word_id=s.id WHERE word IN( 'juboy') GROUP BY msg_id ORDER BY word_count DESC LIMIT 500
Server Version: 3.23.58
[Referring Page] http://www.avtalk.co.uk/forum/index.php?t=search&rid=20&SQ=11085447 65
|
Could anyone suggest how we might get the search re-build and search function to work again please? Thanks for the help.
|
|
|