Komischer Fehler, wohl irgendwas mit der Statistik

Archive Shopware 3.5
1

Hi zusammen,

ein Kunde beschwerte sich soeben, dass er die Bestellung nicht abschließen konnte und prompt bekam ich auch folgendes
Stacktrace. Kann hier bittejemandhelfen?

Vielen Dank und viele Grüße,

Chris

exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '454-1-2016-03-03' for key 'articleId_2'' in /home/www/p123341/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165
Stack trace:
#0 /home/www/p123341/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement->execute(NULL)
#1 /home/www/p123341/html/shopware/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute()
#2 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(952): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts()
#3 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /home/www/p123341/html/shopware/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(320): Doctrine\ORM\EntityManager->flush()
#6 /home/www/p123341/html/shopware/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(156): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshArticleImpression(Object(Enlight_Controller_Request_RequestHttp))
#7 /home/www/p123341/html/shopware/engine/Shopware/Controllers/Widgets/Index.php(62): Shopware_Plugins_Frontend_Statistics_Bootstrap->updateLog(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#8 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Index->refreshStatisticAction()
#9 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch('refreshStatisti...')
#10 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 /home/www/p123341/html/shopware/engine/Shopware/Kernel.php(145): Enlight_Controller_Front->dispatch()
#12 /home/www/p123341/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /home/www/p123341/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /home/www/p123341/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(242): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /home/www/p123341/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(106): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /home/www/p123341/html/shopware/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#17 {main}

Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'INSERT INTO s_statistics_article_impression (date, articleId, shopId, impressions) VALUES (?, ?, ?, ?)' with params ["2016-03-03", "454", 1, 1]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '454-1-2016-03-03' for key 'articleId_2'' in /home/www/p123341/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91
Stack trace:
#0 /home/www/p123341/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(167): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO s_s...', Array)
#1 /home/www/p123341/html/shopware/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute()
#2 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(952): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts()
#3 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /home/www/p123341/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /home/www/p123341/html/shopware/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(320): Doctrine\ORM\EntityManager->flush()
#6 /home/www/p123341/html/shopware/engine/Shopware/Plugins/Default/Frontend/Statistics/Bootstrap.php(156): Shopware_Plugins_Frontend_Statistics_Bootstrap->refreshArticleImpression(Object(Enlight_Controller_Request_RequestHttp))
#7 /home/www/p123341/html/shopware/engine/Shopware/Controllers/Widgets/Index.php(62): Shopware_Plugins_Frontend_Statistics_Bootstrap->updateLog(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#8 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Widgets_Index->refreshStatisticAction()
#9 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch('refreshStatisti...')
#10 /home/www/p123341/html/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 /home/www/p123341/html/shopware/engine/Shopware/Kernel.php(145): Enlight_Controller_Front->dispatch()
#12 /home/www/p123341/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /home/www/p123341/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /home/www/p123341/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(242): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /home/www/p123341/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(106): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /home/www/p123341/html/shopware/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#17 {main}

Time: 	

2016-03-03T13:03:57.096588+0100

Channel: 	

core

request: 	

{
    "uri": "/widgets/index/refreshStatistic?requestPage=/damen/alltagsstruempfe/perlmuttglanz-feinstrumpfhose.html&requestController=detail&session-1=i9al5ku3459qs37ddhu12at3u5&articleId=454&callback=jQuery19109969800426624715_1457006679206&_=1457006679207",
    "method": "GET",
    "query": {
        "requestPage": "/damen/alltagsstruempfe/perlmuttglanz-feinstrumpfhose.html",
        "requestController": "detail",
        "session-1": "i9al5ku3459qs37ddhu12at3u5",
        "articleId": "454",
        "callback": "jQuery19109969800426624715_1457006679206",
        "_": "1457006679207",
        "module": "widgets",
        "controller": "index",
        "action": "refreshStatistic"
    },
    "post": []
}

session: 	

{
    "sRegister": {
        "billing": {
            "country": 2
        }
    },
    "sCountry": 2,
    "sState": null,
    "sessionId": "i9al5ku3459qs37ddhu12at3u5",
    "sPaymentID": 7,
    "sBasketCurrency": 1,
    "sBasketQuantity": "5",
    "sBasketAmount": "45.2700",
    "sOrderVariables": null,
    "sOutputNet": false,
    "Bot": false,
    "sUserId": null,
    "sArea": 1,
    "sLastArticle": null,
    "sDispatch": null
}

shopId: 	

1

shopName: 	

Hauptshop Deutsch

 

2

HI Chris,

die Meldung sollte nichts mit der Bestellung zu tun haben. Die Meldung kommt nämlich aus einem Ajax-Request. (/widgets/index/refreshStatistic)
Kannst du den das Problem mit der Bestellung nachstellen?

Gruß Heiner

3

Ich Danke Dir! Hmm, habe auch mehrere Testbestellungen durchgeführt und es gab keinerlei Schwierigkeiten.

Der Kunde schrieb hierzu folgendes:

 Guten Tag Habe soeben ein Konto eingerichtet und wollte meine Bestellung abfertigen. Nach den "kostenpflichtigen Bestellen" erhalte ich die info: "Es ist ein Problem aufgetreten und die Bestellung konnte nicht abgeschlossen werden. Bitte kontaktieren Sie den Shopbetreiber. "
4

Der Fehler hat an dem Warenkorb Caching Modul von Heiner gelegen, da die Beträge der Artikel dann plötzlich brutto waren und somit die Checksum in PayPal nicht mehr stimme.

Somit closed! Dankeschön!