# Cronjob Problem article comment

**URL:** <https://forum.shopware.com/t/cronjob-problem-article-comment/6603>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [23. März 2012 um 16:46 UTC](https://forum.shopware.com/t/cronjob-problem-article-comment/6603 "2012-03-23T16:46:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KarinS](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@KarinS](https://forum.shopware.com/u/KarinS)\
**Post date:** [23. März 2012 um 16:46 UTC](https://forum.shopware.com/t/cronjob-problem-article-comment/6603/1 "2012-03-23T16:46:57Z")

</div>

Hi, aktuell gibt es ein Problem mit dem article-comment cronjob. Der wurde seit 17. Februrar nicht mehr ausgeführt. Wenn man im Backend unter den GRundeisntellungen die Details des Cronjobs betrachtet, ergibt sich unter dem Feld „Data“ folgende SQL-Fehlermeldung: [quote]Array ( [error] =\> exception ‚PDOException‘ with message ‚SQLSTATE[42000]: Syntax error or access violation: 1104 Die Ausführung des SELECT würde zu viele Datensätze untersuchen und wahrscheinlich sehr lange dauern. Bitte WHERE-Klausel überprüfen und gegebenenfalls SET SQL\_BIG\_SELECTS=1 oder SET SQL\_MAX\_JOIN\_SIZE=# verwenden‘ in /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php(228): PDOStatement-\>execute(Array) #1 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #3 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query(’???SELECT???..’, Array) #4 /home/.sites/754/site93/web/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(’???SELECT???..’, Array) #5 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(734): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(’???SELECT???..’, Array) #6 /home/.sites/754/site93/web/engine/Enlight/Enlight/Components/Adodb.php(226): Zend\_Db\_Adapter\_Abstract-\>fetchAll(’???SELECT???..’, Array) #7 /home/.sites/754/site93/web/engine/connectors/api/export/shopware.php(730): Enlight\_Components\_Adodb-\>GetAll(’???SELECT???..’) #8 /home/.sites/754/site93/web/engine/Shopware/Plugins/Default/Core/CronRating/Bootstrap.php(53): sShopwareExport-\>sOrderCustomers(Array) #9 /home/.sites/754/site93/web/engine/Enlight/Enlight/Event/EventHandler.php(60): Shopware\_Plugins\_Core\_CronRating\_Bootstrap::onRun(Object(Shopware\_Components\_Cron\_CronJob)) #10 /home/.sites/754/site93/web/engine/Enlight/Enlight/Event/EventManager.php(96): Enlight\_Event\_EventHandler-\>execute(‚Shopware\_Plugin…‘, Object(Shopware\_Components\_Cron\_CronJob)) #11 /home/.sites/754/site93/web/engine/Shopware/Components/Cron/CronManager.php(51): Enlight\_Event\_EventManager-\>notifyUntil(Object(Shopware\_Components\_Cron\_CronJob)) #12 /home/.sites/754/site93/web/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(16): Shopware\_Components\_Cron\_CronManager-\>runCronJob(‚Shopware\_CronJo…‘, Object(Shopware\_Components\_Cron\_CronJob)) #13 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Cron-\>indexAction(Object(Shopware\_Components\_Cron\_CronJob)) #14 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch() #15 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(‚indexAction‘) #16 /home/.sites/754/site93/web/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #17 /home/.sites/754/site93/web/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #18 /home/.sites/754/site93/web/shopware.php(6): Enlight\_Application-\>run() #19 {main} Next exception ‚Zend\_Db\_Statement\_Exception‘ with message ‚SQLSTATE[42000]: Syntax error or access violation: 1104 Die Ausführung des SELECT würde zu viele Datensätze untersuchen und wahrscheinlich sehr lange dauern. Bitte WHERE-Klausel überprüfen und gegebenenfalls SET SQL\_BIG\_SELECTS=1 oder SET SQL\_MAX\_JOIN\_SIZE=# verwenden‘ in /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query(’???SELECT???..’, Array) #3 /home/.sites/754/site93/web/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(’???SELECT???..’, Array) #4 /home/.sites/754/site93/web/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(734): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(’???SELECT???..’, Array) #5 /home/.sites/754/site93/web/engine/Enlight/Enlight/Components/Adodb.php(226): Zend\_Db\_Adapter\_Abstract-\>fetchAll(’???SELECT???..’, Array) #6 /home/.sites/754/site93/web/engine/connectors/api/export/shopware.php(730): Enlight\_Components\_Adodb-\>GetAll(’???SELECT???..’) #7 /home/.sites/754/site93/web/engine/Shopware/Plugins/Default/Core/CronRating/Bootstrap.php(53): sShopwareExport-\>sOrderCustomers(Array) #8 /home/.sites/754/site93/web/engine/Enlight/Enlight/Event/EventHandler.php(60): Shopware\_Plugins\_Core\_CronRating\_Bootstrap::onRun(Object(Shopware\_Components\_Cron\_CronJob)) #9 /home/.sites/754/site93/web/engine/Enlight/Enlight/Event/EventManager.php(96): Enlight\_Event\_EventHandler-\>execute(‚Shopware\_Plugin…‘, Object(Shopware\_Components\_Cron\_CronJob)) #10 /home/.sites/754/site93/web/engine/Shopware/Components/Cron/CronManager.php(51): Enlight\_Event\_EventManager-\>notifyUntil(Object(Shopware\_Components\_Cron\_CronJob)) #11 /home/.sites/754/site93/web/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(16): Shopware\_Components\_Cron\_CronManager-\>runCronJob(‚Shopware\_CronJo…‘, Object(Shopware\_Components\_Cron\_CronJob)) #12 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Cron-\>indexAction(Object(Shopware\_Components\_Cron\_CronJob)) #13 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch() #14 /home/.sites/754/site93/web/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(‚indexAction‘) #15 /home/.sites/754/site93/web/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #16 /home/.sites/754/site93/web/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #17 /home/.sites/754/site93/web/shopware.php(6): Enlight\_Application-\>run() #18 {main} ) [/quote] Um Hinweise zur Lösung des Problems wird gebeten. Vielen Dank

---

<div class="post-metadata">

**Author:** ![waldicom](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/waldicom/32/12881_2.png) [@waldicom](https://forum.shopware.com/u/waldicom)\
**Post date:** [23. März 2012 um 17:13 UTC](https://forum.shopware.com/t/cronjob-problem-article-comment/6603/2 "2012-03-23T17:13:44Z")

</div>

Vor paar Tagen ist im FAQ ein neuer Artikel erschienen, der anscheinen genau dieses Thema behndelt: [http://wiki.shopware.de/shopware.php?sV … rticle=785](http://wiki.shopware.de/shopware.php?sViewport=detail&sArticle=785)

---

<div class="post-metadata">

**Author:** ![KarinS](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@KarinS](https://forum.shopware.com/u/KarinS)\
**Post date:** [23. März 2012 um 17:59 UTC](https://forum.shopware.com/t/cronjob-problem-article-comment/6603/3 "2012-03-23T17:59:41Z")

</div>

Hi, danke für die Antwort, aber die Application.php sieht haargenau so aus, wie im Beitrag beschrieben. Vermutlich wurde dies schon mit dem Update direkt mit geändert, weil eine manuelle Abänderung der Datei nicht erfolgt ist