Moin, beim Versuch das Basissystem zu aktualisieren, bekomme ich folgenden Fehler.
ZitatAlles anzeigenMon, 19 Jun 2023 12:24:14 +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.1.18
WoltLab Suite version: 5.5.12
Request URI: POST /acp/index.php?install-package/&t=a2f131996053ff04fc07d71f657a21f02f910f9962175260c699d6a3beb1971a-gelQXH40fQG8yrCKotcXRg==
Referrer: http://test.lees-corner.de/acp/index.php?package-update/
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 Edg/114.0.1823.51
Peak Memory Usage: 11852416/268435456
======
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: /kunden/541669_40223/webseiten/lc_test/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/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 ("db541669_39"."#sql-1_991e1b", CONSTRAINT "d2ecb15d9f0d89838d6c4d7302b81e8f_fk" FOREIGN KEY ("userID") REFERENCES "wcf1_user" ("userID") ON DELETE CASCADE)
Error Code: 23000
File: /kunden/541669_40223/webseiten/lc_test/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/kunden\/541669_40223\/webseiten\/lc_test\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]