Linked ticket with changeset: r6167
Action performed by Anonymous (I am too lazy to register) on Jul 10th 2006, 23:55
- Code: Select all
$sql = 'SELECT word_id, word_text
FROM ' . SEARCH_WORDMATCH_TABLE . '
GROUP BY word_id
HAVING COUNT(word_id) > ' . floor($config['num_posts'] * 0.6);
is incorrect, as the wordmatch table does not contain the column word_text. Based on the query, I believe that the table needed is SEARCH_WORDLIST_TABLE, and thus the patch to fix:
- Code: Select all
phpBB3/includes/search>diff -u fulltext_native.php.orig fulltext_native.php
--- fulltext_native.php.orig Fri Jul 07 23:30:38 2006
+++ fulltext_native.php Mon Jul 10 23:51:02 2006
@@ -957,7 +957,7 @@
if ($config['num_posts'] >= 100)
{
$sql = 'SELECT word_id, word_text
- FROM ' . SEARCH_WORDMATCH_TABLE . '
+ FROM ' . SEARCH_WORDLIST_TABLE . '
GROUP BY word_id
HAVING COUNT(word_id) > ' . floor($config['num_posts'] * 0.6);
$result = $db->sql_query($sql);
NeoThermic