# Fehlermeldung 'LIMIT argument count=0 is not valid' in 4.2.2
**URL:** https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978
**Category:** Shopware 3.5
**Tags:** administration
**Created:** [29. April 2014 um 08:17 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978 "2014-04-29T08:17:42Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@aschulle](https://forum.shopware.com/u/aschulle)
#### Post date: [29. April 2014 um 08:17 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978/1 "2014-04-29T08:17:42Z")
Hallo Forum, ich habe gerade einen neuen Shop mit Version 4.2.2 produktiv gesetzt und erhalte nun sporadisch aber doch mehrfach am Tag folgende Fehlermeldungen: `[2014-04-29 00:13:41] core.ERROR: exception 'Zend\_Db\_Adapter\_Exception' with message 'LIMIT argument count=0 is not valid' in /home/tschulz/websites/shopware/engine/Library/Zend/Db/Adapter/Pdo/Mysql.php:252 Stack trace: #0 /home/tschulz/websites/shopware/engine/Shopware/Controllers/Widgets/Emotion.php(524): Zend\_Db\_Adapter\_Pdo\_Mysql-\>limit('\n SE...', 0, 0) #1 /home/tschulz/websites/shopware/engine/Shopware/Controllers/Widgets/Emotion.php(105): Shopware\_Controllers\_Widgets\_Emotion-\>getProductNewcomer(0, 0, 0) #2 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Widgets\_Emotion-\>emotionNewcomerAction() #3 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('emotionNewcomer...') #4 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_ RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #5 /home/tschulz/websites/shopware/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #6 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #7 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #8 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #9 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfo ny\Component\HttpFoundation\Request), true) #10 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #11 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #12 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /home/tschulz/websites/shopware/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} [] [] ` oder auch `[2014-04-28 19:10:32] core.ERROR: exception 'Zend\_Db\_Adapter\_Exception' with message 'LIMIT argument count=0 is not valid' in /home/tschulz/websites/shopware/engine/Library/Zend/Db/Adapter/Pdo/Mysql.php:252 Stack trace: #0 /home/tschulz/websites/shopware/engine/Shopware/Controllers/Widgets/Emotion.php(575): Zend\_Db\_Adapter\_Pdo\_Mysql-\>limit('\n SE...', 0, 0) #1 /home/tschulz/websites/shopware/engine/Shopware/Controllers/Widgets/Emotion.php(78): Shopware\_Controllers\_Widgets\_Emotion-\>getProductTopSeller(0, 0, 0) #2 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Widgets\_Emotion-\>emotionTopSellerAction() #3 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('emotionTopSelle...') #4 /home/tschulz/websites/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request \_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #5 /home/tschulz/websites/shopware/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #6 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #7 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #8 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #9 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symf ony\Component\HttpFoundation\Request), true) #10 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #11 /home/tschulz/websites/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #12 /home/tschulz/websites/shopware/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /home/tschulz/websites/shopware/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} [] [] ` Leider konnte ich den Fehler bisher nicht reproduzieren. Vielleicht hat jemand eine Idee. Vielen Dank. Alex
---
### Author:  [@aschulle](https://forum.shopware.com/u/aschulle)
#### Post date: [30. April 2014 um 16:08 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978/2 "2014-04-30T16:08:37Z")
Ich habe jetzt einen Hinweis auf die Fehlerursache gefunden. Google weist in den Webmaster Tools zwei URLs als fehlerhaft aus. Dieses sind widgets/emotion/emotionNewcomer und widgets/emotion/emotionTopSeller Aus der Startseite habe ich zwei Artikel Slyder, welche zu diesen URLs gehören. Hier ein Beispiel für den einen: `(function($) { $(document).ready(function() { ; var config = { 'url': '/widgets/emotion/emotionTopSeller', 'title': "Topseller", 'headline': true, 'scrollSpeed': ~~(1 \* '500'), 'rotateSpeed':~~(1 \* '5000'), 'rotate': false, 'layout': 'horizontal', 'showNumbers': true, 'navigation': false, 'showArrows': true, 'scrollWidth': ~~(1 \* '998'), 'scrollHeight':~~(1 \* '360'), 'skipInitalRendering': true, 'maxPages': ~~(1 \* '6'), 'extraParams': { 'category':~~(1 \* '3'), 'start': 0, 'limit': ~~(1 \* '4'), 'elementWidth':~~(1 \* '998'), 'elementHeight': ~~(1 \* '319'), 'max':~~(1 \* '25') } };` Google findet nun offensichtlich diese url und ruft sie direkt auf. Das führt dann zu dem Fehler im Shop. Ich frage mich nun, was man dagegen tun kann? Über Hinweise würde ich mich sehr freuen. Alex
---
### Author:  [@dampftick](https://forum.shopware.com/u/dampftick)
#### Post date: [15. Mai 2014 um 12:13 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978/3 "2014-05-15T12:13:02Z")
Hallo, wir haben den selben Fehler. Gibt es schon einen Lösungsansatz? Gruß
---
### Author:  [@aschulle](https://forum.shopware.com/u/aschulle)
#### Post date: [15. Mai 2014 um 13:19 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978/4 "2014-05-15T13:19:13Z")
Hallo, ich habe die URLs mittel robots.txt für Suchmaschinen gesperrt. Scheint zu funktionieren, da ich seither keine Fehlermeldungen mehr erhalten habe. Eine echte Lösung ist das natürlich nicht. Viele Grüße Alex
---
### Author:  [@Benjamin\_Cremer](https://forum.shopware.com/u/Benjamin_Cremer)
#### Post date: [22. Juli 2014 um 08:49 UTC](https://forum.shopware.com/t/fehlermeldung-limit-argument-count-0-is-not-valid-in-4-2-2/19978/5 "2014-07-22T08:49:29Z")
Hallo Zusammen, der Fehler wird bei uns unter [http://jira.shopware.de/?ticket=SW-8817](http://jira.shopware.de/?ticket=SW-8817) geführt und wird momentan bearbeitet. Viele Grüße, Bejamin Cremer :shopware: