Update auf 5.3.1 wegen Datenbankfehler nicht möglich

ilou · Dec 18th 2020

Hallo,

ich wollte gerade mal endlich das Update vom WSC 5.2.9 auf WSC 5.3.1 machen, allerdings erhalte ich dann folgenden Fehler:

Requested URL: POST /acp/index.php?install-package/&t=44bb95979bbefed948bc90a0ddf6d79eecb58671

Referrer: https://domain.de/acp/index.php?package-update/

Error Message: Could not execute statement 'ALTER TABLE `wcf1_user` ADD COLUMN `emailConfirmed` char(40),CHANGE COLUMN `password` `password` varchar(255) NOT NULL DEFAULT 'invalid:''

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /opt/bw-live/lib/system/database/statement/PreparedStatement.class.php (105)

Stacktrace

/opt/bw-live/lib/system/database/editor/MySQLDatabaseEditor.class.php (282): wcf\system\database\statement\PreparedStatement->execute(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (356): wcf\system\database\editor\MySQLDatabaseEditor->alterColumns(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (253): wcf\system\database\table\DatabaseTableChangeProcessor->applyColumnChanges(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (1022): wcf\system\database\table\DatabaseTableChangeProcessor->applyChanges(…)
/opt/bw-live/acp/update_com.woltlab.wcf_5.3.php (80): wcf\system\database\table\DatabaseTableChangeProcessor->process(…)
/opt/bw-live/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (72): include(…)
/opt/bw-live/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (50): wcf\system\package\plugin\ScriptPackageInstallationPlugin->run(…)
/opt/bw-live/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (70): wcf\system\package\plugin\ScriptPackageInstallationPlugin->install(…)
/opt/bw-live/lib/system/package/PackageInstallationDispatcher.class.php (743): wcf\system\package\plugin\AbstractPackageInstallationPlugin->update(…)
/opt/bw-live/lib/system/package/PackageInstallationDispatcher.class.php (144): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
/opt/bw-live/lib/acp/action/InstallPackageAction.class.php (73): wcf\system\package\PackageInstallationDispatcher->install(…)
/opt/bw-live/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\InstallPackageAction->stepInstall(…)
/opt/bw-live/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
/opt/bw-live/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
/opt/bw-live/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/opt/bw-live/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Type: PDOException

File (Line): /opt/bw-live/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/opt/bw-live/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/opt/bw-live/lib/system/database/editor/MySQLDatabaseEditor.class.php (282): wcf\system\database\statement\PreparedStatement->execute(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (356): wcf\system\database\editor\MySQLDatabaseEditor->alterColumns(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (253): wcf\system\database\table\DatabaseTableChangeProcessor->applyColumnChanges(…)
/opt/bw-live/lib/system/database/table/DatabaseTableChangeProcessor.class.php (1022): wcf\system\database\table\DatabaseTableChangeProcessor->applyChanges(…)
/opt/bw-live/acp/update_com.woltlab.wcf_5.3.php (80): wcf\system\database\table\DatabaseTableChangeProcessor->process(…)
/opt/bw-live/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (72): include(…)
/opt/bw-live/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (50): wcf\system\package\plugin\ScriptPackageInstallationPlugin->run(…)
/opt/bw-live/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (70): wcf\system\package\plugin\ScriptPackageInstallationPlugin->install(…)
/opt/bw-live/lib/system/package/PackageInstallationDispatcher.class.php (743): wcf\system\package\plugin\AbstractPackageInstallationPlugin->update(…)
/opt/bw-live/lib/system/package/PackageInstallationDispatcher.class.php (144): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
/opt/bw-live/lib/acp/action/InstallPackageAction.class.php (73): wcf\system\package\PackageInstallationDispatcher->install(…)
/opt/bw-live/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\InstallPackageAction->stepInstall(…)
/opt/bw-live/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
/opt/bw-live/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
/opt/bw-live/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/opt/bw-live/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Fri, 18 Dec 2020 17:30:12 +0000
Message: Could not execute statement 'ALTER TABLE `wcf1_user` ADD COLUMN `emailConfirmed` char(40),CHANGE COLUMN `password` `password` varchar(255) NOT NULL DEFAULT 'invalid:''
PHP version: 7.4.3
WoltLab Suite version: 5.2.10
Request URI: POST /acp/index.php?install-package/&t=44bb95979bbefed948bc90a0ddf6d79eecb58671
Referrer: https://domain.de/acp/index.php?package-update/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
Peak Memory Usage: 2789072/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `wcf1_user` ADD COLUMN `emailConfirmed` char(40),CHANGE COLUMN `password` `password` varchar(255) NOT NULL DEFAULT 'invalid:''
Error Code: 42000
File: /opt/bw-live/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTowOnt9
Stack Trace: [{"file":"\/opt\/bw-live\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":282,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":356,"function":"alterColumns","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":253,"function":"applyColumnChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1022,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/acp\/update_com.woltlab.wcf_5.3.php","line":80,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":72,"args":["\/opt\/bw-live\/acp\/update_com.woltlab.wcf_5.3.php"],"function":"include","class":"","type":""},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":50,"function":"run","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":743,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/opt\/bw-live\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Error Code: 42000
File: /opt/bw-live/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/opt\/bw-live\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":282,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":356,"function":"alterColumns","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":253,"function":"applyColumnChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/database\/table\/DatabaseTableChangeProcessor.class.php","line":1022,"function":"applyChanges","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/acp\/update_com.woltlab.wcf_5.3.php","line":80,"function":"process","class":"wcf\\system\\database\\table\\DatabaseTableChangeProcessor","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":72,"args":["\/opt\/bw-live\/acp\/update_com.woltlab.wcf_5.3.php"],"function":"include","class":"","type":""},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":50,"function":"run","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":743,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/opt\/bw-live\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/opt\/bw-live\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Habe dann erstmal versucht, das Update auf 5.2.10 und dann von da aus auf 5.3.1 zu machen. Das erste Update funktioniert auch, aber das 2. auf 5.3 nicht.

Weiß jemand, woran das liegen kann?

Gruß

ilou

EDIT: Ich weiß nicht, ob das hier richtig aufgehoben ist. Falls es in Fehler gehört, bitte verschieben

**Alexander Ebert** · Dec 18th 2020

Hallo,

hast du das ROW_FORMAT der Tabellen geändert? Wenn das auf COMPACT steht, sind Änderungen an den Spalten unmöglich.

ilou · Dec 18th 2020

Danke für den Tipp, da wäre ich vermutlich nie drauf gekommen. Leider musste ich meine Datenbank neu aufsetzen, ist mir so rum dann aber lieber, bevor ich mir am Ende alles zerschieße.

Danke

Update auf 5.3.1 wegen Datenbankfehler nicht möglich

Participate now!

Share

Similar Threads

"getimagesize(): Read error!" beim Bearbeiten von Stilen

Detailfragen zum Upgrade 4.1 > 5.2