{
"pluginName": "ViisonDHL",
"versionNew": "4.21.0.55",
"user": "AB",
"exception": {
"class": "Zend_Db_Adapter_Exception",
"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",
"file": /engine/Library/Zend/Db/Adapter/Pdo/Abstract.php",
"line": 271,
"code": 42000,
"trace": [
"#0 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/Classes/Installation/SQLHelper.php(39): Zend_Db_Adapter_Pdo_Abstract->exec('ALTER TABLE `s_...')",
"#1 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/Bootstrap.php(1696): Shopware\\Plugins\\ViisonCommon\\Classes\\Installation\\SQLHelper->addColumnIfNotExists('s_core_shops_vi...', 'sendersCustomsR...', 'VARCHAR(255) NO...')",
"#2 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(226): Shopware_Plugins_Backend_ViisonDHL_Bootstrap->runUpdate('4.20.1.55')",
"#3 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(470): ViisonCommon_Plugin_BootstrapV8->{closure}()",
"#4 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(227): ViisonCommon_Plugin_BootstrapV8->executeSetupMethod('Update from ver...', Object(Closure))",
"#5 /engine/Shopware/Components/Plugin/Namespace.php(443): ViisonCommon_Plugin_BootstrapV8->update('4.20.1.55')",
"#6 /engine/Shopware/Bundle/PluginInstallerBundle/Service/LegacyPluginInstaller.php(156): Shopware_Components_Plugin_Namespace->updatePlugin(Object(Shopware_Plugins_Backend_ViisonDHL_Bootstrap))",
"#7 /engine/Shopware/Bundle/PluginInstallerBundle/Service/InstallerService.php(211): Shopware\\Bundle\\PluginInstallerBundle\\Service\\LegacyPluginInstaller->updatePlugin(Object(Shopware\\Models\\Plugin\\Plugin))",
"#8 /engine/Shopware/Plugins/Default/Backend/PluginManager/Controllers/Backend/PluginInstaller.php(89): Shopware\\Bundle\\PluginInstallerBundle\\Service\\InstallerService->updatePlugin(Object(Shopware\\Models\\Plugin\\Plugin))",
"#9 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_PluginInstaller->updateAction()",
"#10 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('updateAction')",
"#11 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))",
"#12 /engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()",
"#13 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)",
"#14 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\\Component\\HttpKernel\\HttpCache\\SubRequestHandler::handle(Object(Shopware\\Kernel), Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)",
"#15 /engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->forward(Object(Symfony\\Component\\HttpFoundation\\Request), true, NULL)",
"#16 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\\Components\\HttpCache\\AppCache->forward(Object(Symfony\\Component\\HttpFoundation\\Request), true)",
"#17 /engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->pass(Object(Symfony\\Component\\HttpFoundation\\Request), true)",
"#18 /var/www/clients/client18/web32/web/shopware.php(122): Shopware\\Components\\HttpCache\\AppCache->handle(Object(Symfony\\Component\\HttpFoundation\\Request))",
"#19 {main}"
],
"previous": {
"class": "PDOException",
"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",
"file": /engine/Library/Zend/Db/Adapter/Pdo/Abstract.php",
"line": 256,
"code": "42000",
"trace": [
"#0 /engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(256): PDO->exec('ALTER TABLE `s_...')",
"#1 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/Classes/Installation/SQLHelper.php(39): Zend_Db_Adapter_Pdo_Abstract->exec('ALTER TABLE `s_...')",
"#2 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/Bootstrap.php(1696): Shopware\\Plugins\\ViisonCommon\\Classes\\Installation\\SQLHelper->addColumnIfNotExists('s_core_shops_vi...', 'sendersCustomsR...', 'VARCHAR(255) NO...')",
"#3 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(226): Shopware_Plugins_Backend_ViisonDHL_Bootstrap->runUpdate('4.20.1.55')",
"#4 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(470): ViisonCommon_Plugin_BootstrapV8->{closure}()",
"#5 /engine/Shopware/Plugins/Community/Backend/ViisonDHL/ViisonCommon/PluginBootstrapV8.php(227): ViisonCommon_Plugin_BootstrapV8->executeSetupMethod('Update from ver...', Object(Closure))",
"#6 /engine/Shopware/Components/Plugin/Namespace.php(443): ViisonCommon_Plugin_BootstrapV8->update('4.20.1.55')",
"#7 /engine/Shopware/Bundle/PluginInstallerBundle/Service/LegacyPluginInstaller.php(156): Shopware_Components_Plugin_Namespace->updatePlugin(Object(Shopware_Plugins_Backend_ViisonDHL_Bootstrap))",
"#8 /engine/Shopware/Bundle/PluginInstallerBundle/Service/InstallerService.php(211): Shopware\\Bundle\\PluginInstallerBundle\\Service\\LegacyPluginInstaller->updatePlugin(Object(Shopware\\Models\\Plugin\\Plugin))",
"#9 /engine/Shopware/Plugins/Default/Backend/PluginManager/Controllers/Backend/PluginInstaller.php(89): Shopware\\Bundle\\PluginInstallerBundle\\Service\\InstallerService->updatePlugin(Object(Shopware\\Models\\Plugin\\Plugin))",
"#10 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_PluginInstaller->updateAction()",
"#11 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('updateAction')",
"#12 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))",
"#13 /engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()",
"#14 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)",
"#15 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\\Component\\HttpKernel\\HttpCache\\SubRequestHandler::handle(Object(Shopware\\Kernel), Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)",
"#16 /engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->forward(Object(Symfony\\Component\\HttpFoundation\\Request), true, NULL)",
"#17 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\\Components\\HttpCache\\AppCache->forward(Object(Symfony\\Component\\HttpFoundation\\Request), true)",
"#18 /engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\\Component\\HttpKernel\\HttpCache\\HttpCache->pass(Object(Symfony\\Component\\HttpFoundation\\Request), true)",
"#19 /var/www/clients/client18/web32/web/shopware.php(122): Shopware\\Components\\HttpCache\\AppCache->handle(Object(Symfony\\Component\\HttpFoundation\\Request))",
"#20 {main}"
],
"previous": null
}
}
}
Error
Unable to update ‘ViisonDHL’, got 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
wie kann man das lösen?
Durch das nicht funktionieren des Updates geht nun kein Label mehr mit Exportdokument
Danke für eine Hilfe.