Guten Abend,
Wenn ich das aktuelle update einspielen möchte erhalte folgenden Fehler:
Code
Tue, 20 Jun 2023 17:40:28 +0000
Message: Could not execute statement 'ALTER TABLE `cbs1_user` ADD CONSTRAINT `d2ecb15d9f0d89838d6c4d7302b81e8f_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE'
PHP version: 8.0.28
WoltLab Suite version: 5.5.12
Request URI: POST /acp/index.php?install-package/&t=587b7408dd50c2b934897aed96e16a5f2a3388865f7dbe93638dbe86afa5bcfe-anCxetnVv2UuksXgQxeBJg==
Referrer: https://www.###.de/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36
Peak Memory Usage: 15732216/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `cbs1_user` ADD CONSTRAINT `d2ecb15d9f0d89838d6c4d7302b81e8f_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE'
Error Code: 23000
File: /home/www/public_html/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/public_html\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/public_html\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("HTO01FLQQMIV"."#sql-eda2_362a77c", CONSTRAINT "d2ecb15d9f0d89838d6c4d7302b81e8f_fk" FOREIGN KEY ("userID") REFERENCES "wcf1_user" ("userID") ON DELETE CASCADE)
Error Code: 23000
File: /home/www/public_html/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/public_html\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/public_html\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/public_html\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
Alles anzeigen