From 17bf86a5fb9069491efd3f06e03ce3113dcfd425 Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Mon, 6 Jun 2016 22:11:39 +0200 Subject: [PATCH] Fixed sql issue in related articles query --- wcfsetup/install/files/lib/page/ArticlePage.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/page/ArticlePage.class.php b/wcfsetup/install/files/lib/page/ArticlePage.class.php index 649bd0d6ee..c750e0194c 100644 --- a/wcfsetup/install/files/lib/page/ArticlePage.class.php +++ b/wcfsetup/install/files/lib/page/ArticlePage.class.php @@ -185,7 +185,7 @@ class ArticlePage extends AbstractPage { FROM wcf" . WCF_N . "_tag_to_object " . $conditionBuilder . " GROUP BY objectID - HAVING count > " . (round(count($this->tags) * (ARTICLE_RELATED_ARTICLES_MATCH_THRESHOLD / 100))) . " + HAVING COUNT(*) > " . (round(count($this->tags) * (ARTICLE_RELATED_ARTICLES_MATCH_THRESHOLD / 100))) . " ORDER BY count DESC"; $statement = WCF::getDB()->prepareStatement($sql, ARTICLE_RELATED_ARTICLES); $statement->execute($conditionBuilder->getParameters()); -- 2.20.1