Nach Serverumzug und Shopwareupdate nur noch Probleme

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 

 

Bin mittlerweile wirklich am Verzeifeln. Vllt kann ja wer helfen

 

LG

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

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

@Tammo schrieb:

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

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

Nun alle durchgesehen. Alle mit AI :frowning:

Kannst Du den Export noch mal wiederholen?

Hattest Du diese Infos berücksichtigt? http://community.shopware.com/Shop-Transfer-Live-System-Testumgebung_detail_1309.html

@NextMike schrieb:

Kannst Du den Export noch mal wiederholen?

Hattest Du diese Infos berücksichtigt? 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 

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

@NextMike schrieb:

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

 ich sag ja… ist zum verzweifeln :wink:

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

Keine Ahnung ob das der richtige Ansatz ist: http://stackoverflow.com/questions/303994/log-all-queries-in-mysql