aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-03-03 19:28:44 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-03-03 19:28:44 +0000
commit4d5fde9a782310afbcf5841e9bcc23da88ef4065 (patch)
tree88c0a385917f8966a9629467b3bb268aacfa6c8e /phpBB
parentddbc8dbf1fff601d966e9ab1022fc31875528b87 (diff)
downloadforums-4d5fde9a782310afbcf5841e9bcc23da88ef4065.tar
forums-4d5fde9a782310afbcf5841e9bcc23da88ef4065.tar.gz
forums-4d5fde9a782310afbcf5841e9bcc23da88ef4065.tar.bz2
forums-4d5fde9a782310afbcf5841e9bcc23da88ef4065.tar.xz
forums-4d5fde9a782310afbcf5841e9bcc23da88ef4065.zip
Change to count method in word_common ... problem seemed to exist on older PHP versions for some reason
git-svn-id: file:///svn/phpbb/trunk@2257 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/includes/search.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/includes/search.php b/phpBB/includes/search.php
index 4898e747f5..c8d40a8d58 100644
--- a/phpBB/includes/search.php
+++ b/phpBB/includes/search.php
@@ -278,7 +278,7 @@ function remove_common($mode, $fraction, $word_id_list = array())
{
global $db;
- $sql = ( $mode == "global" ) ? "SELECT COUNT(DISTINCT post_id) AS total_posts FROM " . SEARCH_MATCH_TABLE : "SELECT SUM(forum_posts) AS total_posts FROM " . FORUMS_TABLE;
+ $sql = ( $mode == "global" ) ? "SELECT COUNT(post_id) AS total_posts FROM " . SEARCH_MATCH_TABLE . " GROUP BY post_id" : "SELECT SUM(forum_posts) AS total_posts FROM " . FORUMS_TABLE;
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't obtain post count", "", __LINE__, __FILE__, $sql);