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

**URL:** <https://forum.shopware.com/t/fehler-sqlstate-23000-integrity-constraint-violation-1062-duplicate-entry/47698>\
**Category:** Administration\
**Created:** [21. August 2017 um 10:42 UTC](https://forum.shopware.com/t/fehler-sqlstate-23000-integrity-constraint-violation-1062-duplicate-entry/47698 "2017-08-21T10:42:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jagu22](https://avatars.discourse-cdn.com/v4/letter/j/2acd7d/32.png) [@jagu22](https://forum.shopware.com/u/jagu22)\
**Post date:** [21. August 2017 um 10:42 UTC](https://forum.shopware.com/t/fehler-sqlstate-23000-integrity-constraint-violation-1062-duplicate-entry/47698/1 "2017-08-21T10:42:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AndreHerking](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/andreherking/32/7839_2.png) [@AndreHerking](https://forum.shopware.com/u/AndreHerking)\
**Post date:** [21. August 2017 um 17:49 UTC](https://forum.shopware.com/t/fehler-sqlstate-23000-integrity-constraint-violation-1062-duplicate-entry/47698/2 "2017-08-21T17:49:08Z")

</div>

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))

```

&nbsp;