Danke für die schnelle Umsetzung. Allerdings bekomme ich einen Fehler beim Update von der letzten Version.
Code
Message: Could not execute statement 'ALTER TABLE `wcf1_definition_max_statements` ADD CONSTRAINT `c5bef01cf2a9f38f2d075d71c932157c_fk` FOREIGN KEY (`definitionID`) REFERENCES `wcf1_definition` (`definitionID`) ON DELETE CASCADE'
PHP version: 7.4.33
WoltLab Suite version: 5.5.10
Request URI: POST /cms/acp/index.php?install-package/&t=3c0995a728c42571c0617e16f7a68ec52d0e154caeeae02d9823c00cfe82220c-xOCGRcUW0NjVUmpxFvGdOQ==
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `wcf1_definition_max_statements` ADD CONSTRAINT `c5bef01cf2a9f38f2d075d71c932157c_fk` FOREIGN KEY (`definitionID`) REFERENCES `wcf1_definition` (`definitionID`) ON DELETE CASCADE'
Error Code: 23000
File: /www/htdocs/v098666/cms/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_definition_max_statements","c5bef01cf2a9f38f2d075d71c932157c_fk",{"columns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]","referencedColumns":"[redacted]","referencedTable":"[redacted]"}]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":["wcf1_definition_max_statements","wcf\\system\\database\\table\\index\\DatabaseTableForeignKey"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":["\/www\/htdocs\/v098666\/cms\/acp\/database\/update_de.yourecom.definition2_5.5.3_step3.php"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["69321762"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("d027a136"."#sql-5c0_edc152", CONSTRAINT "c5bef01cf2a9f38f2d075d71c932157c_fk" FOREIGN KEY ("definitionID") REFERENCES "wcf1_definition" ("definitionID") ON DELETE CASCADE)
Error Code: 23000
File: /www/htdocs/v098666/cms/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[[]]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_definition_max_statements","c5bef01cf2a9f38f2d075d71c932157c_fk",{"columns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]","referencedColumns":"[redacted]","referencedTable":"[redacted]"}]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":["wcf1_definition_max_statements","wcf\\system\\database\\table\\index\\DatabaseTableForeignKey"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":["\/www\/htdocs\/v098666\/cms\/acp\/database\/update_de.yourecom.definition2_5.5.3_step3.php"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["69321762"]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/v098666\/cms\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]