Hallo,
beim Updaten des News-Systems von Version 5.4.1 pl 5 → 5.4.2 pl 6 tritt seit längerem folgender Fehler auf:
Welchen Grund kann dies haben und wie können wir das Problem ohne jeglichen Datenverlust lösen?
Code
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":[]}]
Alles anzeigen
Über eine baldige Antwort würde ich mich sehr freuen.
Mit freundlichen Grüßen
Edge | Tom