Fehler beim Aufruf vom Dashboard nach Update auf 5.5

  • Affected Version
    WoltLab Suite 5.5
    Affected App
    WoltLab Suite Forum

    Servus!

    Habe mir mal die Zeit genommen auf die 5.5 upzudaten.

    Hat soweit alles geklappt und alles läuft soweit ohne Probleme.

    Aber! Wenn ich das Dashboard aufrufe bekomme ich folgende Fehlermeldung:

    Achtung die Fehlermeldung ist laaaang!

    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":[]}]

    Hab mal vorerst das Dashboar deaktiviert, was aber nicht die Lösung ist.

    Serverdaten

    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

    Falls es wichtig sein sollte, habe auch "Elasticsearch" inst.


    Fals ich was vergessen haben sollte gebt beschei und ich reche es gerne nach.

    THX


    Sascha

  • Das scheint mir von einem Plugin verursacht zu werden, das irgendwas mit Tracking macht. Eventuell dieses hier?
    Tracker

    Eher weniger, das kommt wohl eher von WL selbst. ;)

    Dürfte evtl. mit der Letzten Aktivitäten Box oder einer anderen Box auf dem Dashboard zusammen hängen.

    Tante Edit

    Evtl ein veraltetes oder selbst angepasstes Template....

    Greetz

    Dark

    Mit dem Ende naht der Anfang mit etwas Neuen, um dann wieder zu sagen „Nach dem Update ist vor dem Update“. :S

    Edited once, last by Darklord (September 11, 2022 at 10:40 AM).

  • Hallo,

    wir konnten das Problem identifizieren. Der Fehler tritt auf, wenn bei einer Themen-Box sowohl die Option „Nur Themen, dessen letzter Beitrag noch nicht gelesen wurde“ als auch „Nur Themen, dessen erster Beitrag noch nicht gelesen wurde” aktiviert ist.

    Dies sollte zwar keinen Fehler erzeugen, sinnvoll ist diese Kombination aber dennoch nicht. Es empfiehlt sich die Box so umzustellen, dass nur noch „Nur Themen, dessen letzter Beitrag noch nicht gelesen wurde“ aktiviert ist. Es ist bedingt durch die technische Implementierung nicht möglich, den letzten Beitrag „gelesen“ zu haben, nicht aber den ersten.

  • Servus!

    Hatte jetzt die letzten Tage wenig bis keine Zeit eine Fehlersuche weiterzuführen

    und bin mal sowas von Happy, dass ich die Fehlerursache bestätigen kann.

    Dashboard lüppt wieder.

    Wenn ich so überlege, ist die Einstellung seit anbeginn vom Forum (2017) so

    eingestellt und ist/war der unerfahrenheit meinerseits geschultet.

    Hab da wohl wild und unbedacht alles an häckchen,... angeklickt und ...


    Vielen Dank für den Support


    Sascha

  • Marcel Werk October 10, 2022 at 5:17 PM

    Added the Label 5.5.6
  • Marcel Werk October 10, 2022 at 5:17 PM

    Set the Label from Confirmed to Fixed

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!