From 8618f81d77f2058332878f7c5a37247d0f2bc70f Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Fri, 23 Nov 2001 21:09:37 +0000
Subject: Small error in SQL for Postgres searchmatch clean
git-svn-id: file:///svn/phpbb/trunk@1429 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/posting.php | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
(limited to 'phpBB/posting.php')
diff --git a/phpBB/posting.php b/phpBB/posting.php
index 81a653a1d9..db24368ac5 100644
--- a/phpBB/posting.php
+++ b/phpBB/posting.php
@@ -169,8 +169,8 @@ function remove_unmatched_words()
$sql = "DELETE FROM " . SEARCH_WORD_TABLE . "
WHERE word_id NOT IN (
SELECT word_id
- FROM " . SEARCH_MATCH_TABLE . ")
- GROUP BY word_id";
+ FROM " . SEARCH_MATCH_TABLE . "
+ GROUP BY word_id)";
$result = $db->sql_query($sql);
if( !$result )
{
--
cgit v1.2.1