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
gelöscht-falscher Fred…
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
Guten Morgen Da kann man ja nicht viel einstellen… Das Ereignis pro Seite steht auf 24. Grüsse Urs
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”}