DHL Adapter Update geht nicht 1118 Row size too large

{
  "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 :frowning:

Danke für eine Hilfe.

 

 

 

 

Hallo,

schau mal hier:

Viele Grüße

1 Like

passt, läuft wieder :slight_smile:

Hallo zusammen,
ich habe dasselbe Problem, komme allerdings mit der Lösung nicht weiter.
Die Anleitung habe ich gelesen, kann aber die Konfiguration der Datenbank nicht finden. (my.cnf)
Ich bin zwar nicht unbedarft, aber das übersteigt meine Kenntnisse denn doch gewaltig.
Wer kann mir sagen, wo ich die Datei finde, dann kann ich weiter sehen, ob ich das gefixt bekomme.
Danke Euch!

Die Datei findest Du unter /etc/my.cnf (CentOS) oder unter /etc/mysql/my.cnf (Debian/Ubuntu) - benötigst jedoch root Rechte (eigener Server). Im Shared Hosting musst Du Dich an Deinen Hoster wenden.

Viele Grüße

1 Like

Dankeschön! Dann ist jetzt klar, warum ich das nicht finden konnte.