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 (http://www.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; http://www.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"]}]