Beiträge von Edge | Tom

Mon, 14 Nov 2022 19:17:22 +0000
Message: Could not execute statement 'ALTER TABLE `news1_news_image` ADD CONSTRAINT `ba416abe22d33e2eb049319f141e5cff_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE'
PHP version: 8.1.12
WoltLab Suite version: 5.5.6
Request URI: POST /acp/index.php?install-package/&t=0e54df18f9cb951362dc4c2cbda4d32b6d3cfd1b94dd41fb5ae30ac480814016-i+zRrokdq3H+xMT/R6q4nw==
Referrer: https://forum.212th.de/acp/index.php?package-update/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36
Peak Memory Usage: 3464928/1073741824
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `news1_news_image` ADD CONSTRAINT `ba416abe22d33e2eb049319f141e5cff_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE'
Error Code: 23000
File: /var/www/vhosts/212th.de/forum.212th.de/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/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 ("wcf_main_db"."#sql-46d_2c228", CONSTRAINT "ba416abe22d33e2eb049319f141e5cff_fk" FOREIGN KEY ("userID") REFERENCES "wcf1_user" ("userID") ON DELETE CASCADE)
Error Code: 23000
File: /var/www/vhosts/212th.de/forum.212th.de/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":384,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":212,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":313,"function":"addForeignKey","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

CREATE TABLE `news1_news` (
  `newsID` int(10) NOT NULL AUTO_INCREMENT,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` int(10) NOT NULL,
  `userID` int(10) DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `isDisabled` tinyint(1) NOT NULL DEFAULT 0,
  `cumulativeLikes` mediumint(7) DEFAULT NULL,
  `views` mediumint(7) DEFAULT NULL,
  `deleteTime` int(10) NOT NULL DEFAULT 0,
  `deleteReason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `editCount` mediumint(7) DEFAULT NULL,
  `enableHtml` tinyint(1) NOT NULL DEFAULT 0,
  `lastEditTime` int(10) NOT NULL DEFAULT 0,
  `editor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `editorID` int(10) DEFAULT NULL,
  `isHot` tinyint(1) NOT NULL DEFAULT 0,
  `onlySidebar` tinyint(1) NOT NULL DEFAULT 0,
  `bigVersion` tinyint(1) NOT NULL DEFAULT 0,
  `comments` smallint(5) DEFAULT NULL,
  `hasEmbeddedObjects` tinyint(1) NOT NULL DEFAULT 0,
  `enableTime` int(10) NOT NULL,
  `isMultilingual` tinyint(1) NOT NULL DEFAULT 1,
  `teaser` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newsUpdateTime` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`newsID`),
  KEY `userID` (`userID`),
  KEY `newsUpdateTime` (`newsUpdateTime`,`newsID`),
  KEY `1b5382b90bd44bd852d5623389dfa241_fk` (`editorID`),
  CONSTRAINT `1b5382b90bd44bd852d5623389dfa241_fk` FOREIGN KEY (`editorID`) REFERENCES `wcf1_user` (`userID`) ON DELETE SET NULL,
  CONSTRAINT `e6912c2470b98785678f433aa2996090_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Sun, 13 Nov 2022 00:09:28 +0000
Message: Could not execute statement 'ALTER TABLE `news1_news` CHANGE COLUMN `time` `time` int(10) NOT NULL DEFAULT '0',CHANGE COLUMN `cumulativeLikes` `cumulativeLikes` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `views` `views` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `editCount` `editCount` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `comments` `comments` smallint(5) NOT NULL DEFAULT '0',CHANGE COLUMN `enableTime` `enableTime` int(10) NOT NULL DEFAULT '0''
PHP version: 8.1.12
WoltLab Suite version: 5.5.6
Request URI: POST /acp/index.php?install-package/&t=880923565a6dda99342264e94612796143b9822f40a304c65097205ae04d7576-62GsYQTMq5FDwHeOoQS9EA==
Referrer: https://forum.212th.de/acp/index.php?package-update/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36
Peak Memory Usage: 3464736/1073741824
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `news1_news` CHANGE COLUMN `time` `time` int(10) NOT NULL DEFAULT '0',CHANGE COLUMN `cumulativeLikes` `cumulativeLikes` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `views` `views` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `editCount` `editCount` mediumint(7) NOT NULL DEFAULT '0',CHANGE COLUMN `comments` `comments` smallint(5) NOT NULL DEFAULT '0',CHANGE COLUMN `enableTime` `enableTime` int(10) NOT NULL DEFAULT '0''
Error Code: 01000
File: /var/www/vhosts/212th.de/forum.212th.de/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":319,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":388,"function":"alterColumns","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":279,"function":"applyColumnChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'views' at row 61
Error Code: 01000
File: /var/www/vhosts/212th.de/forum.212th.de/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":319,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":388,"function":"alterColumns","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":279,"function":"applyColumnChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1164,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":78,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/DatabasePackageInstallationPlugin.class.php","line":48,"function":"updateDatabase","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\DatabasePackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/212th.de\/forum.212th.de\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]