Kritischer Fehler! Nicht angemeldete Nutzer können nicht mehr auf die Seite zugreifen.

    • Fixed

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Kritischer Fehler! Nicht angemeldete Nutzer können nicht mehr auf die Seite zugreifen.

      Ahoi zusammen!

      Vor einem Tag habe ich das neuste Update installiert, nun haben wir jedoch das Problem, sobald man sich abmeldet oder unangemeldet auf unsere Seite (iskaria.de) zugreifen will eine Fehlermeldung kommt.
      Wie auch auf der Shopseite von Woltlab kommentiert wurde, bin ich nicht der einzige bei dem dieser Fehler nach dem neusten Update erscheint.

      Sofern der Fehler nicht in den nächsten zwei Tagen behoben werden kann, würde ich mich über eine Anleitung zum Downgrade (vorherige Version) freuen, bei dem keine vorhandenen Clan Daten gelöscht werden.

      Hier zur Fehlermeldung:

      Mon, 20 May 2019 00:03:10 +0000
      Message: Could not prepare statement 'SELECT
      comment.*
      FROM wcf1_comment comment

      WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      PHP version: 7.3.2
      WoltLab Suite version: 3.1.9 pl 2
      Request URI: /
      Referrer:
      User Agent: Mozilla/5.0 (compatible; DotBot/1.1; opensiteexplorer.org/dotbot, help@moz.com)
      Peak Memory Usage: 11607016/536870912
      ======
      Error Class: wcf\system\database\exception\DatabaseQueryException
      Error Message: Could not prepare statement 'SELECT
      comment.*
      FROM wcf1_comment comment

      WHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1
      ORDER BY comments DESC, comment.commentID DESC LIMIT 5'
      Error Code: 42
      File: /home/iskariadis/www/lib/system/database/Database.class.php (248)
      Extra Information: -
      Stack Trace: [{"file":"\/home\/iskariadis\/www\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/home\/iskariadis\/www\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/templates\/compiled\/3_wcf_1_cms.php","line":2208,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/home\/iskariadis\/www\/templates\/compiled\/3_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/home\/iskariadis\/www\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/home\/iskariadis\/www\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
      ======
      Error Class: PDOException
      Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comments' in 'order clause'
      Error Code: 42
      File: /home/iskariadis/www/lib/system/database/Database.class.php (243)
      Extra Information: -
      Stack Trace: [{"file":"\/home\/iskariadis\/www\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5"]},{"file":"\/home\/iskariadis\/www\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tcomment.*\r\n\t\t\t\tFROM\twcf1_comment comment\r\n\t\t\t\t\t\r\n\t\t\t\t\tWHERE comment.isDisabled = ? AND comment.objectTypeID = ? AND 0 = 1\r\n\t\t\t\t\tORDER BY comments DESC, comment.commentID DESC LIMIT 5","5",0]},{"file":"\/home\/iskariadis\/www\/lib\/data\/comment\/ViewableCommentList.class.php","line":28,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":255,"function":"readObjects","class":"wcf\\data\\comment\\ViewableCommentList","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":231,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":202,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/data\/box\/Box.class.php","line":278,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/data\/box\/Box.class.php","line":263,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/templates\/compiled\/3_wcf_1_cms.php","line":2208,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/template\/TemplateEngine.class.php","line":321,"args":["\/home\/iskariadis\/www\/templates\/compiled\/3_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/home\/iskariadis\/www\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/home\/iskariadis\/www\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/iskariadis\/www\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]