# Softwareaktualisierung - Voraussetzungen laden nicht. 5.2.16 ->5.2.17 - System-Log Fehler **URL:** \ **Category:** Installation/Einstieg\ **Created:** [14. Februar 2017 um 13:12 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708 "2017-02-14T13:12:15Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![hamaca](https://avatars.discourse-cdn.com/v4/letter/h/54ee81/32.png) [@hamaca](https://forum.shopware.com/u/hamaca)\ **Post date:** [14. Februar 2017 um 13:12 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708/1 "2017-02-14T13:12:15Z")
Hallo, beim Versuch zu kontrollieren ob die nötige Voraussetzungen zum Update auf 5.2.17 erfüllt sind bricht immer nach mehrere Minuten der Vorgang ab und wir erhalten eine “communication failure”. System Log-Fehler ergibt folgendes: ``` [2017-02-14 10:54:00] core.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'element_id' cannot be null in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:987 Stack trace: #0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): PDOStatement->execute() #1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(100): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO s_c...', Array) #2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(61): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->storeUniqueIdInDb('Aom2BiG7fsaTci7...') #3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(453): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->getUniqueId() #4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(266): Shopware_Controllers_Backend_SwagUpdate->getUnique() #5 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagUpdate->popupAction() #6 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('popupAction') #7 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #9 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #10 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #11 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #12 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #13 /is/htdocs/wp1061229_47VO1MQRUV/www/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'INSERT INTO s_core_config_values (element_id, shop_id, value) VALUES ( (SELECT id FROM s_core_config_elements WHERE name LIKE 'trackingUniqueId' LIMIT 1), 1, ? )' with params ["s:32:\"Aom2BiG7fsaTci7rEcoKQ4O5jQeznw2w\";"]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'element_id' cannot be null in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119 Stack trace: #0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT INTO s_c...', Array) #1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(100): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO s_c...', Array) #2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(61): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->storeUniqueIdInDb('Aom2BiG7fsaTci7...') #3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(453): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->getUniqueId() #4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(266): Shopware_Controllers_Backend_SwagUpdate->getUnique() #5 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagUpdate->popupAction() #6 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('popupAction') #7 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #9 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #10 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #11 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #12 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #13 /is/htdocs/wp1061229_47VO1MQRUV/www/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} [] {"uid":"66eda27"} ``` Wenn uns jemanden hierzu Tipps, Information geben würde woran das liegen könnte, wäre das super. Vielen Dank im Voraus Grüße Mark ---
**Author:** ![JanineOverhausKocan](https://avatars.discourse-cdn.com/v4/letter/j/65b543/32.png) [@JanineOverhausKocan](https://forum.shopware.com/u/JanineOverhausKocan)\ **Post date:** [14. Februar 2017 um 14:53 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708/2 "2017-02-14T14:53:59Z")
Hallo, hier scheint ein Element in der Datenbank zu fehlen, dieses könntest du über das folgende Query in der Datenbank anlegen: ``` INSERT INTO `s_core_config_elements` (`id`, `form_id`, `name`, `value`, `label`, `description`, `type`, `required`, `position`, `scope`, `options`) VALUES ('966', '269', 'trackingUniqueId', 's:0:"";', 'Unique identifier', NULL, 'text', '0', '0', '0', 0x613a313a7b733a363a2268696464656e223b623a313b7d); ``` Viele Grüße aus Schöppingen Janine ---
**Author:** ![hamaca](https://avatars.discourse-cdn.com/v4/letter/h/54ee81/32.png) [@hamaca](https://forum.shopware.com/u/hamaca)\ **Post date:** [14. Februar 2017 um 15:36 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708/3 "2017-02-14T15:36:40Z")
Hallo Janine, vielen Dank, werde ich gleich nachher probieren. Warum diese? ``` 0x613a313a7b733a363a2268696464656e223b623a313b7d ``` Weißt du eigentlich wie es mal vorkommen kann, dass scheinbar manchmal neue Tabellen nicht während eines ansonsten erfolgreichen Updates in der DB integriert werden? Viele Grüße Mark ---
**Author:** ![hamaca](https://avatars.discourse-cdn.com/v4/letter/h/54ee81/32.png) [@hamaca](https://forum.shopware.com/u/hamaca)\ **Post date:** [15. Februar 2017 um 21:22 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708/4 "2017-02-15T21:22:51Z")
Query erfolgreich angelegt erstmal in einer Version die wir zum Testen haben - alles super. Im Live Version ausgeführt und bekommen statt „communication failure“ einer 503 und folgende Fehler Meldung: ``` PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165\nStack trace:\n#0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement-]execute(Array)\n#1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/DBALConfigReader.php(85): Doctrine\\DBAL\\Statement-]execute(Array)\n#2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/CachedConfigReader.php(66): Shopware\\Components\\Plugin\\DBALConfigReader-]getByPluginName('SwagPaymentPayp...', NULL)\n#3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/Namespace.php(182): Shopware\\Components\\Plugin\\CachedConfigReader-]getByPluginName('SwagPaymentPayp...', NULL)\n#4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/Bootstrap.php(253): Shopware_Components_Plugin_Namespace-]getConfig('SwagPaymentPayp...')\n#5 /is/htdocs/wp1061229_4 in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php:330\nStack trace:\n#0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php(330): PDOStatement-]execute()\n#1 [internal function]: Symfony\\Component\\HttpFoundation\\Session\\Storage\\Handler\\PdoSessionHandler-]write('fcnhpckmr5dgh7a...', 'ShopwareBackend...')\n#2 [internal function]: session_write_close()\n#3 {main}\n thrown in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php on line 330 ``` Irgendwelche Ideen was das jetzt bedeutet und behoben werden könnte? Vielen Dank im Voraus Mark ---
**Author:** ![TimmeHosting](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/timmehosting/32/15580_2.png) [@TimmeHosting](https://forum.shopware.com/u/TimmeHosting)\ **Post date:** [15. Februar 2017 um 21:57 UTC](https://forum.shopware.com/t/softwareaktualisierung-voraussetzungen-laden-nicht-5-2-16-gt-5-2-17-system-log-fehler/43708/5 "2017-02-15T21:57:37Z")
Sieht so aus, als ob der MySQL-Server nicht stabil läuft: ``` 2006 MySQL server has gone away ``` Das solltest Du mal prüfen (ggf. auch anhand der MySQL-Logs, sofern Du darauf Zugriff hast). ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/385eaa628505df573ebf33722f780335f53ac1b2.png) Timme Hosting - schnelles nginx-Hosting [www.timmehosting.de](https://timmehosting.de/)