Open portal/block/wordgraph.php
Find:
Code: Select all
// Get words and number of those words
$sql = 'SELECT l.word_text, COUNT(*) AS word_count
FROM ' . SEARCH_WORDLIST_TABLE . ' AS l, ' . SEARCH_WORDMATCH_TABLE . ' AS m
WHERE m.word_id = l.word_id
GROUP BY m.word_id, l.word_text
ORDER BY word_count DESC';
$result = $db->sql_query_limit($sql, $portal_config['portal_wordgraph_max_words']);
Replace with:
Code: Select all
// Get words and number of those words
$sql = 'SELECT word_text, word_count, word_id
FROM ' . SEARCH_WORDLIST_TABLE . '
GROUP BY word_id, word_text
ORDER BY word_count DESC';
$result = $db->sql_query_limit($sql, $portal_config['portal_wordgraph_max_words']);
By the way, it was actually showing the correct count, but the words with the high counts were not shown.