- Affected App
- WoltLab Suite Core
Hallo,
wenn ich die Box "Ausstehende Termine" der Kalender-App auf einer Seite aktiviere kommt eine Fehlermeldung:
Sat, 22 Oct 2016 15:18:34 +0000
Message: Could not prepare statement 'SELECT event_date_participation.*, event_date_participation.participants AS userParticipants,
event_date.*
FROM calendar1_event_date event_date
LEFT JOIN calendar1_event_date_participation event_date_participation ON (event_date_participation.eventDateID = event_date.eventDateID AND event_date_participation.userID = 1)
WHERE event_date.eventDateID IN (?,?,?,?)
ORDER BY subject ASC, event_date.eventDateID ASC'
PHP version: 5.6.26
WCF version: 3.0.0 Beta 3
Request URI: /
Referrer: https://www.xhorror.com/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393
Peak Memory Usage: 13822372/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT event_date_participation.*, event_date_participation.participants AS userParticipants,
event_date.*
FROM calendar1_event_date event_date
LEFT JOIN calendar1_event_date_participation event_date_participation ON (event_date_participation.eventDateID = event_date.eventDateID AND event_date_participation.userID = 1)
WHERE event_date.eventDateID IN (?,?,?,?)
ORDER BY subject ASC, event_date.eventDateID ASC'
Error Code: 42
File: /mnt/web017/e3/42/57657242/htdocs/xhorror/lib/system/database/Database.class.php (240)
Extra Information: -
Stack Trace: [{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/DatabaseObjectList.class.php","line":183,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tevent_date_participation.*, event_date_participation.participants AS userParticipants,\r\n\t\t\t\t\tevent_date.*\r\n\t\t\t\tFROM\tcalendar1_event_date event_date\r\n\t\t\t\t\t LEFT JOIN calendar1_event_date_participation event_date_participation ON (event_date_participation.eventDateID = event_date.eventDateID AND event_date_participation.userID = 1)\r\n\t\t\t\tWHERE\tevent_date.eventDateID IN (?,?,?,?)\r\n\t\t\t\t\tORDER BY subject ASC, event_date.eventDateID ASC"]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/ViewableEventDateList.class.php","line":47,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/FilteredEventDateList.class.php","line":42,"function":"readObjects","class":"calendar\\data\\event\\date\\ViewableEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/AccessibleEventDateList.class.php","line":48,"function":"readObjects","class":"calendar\\data\\event\\date\\FilteredEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":253,"function":"readObjects","class":"calendar\\data\\event\\date\\AccessibleEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":229,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":200,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/box\/Box.class.php","line":272,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/box\/Box.class.php","line":257,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/templates\/compiled\/0_wcf_1_cms.php","line":1977,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/template\/TemplateEngine.class.php","line":320,"args":["\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/templates\/compiled\/0_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/page\/AbstractPage.class.php","line":300,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/page\/AbstractPage.class.php","line":97,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/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 'order clause'
Error Code: 42
File: /mnt/web017/e3/42/57657242/htdocs/xhorror/lib/system/database/Database.class.php (235)
Extra Information: -
Stack Trace: [{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/database\/Database.class.php","line":235,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tevent_date_participation.*, event_date_participation.participants AS userParticipants,\r\n\t\t\t\t\tevent_date.*\r\n\t\t\t\tFROM\tcalendar1_event_date event_date\r\n\t\t\t\t\t LEFT JOIN calendar1_event_date_participation event_date_participation ON (event_date_participation.eventDateID = event_date.eventDateID AND event_date_participation.userID = 1)\r\n\t\t\t\tWHERE\tevent_date.eventDateID IN (?,?,?,?)\r\n\t\t\t\t\tORDER BY subject ASC, event_date.eventDateID ASC"]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/DatabaseObjectList.class.php","line":183,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tevent_date_participation.*, event_date_participation.participants AS userParticipants,\r\n\t\t\t\t\tevent_date.*\r\n\t\t\t\tFROM\tcalendar1_event_date event_date\r\n\t\t\t\t\t LEFT JOIN calendar1_event_date_participation event_date_participation ON (event_date_participation.eventDateID = event_date.eventDateID AND event_date_participation.userID = 1)\r\n\t\t\t\tWHERE\tevent_date.eventDateID IN (?,?,?,?)\r\n\t\t\t\t\tORDER BY subject ASC, event_date.eventDateID ASC"]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/ViewableEventDateList.class.php","line":47,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/FilteredEventDateList.class.php","line":42,"function":"readObjects","class":"calendar\\data\\event\\date\\ViewableEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/calendar\/lib\/data\/event\/date\/AccessibleEventDateList.class.php","line":48,"function":"readObjects","class":"calendar\\data\\event\\date\\FilteredEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":253,"function":"readObjects","class":"calendar\\data\\event\\date\\AccessibleEventDateList","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":229,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":200,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/box\/Box.class.php","line":272,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/data\/box\/Box.class.php","line":257,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/templates\/compiled\/0_wcf_1_cms.php","line":1977,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/template\/TemplateEngine.class.php","line":320,"args":["\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/templates\/compiled\/0_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/page\/AbstractPage.class.php","line":300,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/page\/AbstractPage.class.php","line":97,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/mnt\/web017\/e3\/42\/57657242\/htdocs\/xhorror\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]