- Affected App
- WoltLab Suite Core
Hallo,
beim ausführen des Cronjobs zur Vergabe der Trophäen kommt es zu folgendem Fehler. Kann da wer helfen?
Wed, 04 Jul 2018 11:52:39 +0000
Message: Could not prepare statement 'SELECT user_table.userID AS objectID
FROM wcf1_user user_table
WHERE user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?)) AND user_option_value.userOption4 = ? AND user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?))
'
PHP version: 7.0.30-0ubuntu0.16.04.1
WoltLab Suite version: 3.1.4
Request URI: /acp/index.php?ajax-proxy/&t=82cf8de770e6f2abaacaaa974c7edbaf812fada7
Referrer: https://www.infinity-gaming.org/acp/index.php?cronjob-list/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0
Peak Memory Usage: 5491008/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT user_table.userID AS objectID
FROM wcf1_user user_table
WHERE user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?)) AND user_option_value.userOption4 = ? AND user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?))
'
Error Code: 42
File: /var/www/vhosts/infinity-gaming.org/httpdocs/lib/system/database/Database.class.php (248)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":164,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tuser_table.userID AS objectID\r\n\t\t\tFROM\twcf1_user user_table\r\n\t\t\t\t\r\n\t\t\t\tWHERE user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?)) AND user_option_value.userOption4 = ? AND user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?))\r\n\t\t\t\t",0,0]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/trophy\/condition\/TrophyConditionHandler.class.php","line":104,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/trophy\/condition\/TrophyConditionHandler.class.php","line":72,"function":"getUserIDs","class":"wcf\\system\\trophy\\condition\\TrophyConditionHandler","type":"->","args":["wcf\\data\\trophy\\Trophy"]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/cronjob\/AssignTrophiesCronjob.class.php","line":23,"function":"assignTrophies","class":"wcf\\system\\trophy\\condition\\TrophyConditionHandler","type":"->","args":[100]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/cronjob\/CronjobAction.class.php","line":147,"function":"execute","class":"wcf\\system\\cronjob\\AssignTrophiesCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"function":"execute","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_option_value.userOption4' in 'where clause'
Error Code: 42
File: /var/www/vhosts/infinity-gaming.org/httpdocs/lib/system/database/Database.class.php (243)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tuser_table.userID AS objectID\r\n\t\t\tFROM\twcf1_user user_table\r\n\t\t\t\t\r\n\t\t\t\tWHERE user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?)) AND user_option_value.userOption4 = ? AND user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?))\r\n\t\t\t\t"]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":164,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tuser_table.userID AS objectID\r\n\t\t\tFROM\twcf1_user user_table\r\n\t\t\t\t\r\n\t\t\t\tWHERE user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?)) AND user_option_value.userOption4 = ? AND user_table.userID NOT IN (SELECT userID FROM wcf1_user_trophy WHERE trophyID IN (?))\r\n\t\t\t\t",0,0]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/trophy\/condition\/TrophyConditionHandler.class.php","line":104,"function":"readObjectIDs","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/trophy\/condition\/TrophyConditionHandler.class.php","line":72,"function":"getUserIDs","class":"wcf\\system\\trophy\\condition\\TrophyConditionHandler","type":"->","args":["wcf\\data\\trophy\\Trophy"]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/cronjob\/AssignTrophiesCronjob.class.php","line":23,"function":"assignTrophies","class":"wcf\\system\\trophy\\condition\\TrophyConditionHandler","type":"->","args":[100]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/cronjob\/CronjobAction.class.php","line":147,"function":"execute","class":"wcf\\system\\cronjob\\AssignTrophiesCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"function":"execute","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/infinity-gaming.org\/httpdocs\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
