<<<<<<<<3fc45b6eccd19861cebae4177bfcb5e08f74f521<<<< Tue, 22 Apr 2025 14:49:49 +0000 Message: Could not prepare statement 'SELECT thread.threadID AS objectID FROM wbb1_thread thread LEFT JOIN (SELECT thread_rate.threadID as threadID, COUNT(*) as rateCounter, IFNULL(ROUND(ROUND(SUM(thread_rate.rate) / COUNT(*) * 2, 2) / 2, 1), 0.00) AS rateValue FROM wbb1_thread_rate thread_rate WHERE thread_rate.time >= '1743458400' AND thread_rate.time <= '1746050399' GROUP BY threadID) as thread_rate ON(thread.threadID = thread_rate.threadID) WHERE threadID NOT IN (SELECT threadID FROM wbb1_thread_user_status WHERE userID = 1 AND status = ?) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND rateCounter > ? ORDER BY thread_rate.rateValue DESC, thread_rate.rateCounter DESC LIMIT 10' PHP version: 8.1.32 WoltLab Suite version: 6.1.8 Request URI: GET /forum/ Referrer: https://kochboard.ddnss.de/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Peak Memory Usage: 7317976/1073741824 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT thread.threadID AS objectID FROM wbb1_thread thread LEFT JOIN (SELECT thread_rate.threadID as threadID, COUNT(*) as rateCounter, IFNULL(ROUND(ROUND(SUM(thread_rate.rate) / COUNT(*) * 2, 2) / 2, 1), 0.00) AS rateValue FROM wbb1_thread_rate thread_rate WHERE thread_rate.time >= '1743458400' AND thread_rate.time <= '1746050399' GROUP BY threadID) as thread_rate ON(thread.threadID = thread_rate.threadID) WHERE threadID NOT IN (SELECT threadID FROM wbb1_thread_user_status WHERE userID = 1 AND status = ?) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND rateCounter > ? ORDER BY thread_rate.rateValue DESC, thread_rate.rateCounter DESC LIMIT 10' Error Code: 23000 File: /var/www/kochboard.ddnss.de/lib/system/database/Database.class.php (337) Extra Information: - Stack Trace: [{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/DatabaseObjectList.class.php","line":169,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/lib\/data\/thread\/ViewableThreadList.class.php","line":147,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":371,"function":"readObjects","class":"wbb\\data\\thread\\ViewableThreadList","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/lib\/system\/box\/BestRatedThreadListBoxController.class.php","line":77,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":303,"function":"loadContent","class":"wbb\\system\\box\\BestRatedThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/box\/Box.class.php","line":332,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/box\/Box.class.php","line":313,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/templates\/compiled\/12_wbb_1_boardList.php","line":1746,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/template\/TemplateEngine.class.php","line":457,"args":["\/var\/www\/kochboard.ddnss.de\/templates\/compiled\/12_wbb_1_boardList.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/page\/AbstractPage.class.php","line":372,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/page\/AbstractPage.class.php","line":124,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/request\/Request.class.php","line":50,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/request\/RequestHandler.class.php","line":161,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}] ====== Error Class: PDOException Error Message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'threadID' in IN/ALL/ANY is ambiguous Error Code: 23000 File: /var/www/kochboard.ddnss.de/lib/system/database/Database.class.php (332) Extra Information: - Stack Trace: [{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/database\/Database.class.php","line":332,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/DatabaseObjectList.class.php","line":169,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/lib\/data\/thread\/ViewableThreadList.class.php","line":147,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":371,"function":"readObjects","class":"wbb\\data\\thread\\ViewableThreadList","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/lib\/system\/box\/BestRatedThreadListBoxController.class.php","line":77,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":303,"function":"loadContent","class":"wbb\\system\\box\\BestRatedThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/box\/Box.class.php","line":332,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/data\/box\/Box.class.php","line":313,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/templates\/compiled\/12_wbb_1_boardList.php","line":1746,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/template\/TemplateEngine.class.php","line":457,"args":["\/var\/www\/kochboard.ddnss.de\/templates\/compiled\/12_wbb_1_boardList.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/page\/AbstractPage.class.php","line":372,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/page\/AbstractPage.class.php","line":124,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/request\/Request.class.php","line":50,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/lib\/system\/request\/RequestHandler.class.php","line":161,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":[]},{"file":"\/var\/www\/kochboard.ddnss.de\/forum\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}] <<<<