From 140e850707c4d623b484301fbafe881951c2d944 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Thu, 29 Dec 2016 13:31:35 +0100 Subject: [PATCH] Fixed HAVING using an alias --- .../install/files/acp/update_com.woltlab.wcf_3.0.0_rc_3.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/install/files/acp/update_com.woltlab.wcf_3.0.0_rc_3.php b/wcfsetup/install/files/acp/update_com.woltlab.wcf_3.0.0_rc_3.php index d3445ac0d8..472b6e597f 100644 --- a/wcfsetup/install/files/acp/update_com.woltlab.wcf_3.0.0_rc_3.php +++ b/wcfsetup/install/files/acp/update_com.woltlab.wcf_3.0.0_rc_3.php @@ -40,7 +40,7 @@ $sql = "SELECT COUNT(*) AS count, pageID FROM wcf".WCF_N."_page_content WHERE languageID IS NULL GROUP BY pageID - HAVING count > 1"; + HAVING COUNT(*) > 1"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(); while ($row = $statement->fetchArray()) { @@ -59,7 +59,7 @@ $sql = "SELECT COUNT(*) AS count, boxID FROM wcf".WCF_N."_box_content WHERE languageID IS NULL GROUP BY boxID - HAVING count > 1"; + HAVING COUNT(*) > 1"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(); while ($row = $statement->fetchArray()) { -- 2.20.1