Guten Tag alle zusammen,
nach dem Update des Forums auf 5.2 und dann des Multihunters werden alle unsere User mit manipulierten Daten vom Multihunter angezeigt.
Hinzukommt diese Fehlermeldung, die aber von den manipulierten Daten unabhängig erscheint.
Vielleicht kann uns jemand weiterhelfen.
Fri, 28 May 2021 10:33:48 +0000
Message: Could not prepare statement 'SELECT userID FROM wcf1_multihunter_logs WHERE canvasData = ? AND userID <> ? AND canvasCheck IS NULL AND reported is NULL'
PHP version: 7.2.34-nmm1
WoltLab Suite version: 5.2.14
Request URI: /wcf/index.php?ajax-proxy/&t=a08980ad23c72c7251f92785679edd7c6b6f060c
Referrer: https://www.fantasy-geschichten-forum.de/wcf/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0
Peak Memory Usage: 5645200/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT userID FROM wcf1_multihunter_logs WHERE canvasData = ? AND userID <> ? AND canvasCheck IS NULL AND reported is NULL'
Error Code: 42
File: /www/htdocs/w01282ce/forum/wcf/lib/system/database/Database.class.php (284)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/multiHunter\/MultiHunterAction.class.php","line":248,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tuserID\n\t\t\t\t\tFROM\twcf1_multihunter_logs\n\t\t\t\t\tWHERE\tcanvasData = ?\n\t\t\t\t\t\tAND\tuserID <> ?\n\t\t\t\t\t\tAND canvasCheck IS NULL\n\t\t\t\t\t\tAND\treported is NULL"]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/multiHunter\/MultiHunterAction.class.php","line":113,"function":"doCanvasCheck","class":"wcf\\data\\multiHunter\\MultiHunterAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"jsUpdate","class":"wcf\\data\\multiHunter\\MultiHunterAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/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 'canvasData' in 'where clause'
Error Code: 42
File: /www/htdocs/w01282ce/forum/wcf/lib/system/database/Database.class.php (279)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/system\/database\/Database.class.php","line":279,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tuserID\n\t\t\t\t\tFROM\twcf1_multihunter_logs\n\t\t\t\t\tWHERE\tcanvasData = ?\n\t\t\t\t\t\tAND\tuserID <> ?\n\t\t\t\t\t\tAND canvasCheck IS NULL\n\t\t\t\t\t\tAND\treported is NULL -- '\/wcf\/index.php?ajax-proxy\/&t=a08980ad23c72c7251f92785679edd7c6b6f060c (wcf\\\\data\\\\multiHunter\\\\MultiHunterAction:jsUpdate)'"]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/multiHunter\/MultiHunterAction.class.php","line":248,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tuserID\n\t\t\t\t\tFROM\twcf1_multihunter_logs\n\t\t\t\t\tWHERE\tcanvasData = ?\n\t\t\t\t\t\tAND\tuserID <> ?\n\t\t\t\t\t\tAND canvasCheck IS NULL\n\t\t\t\t\t\tAND\treported is NULL"]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/multiHunter\/MultiHunterAction.class.php","line":113,"function":"doCanvasCheck","class":"wcf\\data\\multiHunter\\MultiHunterAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"jsUpdate","class":"wcf\\data\\multiHunter\\MultiHunterAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w01282ce\/forum\/wcf\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
liebe Grüße
Jenna