Ich bin von Shopware 4 auf 5 gewechselt und erhalte ständig diese lästige Fehlermeldung. Ich weiß leider nicht wie ich das wegbeomme bzw. warum ständig diese Meldung ausgespuckt wird. ERROR Message: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Shopware\_CronJob\_ClearHttpCache' for key 'action'' in /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855 Stack trace: #0 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): PDOStatement-\>execute() #1 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(535): Doctrine\DBAL\Connection-\>executeUpdate('UPDATE s\_cronta...', Array, Array) #2 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Adapter/DBAL.php(77): Doctrine\DBAL\Connection-\>update('s\_crontab', Array, Array) #3 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Manager.php(124): Enlight\_Components\_Cron\_Adapter\_DBAL-\>updateJob(Object(Enlight\_Components\_Cron\_Job)) #4 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Manager.php(254): Enlight\_Components\_Cron\_Manager-\>disableJob(Object(Enlight\_Components\_Cron\_Job)) #5 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(51): Enlight\_Components\_Cron\_Manager-\>runJob(Object(Enlight\_Components\_Cron\_Job)) #6 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Cron-\>indexAction() #7 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch('indexAction') #8 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #10 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vhosts/palmapalmetto.com/httpdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'UPDATE s\_crontab SET action = ?, `interval` = ?, data = ?, active = ?, next = ?, start = ?, end = ? WHERE id = ?' with params ["Shopware\_CronJob\_ClearHttpCache", 86400, "a:1:{s:5:\"error\";s:416:\"An exception occurred while executing 'UPDATE s\_crontab SET action = ?, `interval` = ?, data = ?, active = ?, next = ?, start = ?, end = ? WHERE id = ?' with params [\"Shopware\_CronJob\_ClearHttpCache\", 86400, \"b:0;\", \"1\", \"2015-09-05 20:55:14\", \"2015-09-07 10:46:02\", \"2015-05-09 20:55:14\", 19]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Shopware\_CronJob\_ClearHttpCache' for key 'action'\";}", "0", "2015-09-05 20:55:14", "2015-09-07 10:46:02", "2015-05-09 20:55:14", 19]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Shopware\_CronJob\_ClearHttpCache' for key 'action'' in /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91Stack trace: #0 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(864): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'UPDATE s\_cronta...', Array) #1 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(535): Doctrine\DBAL\Connection-\>executeUpdate('UPDATE s\_cronta...', Array, Array) #2 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Adapter/DBAL.php(77): Doctrine\DBAL\Connection-\>update('s\_crontab', Array, Array) #3 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Manager.php(124): Enlight\_Components\_Cron\_Adapter\_DBAL-\>updateJob(Object(Enlight\_Components\_Cron\_Job)) #4 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Components/Cron/Manager.php(254): Enlight\_Components\_Cron\_Manager-\>disableJob(Object(Enlight\_Components\_Cron\_Job)) #5 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(51): Enlight\_Components\_Cron\_Manager-\>runJob(Object(Enlight\_Components\_Cron\_Job)) #6 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Cron-\>indexAction() #7 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch('indexAction') #8 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Library/Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #10 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /var/www/vhosts/palmapalmetto.com/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /var/www/vhosts/palmapalmetto.com/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vhosts/palmapalmetto.com/httpdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main} Time: 2015-09-07T10:46:02.314843+0200 Channel: core request: { "uri": "/backend/cron", "method": "GET", "query": { "module": "backend", "controller": "cron", "action": "index" }, "post": [] } session: No session data available shop: No shop data available kann mir jemand bitte weiterhelfen?
Hallo, schau mal unter Einstellungen > System > Cronjob. Da gibt es den Cronjob zum HTTP-Cache leeren doppelt. Einfach einen der beiden löschen. Moritz
1 „Gefällt mir“
Hallo, tatsächlic, der cronjob war doppelt. Ich habe jetzt einen gelöscht, falls der Fehler nochmals auftaucht melde ich mich nochmals und falls nicht ist das Problem damit gelost :thumbup: