# Nach Serverumzug und Shopwareupdate nur noch Probleme

**URL:** <https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969>\
**Category:** Administration\
**Created:** [20. September 2016 um 12:28 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969 "2016-09-20T12:28:20Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tammo](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@Tammo](https://forum.shopware.com/u/Tammo)\
**Post date:** [20. September 2016 um 12:28 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/1 "2016-09-20T12:28:20Z")

</div>

Hallo,

irgendwie ist nach dem Update auf das neuste Shopware und dem Serverumzug nur noch der Wurm drin. Bekomme massig Errormails meist mit diesem Inhalt:

```
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\n ...', Array)
#4 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n ...', Array)
#5 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(245): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n ...', Array)
#6 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(125): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshLog(Object(Enlight_Controller_Request_RequestHttp))
#7 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Controllers/Widgets/Index.php(51): Shopware_Plugins_Frontend_Statistics_Bootstrap->updateLog(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#8 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Index->refreshStatisticAction()
#9 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('refreshStatisti...')
#10 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch()
#12 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /var/www/vhosts/XXX/httpdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/XXX/httpdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\n ...', Array)
#3 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n ...', Array)
#4 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(245): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n ...', Array)
#5 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(125): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshLog(Object(Enlight_Controller_Request_RequestHttp))
#6 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Controllers/Widgets/Index.php(51): Shopware_Plugins_Frontend_Statistics_Bootstrap->updateLog(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#7 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Index->refreshStatisticAction()
#8 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('refreshStatisti...')
#9 /var/www/vhosts/XXX/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#10 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch()
#11 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#12 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#13 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/XXX/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /var/www/vhosts/XXX/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /var/www/vhosts/XXX/httpdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 {main}

```

Außerdem kann ich keine Bestellung mehr selber ausführen für einen Kunden. Der Warenkorb bleibt leer. Wenn ich es mit dem Plugin Backend Orders versuche wirft er folgendes:

```
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. Type of association must be one of *_TO_ONE or MANY_TO_MANY in vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php on line 1028 Stack trace: #0 vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(1155): Doctrine\ORM\Query\SqlWalker->walkJoinAssociationDeclaration(Object(Doctrine\ORM\Query\AST\JoinAssociationDeclaration), 1, NULL) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(837): Doctrine\ORM\Query\SqlWalker->walkJoin(Object(Doctrine\ORM\Query\AST\Join)) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(815): Doctrine\ORM\Query\SqlWalker->walkIdentificationVariableDeclaration(Object(Doctrine\ORM\Query\AST\IdentificationVariableDeclaration)) #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(522): Doctrine\ORM\Query\SqlWalker->walkFromClause(Object(Doctrine\ORM\Query\AST\FromClause)) #4 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(42): Doctrine\ORM\Query\SqlWalker->walkSelectStatement(Object(Doctrine\ORM\Query\AST\SelectStatement)) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(277): Doctrine\ORM\Query\Exec\SingleSelectExecutor->__construct(Object(Doctrine\ORM\Query\AST\SelectStatement), Object(Doctrine\ORM\Query\SqlWalker)) Doctrine\ORM\AbstractQuery->execute(NULL, 2) #12 engine/Shopware/Models/Customer/AddressRepository.php(45): Doctrine\ORM\AbstractQuery->getResult(2) #13 custom/plugins/SwagBackendOrder/Components/CustomerRepository.php(57): Shopware\Models\Customer\AddressRepository->getListArray(873) #14 

```

&nbsp;

Bin mittlerweile wirklich am Verzeifeln. Vllt kann ja wer helfen

&nbsp;

LG

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [20. September 2016 um 12:30 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/2 "2016-09-20T12:30:43Z")

</div>

Sieht mir aus, als ob der Auto-Increment der Tabellen bei der Datenbankmigration nicht übernommen wurde. Das ist zwingend notwendig, damit die IDs fortlaufend hochgezählt werden

---

<div class="post-metadata">

**Author:** ![Tammo](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@Tammo](https://forum.shopware.com/u/Tammo)\
**Post date:** [20. September 2016 um 12:31 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/3 "2016-09-20T12:31:56Z")

</div>

Habe mindestes die hälfte der Tabellen durchgesehen. Dort wie die Primary ID immer AI

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [20. September 2016 um 14:50 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/4 "2016-09-20T14:50:24Z")

</div>

> [@Tammo schrieb:](https://forum.shopware.com/profile/23147/Tammo "Tammo")
> 
> Habe mindestes die hälfte der Tabellen durchgesehen. Dort wie die Primary ID immer AI

dann ist es die andere Hälfte 😉 😉 bzw. meist die letzte.

---

<div class="post-metadata">

**Author:** ![Tammo](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@Tammo](https://forum.shopware.com/u/Tammo)\
**Post date:** [20. September 2016 um 14:57 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/5 "2016-09-20T14:57:47Z")

</div>

Nun alle durchgesehen. Alle mit AI ☹

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [20. September 2016 um 15:05 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/6 "2016-09-20T15:05:42Z")

</div>

Kannst Du den Export noch mal wiederholen?

Hattest Du diese Infos berücksichtigt?&nbsp;[http://community.shopware.com/Shop-Transfer-Live-System-Testumgebung\_detail\_1309.html](http://community.shopware.com/Shop-Transfer-Live-System-Testumgebung_detail_1309.html)

---

<div class="post-metadata">

**Author:** ![Tammo](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@Tammo](https://forum.shopware.com/u/Tammo)\
**Post date:** [20. September 2016 um 15:11 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/7 "2016-09-20T15:11:03Z")

</div>

> [@NextMike schrieb:](https://forum.shopware.com/profile/19433/NextMike "NextMike")
> 
> Kannst Du den Export noch mal wiederholen?
> 
> Hattest Du diese Infos berücksichtigt?&nbsp;[http://community.shopware.com/Shop-Transfer-Live-System-Testumgebung\_detail\_1309.html](http://community.shopware.com/Shop-Transfer-Live-System-Testumgebung_detail_1309.html)

mittlerweile nicht mehr. aber habs auch mehrfach gemacht und alles gemacht wie in der Anleitung beschrieben&nbsp;

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [20. September 2016 um 15:13 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/8 "2016-09-20T15:13:39Z")

</div>

es ist natürlich klasse, dass man die Query nicht sieht ☹

---

<div class="post-metadata">

**Author:** ![Tammo](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@Tammo](https://forum.shopware.com/u/Tammo)\
**Post date:** [20. September 2016 um 15:17 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/9 "2016-09-20T15:17:34Z")

</div>

> [@NextMike schrieb:](https://forum.shopware.com/profile/19433/NextMike "NextMike")
> 
> es ist natürlich klasse, dass man die Query nicht

&nbsp;ich sag ja… ist zum verzweifeln 😉

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [20. September 2016 um 15:19 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/10 "2016-09-20T15:19:26Z")

</div>

Steht im&nbsp;Logfile evtl. mehr drin? Macht MySQL evtl. Logeinträge?

---

<div class="post-metadata">

**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\
**Post date:** [20. September 2016 um 15:20 UTC](https://forum.shopware.com/t/nach-serverumzug-und-shopwareupdate-nur-noch-probleme/39969/11 "2016-09-20T15:20:38Z")

</div>

Keine Ahnung ob das der richtige Ansatz ist:&nbsp;[http://stackoverflow.com/questions/303994/log-all-queries-in-mysql](http://stackoverflow.com/questions/303994/log-all-queries-in-mysql)