Could not prepare statement 'SELECT file.fileID AS....

  • Betroffene Version
    WoltLab Suite 5.3

    Seit dem Release von 5.2 nach 5.3 bekomme ich täglich eine Fehlermeldung welche die Filebase und auch die Easylink betrifft.

    Spoiler anzeigen

    Thu, 19 Nov 2020 17:31:19 +0000 Message: Could not prepare statement 'SELECT file.fileID AS objectID FROM filebase1_file file WHERE file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (file.isDisabled = 0 OR file.userID = ?) AND file.isDeleted = 0 AND subject LIKE ? ORDER BY file.downloads DESC LIMIT 5' PHP version: 7.4.12 WoltLab Suite version: 5.3.0 Request URI: POST /wcf/index.php?extended-search/ Referrer: https://www.forum-blasenkrebs.net/wcf/index.php?search/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:82.0) Gecko/20100101 Firefox/82.0 Peak Memory Usage: 10460480/536870912 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT file.fileID AS objectID FROM filebase1_file file WHERE file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (file.isDisabled = 0 OR file.userID = ?) AND file.isDeleted = 0 AND subject LIKE ? ORDER BY file.downloads DESC LIMIT 5' Error Code: 42S22 File: /homepages/14/d407714533/htdocs/forum-blasenkrebs-net/wcf/lib/system/database/Database.class.php (284) Extra Information: - Stack Trace: [{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/data\/DatabaseObjectList.class.php","line":164,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tfile.fileID AS objectID\n\t\t\tFROM\tfilebase1_file file\n\t\t\t\t\n\t\t\t\tWHERE file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (file.isDisabled = 0 OR file.userID = ?) AND file.isDeleted = 0 AND subject LIKE ?\n\t\t\t\tORDER BY file.downloads DESC LIMIT 5",5,0]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/data\/file\/AccessibleFileList.class.php","line":45,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/system\/event\/listener\/ExtendedSearchFilebaseListener.class.php","line":57,"function":"readObjects","class":"filebase\\data\\file\\AccessibleFileList","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/system\/event\/listener\/ExtendedSearchFilebaseListener.class.php","line":39,"function":"getFiles","class":"filebase\\system\\event\\listener\\ExtendedSearchFilebaseListener","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"filebase\\system\\event\\listener\\ExtendedSearchFilebaseListener","type":"->","args":["wcf\\action\\ExtendedSearchAction","wcf\\action\\ExtendedSearchAction","execute",[]]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/AbstractAction.class.php","line":102,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\action\\ExtendedSearchAction","execute"]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/ExtendedSearchAction.class.php","line":85,"function":"execute","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\ExtendedSearchAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/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 'subject' in 'where clause' Error Code: 42S22 File: /homepages/14/d407714533/htdocs/forum-blasenkrebs-net/wcf/lib/system/database/Database.class.php (279) Extra Information: - Stack Trace: [{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/database\/Database.class.php","line":279,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tfile.fileID AS objectID\n\t\t\tFROM\tfilebase1_file file\n\t\t\t\t\n\t\t\t\tWHERE file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (file.isDisabled = 0 OR file.userID = ?) AND file.isDeleted = 0 AND subject LIKE ?\n\t\t\t\tORDER BY file.downloads DESC LIMIT 5"]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/data\/DatabaseObjectList.class.php","line":164,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tfile.fileID AS objectID\n\t\t\tFROM\tfilebase1_file file\n\t\t\t\t\n\t\t\t\tWHERE file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (file.isDisabled = 0 OR file.userID = ?) AND file.isDeleted = 0 AND subject LIKE ?\n\t\t\t\tORDER BY file.downloads DESC LIMIT 5",5,0]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/data\/file\/AccessibleFileList.class.php","line":45,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/system\/event\/listener\/ExtendedSearchFilebaseListener.class.php","line":57,"function":"readObjects","class":"filebase\\data\\file\\AccessibleFileList","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/filebase\/lib\/system\/event\/listener\/ExtendedSearchFilebaseListener.class.php","line":39,"function":"getFiles","class":"filebase\\system\\event\\listener\\ExtendedSearchFilebaseListener","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"filebase\\system\\event\\listener\\ExtendedSearchFilebaseListener","type":"->","args":["wcf\\action\\ExtendedSearchAction","wcf\\action\\ExtendedSearchAction","execute",[]]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/AbstractAction.class.php","line":102,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\action\\ExtendedSearchAction","execute"]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/ExtendedSearchAction.class.php","line":85,"function":"execute","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\ExtendedSearchAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/homepages\/14\/d407714533\/htdocs\/forum-blasenkrebs-net\/wcf\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    Dahinter hängen 2-3 Seiten gleichartiger Fehlermeldungen..

    siehe Bild;

    Was tun sprach Zeuss

    Gruß aus Aachen

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!