Moin, bekomme seit kurzem ständig die folgende Fehlermeldung: exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘Shopware_CronJob_ClearHttpCache’ for key ‘action’’ in /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘UPDATE s_cront...', Array) #4 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract-\>query('UPDATE s_cront…’, Array) #5 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(635): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‘UPDATE s_cront...', Array) #6 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Table/Abstract.php(1133): Zend_Db_Adapter_Abstract-\>update('s_crontab', Array, Array) #7 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Adapter/DbTable.php(153): Zend_Db_Table_Abstract-\>update(Array, Array) #8 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Manager.php(119): Enlight_Components_Cron_Adapter_DbTable-\>updateJob(Object(Enlight_Components_Cron_Job)) #9 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Manager.php(238): Enlight_Components_Cron_Manager-\>disableJob(Object(Enlight_Components_Cron_Job)) #10 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(60): Enlight_Components_Cron_Manager-\>runJob(Object(Enlight_Components_Cron_Job)) #11 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Cron-\>indexAction() #12 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action-\>dispatch('indexAction') #13 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default-\>dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 /var/www/web1/htdocs/shop/engine/Shopware/Kernel.php(141): Enlight_Controller_Front-\>dispatch() #15 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /var/www/web1/htdocs/shop/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main} Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Shopware_CronJob_ClearHttpCache' for key 'action'' in /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo-\>_execute(Array) #1 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement-\>execute(Array) #2 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-\>query('UPDATE s_cront…’, Array) #3 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(‘UPDATE s_cront...', Array) #4 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Adapter/Abstract.php(635): Enlight_Components_Db_Adapter_Pdo_Mysql-\>query('UPDATE s_cront…’, Array) #5 /var/www/web1/htdocs/shop/engine/Library/Zend/Db/Table/Abstract.php(1133): Zend_Db_Adapter_Abstract->update(‘s_crontab’, Array, Array) #6 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Adapter/DbTable.php(153): Zend_Db_Table_Abstract->update(Array, Array) #7 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Manager.php(119): Enlight_Components_Cron_Adapter_DbTable->updateJob(Object(Enlight_Components_Cron_Job)) #8 /var/www/web1/htdocs/shop/engine/Library/Enlight/Components/Cron/Manager.php(238): Enlight_Components_Cron_Manager->disableJob(Object(Enlight_Components_Cron_Job)) #9 /var/www/web1/htdocs/shop/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(60): Enlight_Components_Cron_Manager->runJob(Object(Enlight_Components_Cron_Job)) #10 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Cron->indexAction() #11 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‘indexAction’) #12 /var/www/web1/htdocs/shop/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /var/www/web1/htdocs/shop/engine/Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #14 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/web1/htdocs/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/web1/htdocs/shop/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /var/www/web1/htdocs/shop/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} Time: 2014-10-10T15:55:08.303752+0200 Channel: core request: { “uri”: “/backend/cron”, “method”: “GET”, “query”: { “module”: “backend”, “controller”: “cron” }, “post”: } session: No session data available shop: No shop data available kann ich nicht wirklich was mit anfangen, jemand eine Idee Danke für Tipps
Hallo, schau mal in den Einstellungen > Grundeinstellungen > System > Cronjobs ob es zwei Einträge für den Cronjob “HTTP Cache löschen” gibt. Einen von beiden Einträgen kannst du dann löschen. Die Fehlermeldung besagt ja relativ eindeutig, dass es einen doppelten Eintrag für den Cronjob mit der Aktion “'Shopware_CronJob_ClearHttpCache” gibt. Viele Grüße Moritz
1 „Gefällt mir“
hmm, komischerweise hatte ich den Eintrag doppelt, hab jetzt mal einen deaktiviert. Frag mich nur wo das herkam…
Hallo, ich bin mir hier nicht sicher, ob das Deaktivieren reicht, sollte der Fehler weiterhin auftreten, so musst du einen von beiden löschen. Grüße Moritz
danke, momentan tauchen keine Fehlermeldungen mehr auf. Werde es beobachten und falls der Fehler wieder auftritt den Eintrag löschen.