Ich wollte soeben einen Benutzer im ACP löschen und erhielt folgenden Fehler:
Tue, 28 Dec 2021 19:20:51 +0000
Message: Could not prepare statement 'UPDATE news1_rss_feed SET username = ? WHERE userID = ?'
PHP version: 8.0.14
WoltLab Suite version: 5.4.10
Request URI: POST /acp/index.php?ajax-proxy/&t=ee54325b89828a4429b80b1ea90e61181bba12b824cace3d8eba7157c85b87ac-RAlUx54xkSv6f7WlhqTB9w==
Referrer: https://www.compiware-forum.de/acp/index.php?user-list/&action=&pageNo=1&sortField=registrationDate&sortOrder=DESC
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.113 Safari/537.36
Peak Memory Usage: 4151648/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'UPDATE news1_rss_feed SET username = ? WHERE userID = ?'
Error Code: 42S22
File: /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/listener\/AbstractUserActionRenameListener.class.php","line":58,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":252,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractUserActionRenameListener","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/user\/UserAction.class.php","line":441,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/listener\/ScPseudoUsernameListener.class.php","line":96,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":161,"function":"execute","class":"wcf\\system\\event\\listener\\ScPseudoUsernameListener","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":204,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":156,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":80,"function":"__construct","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'username' in 'field list'
Error Code: 42S22
File: /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/listener\/AbstractUserActionRenameListener.class.php","line":58,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":252,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractUserActionRenameListener","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/user\/UserAction.class.php","line":441,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"update","class":"wcf\\data\\user\\UserAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/listener\/ScPseudoUsernameListener.class.php","line":96,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":161,"function":"execute","class":"wcf\\system\\event\\listener\\ScPseudoUsernameListener","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/event\/EventHandler.class.php","line":204,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":156,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":80,"function":"__construct","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
Alles anzeigen
Der Benutzer wird nicht gelöscht, sondern bekommt einen zufälligen Namen. Das passiert, weil ich das Plugin "DSGVO: Auto-Benutzer-Umbenennung" von SoftCreatR benutze.
Laut Sascha liegt das Problem beim News System.
Zitat von SoftCreatRunser Plugin benennt lediglich den Benutzer um, nimmt aber sonst keine Änderungen in der Datenbank vor. Die Fehlermeldung sagt aus, dass versucht wird, den Benutzernamen in der Tabelle "news1_rss_feed" zu ändern, dort aber keine Spalte "username" existiert. Diese Anweisung kommt zu 100% aus einem anderen Plugin (wahrscheinlich dem News-Plugin selbst) .
Wäre super, wenn du das Problem lösen könntest, denn ich kann den Benutzer nicht löschen. Er wird immer umbenannt...