Fehler beim Aufruf vom Dashboard nach Update auf 5.5

Sun, 11 Sep 2022 06:58:24 +0000

Message: Could not prepare statement 'SELECT thread.threadID AS objectID FROM wbb1_thread thread LEFT JOIN wbb1_thread_user_status thread_user_status ON thread_user_status.userID = 1 AND thread_user_status.threadID = thread.threadID LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON tracked_thread_visit.objectTypeID = 210 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_board_visit ON tracked_board_visit.objectTypeID = 209 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON tracked_thread_visit.objectTypeID = 210 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_board_visit ON tracked_board_visit.objectTypeID = 209 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1 WHERE (SELECT COUNT(*) FROM wbb1_thread_ignore WHERE userID = ? AND threadID = thread.threadID) = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.lastPostTime > ? AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) AND thread.time > ? AND (thread.time > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.time > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC LIMIT 5'

PHP version: 8.0.23

WoltLab Suite version: 5.5.4

Request URI: GET /dashboard/

Referrer: https://www.r53-forum.de/forum/

User Agent: Mozilla/5.0 (Linux; Android 12; SM-T976B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36

Peak Memory Usage: 15845280/536870912

======

Error Class: wcf\system\database\exception\DatabaseQueryException

Error Message: Could not prepare statement 'SELECT thread.threadID AS objectID FROM wbb1_thread thread LEFT JOIN wbb1_thread_user_status thread_user_status ON thread_user_status.userID = 1 AND thread_user_status.threadID = thread.threadID LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON tracked_thread_visit.objectTypeID = 210 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_board_visit ON tracked_board_visit.objectTypeID = 209 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON tracked_thread_visit.objectTypeID = 210 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 1 LEFT JOIN wcf1_tracked_visit tracked_board_visit ON tracked_board_visit.objectTypeID = 209 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 1 WHERE (SELECT COUNT(*) FROM wbb1_thread_ignore WHERE userID = ? AND threadID = thread.threadID) = 0 AND (thread_user_status.status <> ? OR thread_user_status.status IS NULL) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND thread.lastPostTime > ? AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) AND thread.time > ? AND (thread.time > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.time > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC,thread.threadID DESC LIMIT 5'

Error Code: 42000

File: /var/www/vhosts/r53-forum.de/httpdocs/lib/system/database/Database.class.php (333)

Extra Information: YToxOntpOjA7YToyOntpOjA7czoxNjoiVGVtcGxhdGUgQ29udGV4dCI7aToxO3M6NzY5OiIkdGhpcy0+Zm9yZWFjaFZhcnNbJzk2OGE3M2RiZmYzMzU1NGRkYzFlZmNhZDE5NzRjYzA3MDRhZGFkODYnXVsnaXRlbSddID0gJHRoaXMtPnZbJ2JveCddID8/IG51bGw7CmlmICgoaXNfY291bnRhYmxlKCRfZm9yZWFjaF85NjhhNzNkYmZmMzM1NTRkZGMxZWZjYWQxOTc0Y2MwNzA0YWRhZDg2KSAmJiBjb3VudCgkX2ZvcmVhY2hfOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NikgPiAwKSB8fCAoIWlzX2NvdW50YWJsZSgkX2ZvcmVhY2hfOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NikgJiYgJF9mb3JlYWNoXzk2OGE3M2RiZmYzMzU1NGRkYzFlZmNhZDE5NzRjYzA3MDRhZGFkODYpKSB7CmZvcmVhY2ggKCRfZm9yZWFjaF85NjhhNzNkYmZmMzM1NTRkZGMxZWZjYWQxOTc0Y2MwNzA0YWRhZDg2IGFzICR0aGlzLT52Wydib3gnXSkgewo/Pgo9PT09PiAJCQkJCQkJCQk8Pz0kdGhpcy0+dlsnYm94J10tPnJlbmRlcigpOz8+CgkJCQkJCQkJPD9waHAgfQp1bnNldCgkdGhpcy0+dlsnYm94J10pOyR0aGlzLT52Wydib3gnXSA9ICR0aGlzLT5mb3JlYWNoVmFyc1snOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NiddWydpdGVtJ107CnVuc2V0KCR0aGlzLT5mb3JlYWNoVmFyc1snOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NiddKTsKIH0gPz4KCQkJCQkJCTw/cGhwCiR0aGlzLT52Wyd0cGwnXVsnY2FwdHVyZSddWydkZWZhdWx0J10gPSBvYl9nZXRfY2xlYW4oKTsKIjt9fQ==

Stack Trace: [{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":170,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/CacheBuilderThreadList.class.php","line":115,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/ViewableThreadList.class.php","line":146,"function":"readObjectIDs","class":"wbb\\data\\thread\\CacheBuilderThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/CacheBuilderThreadList.class.php","line":143,"function":"readObjects","class":"wbb\\data\\thread\\ViewableThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":372,"function":"readObjects","class":"wbb\\data\\thread\\CacheBuilderThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/system\/box\/ThreadListBoxController.class.php","line":155,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":338,"function":"readObjects","class":"wbb\\system\\box\\ThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":304,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":335,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":316,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/templates\/compiled\/68_wcf_1_cms.php","line":3134,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":350,"args":["\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/templates\/compiled\/68_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":390,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

======

Error Class: PDOException

Error Message: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'tracked_thread_visit'

Error Code: 42000

File: /var/www/vhosts/r53-forum.de/httpdocs/lib/system/database/Database.class.php (328)

Extra Information: YToxOntpOjA7YToyOntpOjA7czoxNjoiVGVtcGxhdGUgQ29udGV4dCI7aToxO3M6NzY5OiIkdGhpcy0+Zm9yZWFjaFZhcnNbJzk2OGE3M2RiZmYzMzU1NGRkYzFlZmNhZDE5NzRjYzA3MDRhZGFkODYnXVsnaXRlbSddID0gJHRoaXMtPnZbJ2JveCddID8/IG51bGw7CmlmICgoaXNfY291bnRhYmxlKCRfZm9yZWFjaF85NjhhNzNkYmZmMzM1NTRkZGMxZWZjYWQxOTc0Y2MwNzA0YWRhZDg2KSAmJiBjb3VudCgkX2ZvcmVhY2hfOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NikgPiAwKSB8fCAoIWlzX2NvdW50YWJsZSgkX2ZvcmVhY2hfOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NikgJiYgJF9mb3JlYWNoXzk2OGE3M2RiZmYzMzU1NGRkYzFlZmNhZDE5NzRjYzA3MDRhZGFkODYpKSB7CmZvcmVhY2ggKCRfZm9yZWFjaF85NjhhNzNkYmZmMzM1NTRkZGMxZWZjYWQxOTc0Y2MwNzA0YWRhZDg2IGFzICR0aGlzLT52Wydib3gnXSkgewo/Pgo9PT09PiAJCQkJCQkJCQk8Pz0kdGhpcy0+dlsnYm94J10tPnJlbmRlcigpOz8+CgkJCQkJCQkJPD9waHAgfQp1bnNldCgkdGhpcy0+dlsnYm94J10pOyR0aGlzLT52Wydib3gnXSA9ICR0aGlzLT5mb3JlYWNoVmFyc1snOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NiddWydpdGVtJ107CnVuc2V0KCR0aGlzLT5mb3JlYWNoVmFyc1snOTY4YTczZGJmZjMzNTU0ZGRjMWVmY2FkMTk3NGNjMDcwNGFkYWQ4NiddKTsKIH0gPz4KCQkJCQkJCTw/cGhwCiR0aGlzLT52Wyd0cGwnXVsnY2FwdHVyZSddWydkZWZhdWx0J10gPSBvYl9nZXRfY2xlYW4oKTsKIjt9fQ==

Stack Trace: [{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":170,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/CacheBuilderThreadList.class.php","line":115,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/ViewableThreadList.class.php","line":146,"function":"readObjectIDs","class":"wbb\\data\\thread\\CacheBuilderThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/data\/thread\/CacheBuilderThreadList.class.php","line":143,"function":"readObjects","class":"wbb\\data\\thread\\ViewableThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":372,"function":"readObjects","class":"wbb\\data\\thread\\CacheBuilderThreadList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/forum\/lib\/system\/box\/ThreadListBoxController.class.php","line":155,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":338,"function":"readObjects","class":"wbb\\system\\box\\ThreadListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":304,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":335,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/data\/box\/Box.class.php","line":316,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/templates\/compiled\/68_wcf_1_cms.php","line":3134,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":350,"args":["\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/templates\/compiled\/68_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":390,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/r53-forum.de\/httpdocs\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Server

Betriebssystem: Linux

Webserver: nginx/1.20.2

MySQL-Version: 10.3.34-MariaDB-0ubuntu0.20.04.1

Aktueller UNIX Load: 0.14, 0.10, 0.09

innodb_flush_log_at_trx_commit: 1

PHP

PHP-Version: 8.0.23

memory_limit: 512M

post_max_size: 64M

upload_max_filesize: 64M

Unterstützung von SSL-Verbindungen: vorhanden