Moin.
Ich bekomme beim Mergen von 2 Useraccounts immer den Fehler, das ein doppelter Eintrag für 'userID' vorhanden sei.
Code
Wed, 26 Apr 2023 09:58:33 +0000
Message: Could not execute statement 'UPDATE wcf1_multihunter_automatic_blocking SET userID = ? , username = ? WHERE userID IN (?)'
PHP version: 8.1.18
WoltLab Suite version: 5.5.11
Request URI: POST /acp/index.php?user-merge/
Referrer: https://www.bloodygang.com/acp/index.php?user-merge/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.58
Peak Memory Usage: 4175872/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE wcf1_multihunter_automatic_blocking SET userID = ? , username = ? WHERE userID IN (?)'
Error Code: 23000
File: /var/www/vhosts/bloodygang.com/woltlab/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjEzMTE7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO3M6NjoiJ2Jvb24nIjt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aToxMTk3O319
Stack Trace: [{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/listener\/AbstractUserMergeListener.class.php","line":71,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractUserMergeListener","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":134,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/acp\/form\/UserMergeForm.class.php","line":124,"function":"save","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"wcf\\acp\\form\\UserMergeForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1311' for key 'userID'
Error Code: 23000
File: /var/www/vhosts/bloodygang.com/woltlab/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/listener\/AbstractUserMergeListener.class.php","line":71,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractUserMergeListener","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":134,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/acp\/form\/UserMergeForm.class.php","line":124,"function":"save","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":80,"function":"save","class":"wcf\\acp\\form\\UserMergeForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/form\/AbstractForm.class.php","line":152,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bloodygang.com\/woltlab\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
Alles anzeigen