Fehler: 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Hallo zusammen,

ich bekomme am laufenden Band Emails (Shopware Version 5.2.8) an meine Admin Email Adresse gesendet mit folgendem Inhalt:

exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘3-1-2017-08-21-desktop’ for key ‘articleId_2’’ in /var/www/vhosts/xxx.com/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165
Stack trace:
#0 /var/www/vhosts/xxx.com/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement->execute(NULL)
#1 /var/www/vhosts/xxx.com/xxx/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()
#2 /var/www/vhosts/xxx.com/xxx/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#3 /var/www/vhosts/xxx.com/xxx/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /var/www/vhosts/xxx.com/xxx/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /var/www/vhosts/xxx.com/xxx/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(320): Doctrine\ORM\EntityManager->flush()
#6 /var/www/vhosts/xxx.com/xxx/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(127): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshArticleImpression(Object(Enlight_Controller_Request_RequestHttp))
#7 /var/www/vhosts/xxx.com/xxx/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.com/xxx/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Index->refreshStatisticAction()
#9 /var/www/vhosts/xxx.com/xxx/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘refreshStatisti…’)
#10 /var/www/vhosts/xxx.com/xxx/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.com/xxx/engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch()
#12 /var/www/vhosts/xxx.com/xxx/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /var/www/vhosts/xxx.com/xxx/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.com/xxx/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /var/www/vhosts/xxx.com/xxx/engine/Shopware/Components/HttpCache/AppCache.php(107): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /var/www/vhosts/xxx.com/xxx/shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#17 {main}

Kann mir einer erklären, was das ist und an welcher Stelle ich das Problem angehen muss?

Vielen Dank

Sieht nach einem Fehler bei der Erfassung der Statistik zu - scheinbar werden Duplikate angelegt. Ich würde dir empfehlen zu prüfen, ob in der s_statistics das Auto Increment korrekt gesetzt ist.

Siehe:

#6 /var/www/vhosts/xxx.com/xxx/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(127): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshArticleImpression(Object(Enlight_Controller_Request_RequestHttp))