# Wiederkehrende Fehlermeldung **URL:** \ **Category:** Allgemein\ **Created:** [21. Mai 2015 um 20:04 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495 "2015-05-21T20:04:11Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Urs\_Landis](https://avatars.discourse-cdn.com/v4/letter/u/3be4f8/32.png) [@Urs\_Landis](https://forum.shopware.com/u/Urs_Landis)\ **Post date:** [21. Mai 2015 um 20:04 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495/1 "2015-05-21T20:04:11Z")
Ich erhalte den ganzen Tag immer wieder diese Fehlermeldung, was möchte die mir gerne sagen? Message: exception ‘Doctrine\DBAL\DBALException’ with message ‘LIMIT argument offset=-24 is not valid’ in /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:2834 Stack trace: #0 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(1029): Doctrine\DBAL\Platforms\AbstractPlatform-\>modifyLimitQuery(‘SELECT SQL\_CALC…’, ‘24’, -24) #1 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(239): Doctrine\DBAL\Query\QueryBuilder-\>getSQLForSelect() #2 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(204): Doctrine\DBAL\Query\QueryBuilder-\>getSQL() #3 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(117): Doctrine\DBAL\Query\QueryBuilder-\>execute() #4 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(95): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>getProducts(Object(Shopware\Bundle\SearchBundleDBAL\QueryBuilder)) #5 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(68): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ProductContext)) #6 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Controllers/Frontend/Search.php(75): Shopware\Bundle\SearchBundle\ProductSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ProductContext)) #7 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Search-\>defaultSearchAction() #8 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch(‘defaultSearchAc…’) #9 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Library/Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #11 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(447): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(347): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vhosts/aquariumshop.ch/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(211): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/vhosts/aquariumshop.ch/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /var/www/vhosts/aquariumshop.ch/httpdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} Time: 2015-05-21T20:01:22.633714+0200 Channel: core request: { “uri”: “/search/index/sSearch/pro/sFilter\_category/379/sPerPage/24/sPage/”, “method”: “GET”, “query”: { “module”: “frontend”, “controller”: “search”, “action”: “index”, “sSearch”: “pro”, “sFilter\_category”: “379”, “sPerPage”: “24”, “sPage”: “” }, “post”: } session: { “sessionId”: “fc50f740468a70ec4f3d2bc5446bb7953f438c04”, “Bot”: true, “sOutputNet”: false, “sArea”: null, “sCountry”: null, “sState”: null } shopId: Grüsse Urs ---
**Author:** ![Urs\_Landis](https://avatars.discourse-cdn.com/v4/letter/u/3be4f8/32.png) [@Urs\_Landis](https://forum.shopware.com/u/Urs_Landis)\ **Post date:** [21. Mai 2015 um 21:57 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495/2 "2015-05-21T21:57:58Z")
gelöscht-falscher Fred… ---
**Author:** ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)\ **Post date:** [21. Mai 2015 um 22:12 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495/3 "2015-05-21T22:12:55Z")
Hi, das sieht irgendwie danach aus, als würde einfach ein Bot auf deiner Seite due Suche ausführen und dort filtern Komisch sieht das Limit -24 aus Schau mal in deine Konfiguration zur Suche Sebastian ---
**Author:** ![Urs\_Landis](https://avatars.discourse-cdn.com/v4/letter/u/3be4f8/32.png) [@Urs\_Landis](https://forum.shopware.com/u/Urs_Landis)\ **Post date:** [22. Mai 2015 um 08:49 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495/4 "2015-05-22T08:49:44Z")
Guten Morgen Da kann man ja nicht viel einstellen… Das Ereignis pro Seite steht auf 24. Grüsse Urs ---
**Author:** ![hoffcasa](https://avatars.discourse-cdn.com/v4/letter/h/67e7ee/32.png) [@hoffcasa](https://forum.shopware.com/u/hoffcasa)\ **Post date:** [2. November 2018 um 17:23 UTC](https://forum.shopware.com/t/wiederkehrende-fehlermeldung/27495/5 "2018-11-02T17:23:33Z")
Gleicher Fehler hier, wie wurde das Problem gelöst? [2018-11-02 18:09:59] core.CRITICAL: LIMIT argument offset=-24 is not valid {“uid”:“3591b42”} [2018-11-02 18:09:59] core.CRITICAL: LIMIT argument offset=-24 is not valid {“uid”:“3591b42”} [2018-11-02 18:09:59] core.ERROR: Doctrine\DBAL\DBALException: LIMIT argument offset=-24 is not valid in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:3318 Stack trace: #0 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(1122): Doctrine\DBAL\Platforms\AbstractPlatform-\>modifyLimitQuery(‘SELECT SQL\_CALC…’, 12, -24) #1 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(244): Doctrine\DBAL\Query\QueryBuilder-\>getSQLForSelect() #2 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Query\QueryBuilder-\>getSQL() #3 /html/shopware/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(113): Doctrine\DBAL\Query\QueryBuilder-\>execute() #4 /html/shopware/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(93): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>getProducts(Object(Shopware\Bundle\SearchBundleDBAL\QueryBuilder)) #5 /html/shopware/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(65): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #6 /html/shopware/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(63): Shopware\Bundle\SearchBundle\ProductSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #7 /html/shopware/engine/Shopware/Core/sArticles.php(2397): Shopware\Bundle\SearchBundle\VariantSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #8 /html/shopware/engine/Shopware/Core/sArticles.php(460): sArticles-\>getListing(‘184’, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext), Object(Enlight\_Controller\_Request\_RequestHttp), Object(Shopware\Bundle\SearchBundle\Criteria)) #9 /html/shopware/engine/Shopware/Controllers/Frontend/Listing.php(551): sArticles-\>sGetArticlesByCategory(‘184’, Object(Shopware\Bundle\SearchBundle\Criteria)) #10 /html/shopware/engine/Shopware/Controllers/Frontend/Listing.php(84): Shopware\_Controllers\_Frontend\_Listing-\>loadCategoryListing(‘184’, Array) #11 /html/shopware/engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Frontend\_Listing-\>indexAction() #12 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch(‘indexAction’) #13 /html/shopware/engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #14 /html/shopware/engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(443): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(339): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(205): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /html/shopware/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main} {“uid”:“3591b42”}