I got "Error 500 - Internal Server Error" while creating index.raybeam wrote:Here's the solution, if anyone else encounters this..
If you make chages to the search function, you need to perform the follwing:
In the ACP, go to :
Maintenance - Database - Search Index - Delete Index, and then you Create Index.
Problem solved.
This worked for me as well. I set the common word threshold to 0% before recreating the index.raybeam wrote:Here's the solution, if anyone else encounters this..
If you make chages to the search function, you need to perform the follwing:
In the ACP, go to :
Maintenance - Database - Search Index - Delete Index, and then you Create Index.
Problem solved.
Code: Select all
SET @total = ( SELECT COUNT( * )
FROM phpbb_posts );
SELECT word_text, ROUND( 100 * word_count / @total , 2 ) AS Pct
FROM phpbb_search_wordlist
WHERE word_common =1
AND word_count < 0.05 * @total
ORDER BY word_text
LIMIT 0 , 600