| Re-build Search Index [message #22788] |
Wed, 16 February 2005 09:09  |
juboy309
Messages: 17
Registered: May 2003
Karma: 0
|
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.
|
|
|
|
| Re: Re-build Search Index [message #22795 is a reply to message #22788] |
Wed, 16 February 2005 15:00  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
1st repair the search index table by running "REPAIR av_index" SQL command.
Given the size of your forum it would be better to run the search re-indexer via command line rather then via the browser. To do this, you need to unlock the forum, then go to forum's adm/ directory, modify the indexdb.php based on instructions listed in the file and run it.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]