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