Rebuild Search

While running this mod, it worked for a while but then gave me this error...

any ideas?

Could not obtain common word list

DEBUG MODE

SQL Error : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

SELECT word_id FROM phpbb_search_wordmatch GROUP BY word_id HAVING COUNT(word_id) > 16165

Line : 309
File : functions_search.php

This is a bit out of my area of expertise, but it seems that the script is trying to look at too much info in the database at once. The server has limits on how much of the database can be examined, to prevent scripts from crashing the server.

Essentially, it means that your forum may be too big for rebuilding the search tables to work on your server.

i believe ur right...someone else gave me that answer yesterday...guess i'll have to look for a solution then.

thanks thoul...