# Error Varianten Filter **URL:** \ **Category:** Allgemein\ **Created:** [19. Juni 2018 um 19:03 UTC](https://forum.shopware.com/t/error-varianten-filter/53586 "2018-06-19T19:03:45Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![maximum3012](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@maximum3012](https://forum.shopware.com/u/maximum3012)\ **Post date:** [19. Juni 2018 um 19:03 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/1 "2018-06-19T19:03:45Z")
Hallo, beim auswählen des varianten Filters bekomme ich ich einen Fehler.  - Variante wird ausgewählt (Größe \> XS, S, M, usw.) - Die Anzahl der vorhandenen Varianten wird angezeit Beim bestätigen des Filters bekomme ich folgende Fehlermeldung   ``` An exception occurred while executing 'SELECT listing_price.cheapest_price FROM s_articles product INNER JOIN s_articles_details variant ON variant.articleID = product.id AND variant.active = 1 AND product.active = 1 INNER JOIN s_articles_categories_ro productCategory2 ON productCategory2.articleID = product.id AND productCategory2.categoryID IN (?) LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (?) INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id INNER JOIN s_article_configurator_option_relations options_1 ON variant.id = options_1.article_id AND (options_1.option_id = ?) LEFT JOIN (SELECT IFNULL(listing_price.`id`, onsale_listing_price.`id`) `id`,IFNULL(listing_price.`pricegroup`, onsale_listing_price.`pricegroup`) `pricegroup`,IFNULL(listing_price.`from`, onsale_listing_price.`from`) `from`,IFNULL(listing_price.`to`, onsale_listing_price.`to`) `to`,IFNULL(listing_price.`articleID`, onsale_listing_price.`articleID`) `articleID`,IFNULL(listing_price.`articledetailsID`, onsale_listing_price.`articledetailsID`) `articledetailsID`,IFNULL(listing_price.`price`, onsale_listing_price.`price`) `price`,IFNULL(listing_price.`pseudoprice`, onsale_listing_price.`pseudoprice`) `pseudoprice`,IFNULL(listing_price.`baseprice`, onsale_listing_price.`baseprice`) `baseprice`,IFNULL(listing_price.`percent`, onsale_listing_price.`percent`) `percent`, IFNULL(listing_price.cheapest_price, onsale_listing_price.cheapest_price) AS cheapest_price, IFNULL(listing_price.variant_id, onsale_listing_price.variant_id) AS variant_id, IFNULL(listing_price.different_price_count, onsale_listing_price.different_price_count) AS different_price_count, IFNULL(listing_price.product_id, onsale_listing_price.product_id) AS product_id FROM s_articles_details variant LEFT JOIN (SELECT prices.*, MIN(ROUND(prices.price * ((100 - IFNULL(priceGroup.discount, 0)) / 100) * (( (CASE tax.id WHEN 1 THEN 19 WHEN 4 THEN 7 END) + 100) / 100) * 1, 2)) AS cheapest_price, prices.articledetailsID AS variant_id, COUNT(DISTINCT price) as different_price_count, prices.articleID AS product_id FROM s_articles product INNER JOIN (SELECT defaultPrice.`id`,defaultPrice.`pricegroup`,defaultPrice.`from`,defaultPrice.`to`,defaultPrice.`articleID`,defaultPrice.`articledetailsID`,defaultPrice.`price`,defaultPrice.`pseudoprice`,defaultPrice.`baseprice`,defaultPrice.`percent` FROM s_articles_prices defaultPrice INNER JOIN s_articles_details details ON details.id = defaultPrice.articledetailsID WHERE (defaultPrice.pricegroup = ?) AND ((details.laststock * details.instock) >= (details.laststock * details.minpurchase))) prices ON product.id = prices.articleID INNER JOIN s_core_tax tax ON tax.id = product.taxID INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID AND variant.active = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY prices.articleID) listing_price ON listing_price.product_id = variant.articleId LEFT JOIN (SELECT prices.*, MAX(ROUND(prices.price * ((100 - IFNULL(priceGroup.discount, 0)) / 100) * (( (CASE tax.id WHEN 1 THEN 19 WHEN 4 THEN 7 END) + 100) / 100) * 1, 2)) AS cheapest_price, prices.articledetailsID AS variant_id, COUNT(DISTINCT price) as different_price_count, prices.articleID AS product_id FROM s_articles product INNER JOIN (SELECT defaultPrice.`id`,defaultPrice.`pricegroup`,defaultPrice.`from`,defaultPrice.`to`,defaultPrice.`articleID`,defaultPrice.`articledetailsID`,defaultPrice.`price`,defaultPrice.`pseudoprice`,defaultPrice.`baseprice`,defaultPrice.`percent` FROM s_articles_prices defaultPrice WHERE defaultPrice.pricegroup = ?) prices ON product.id = prices.articleID INNER JOIN s_core_tax tax ON tax.id = product.taxID INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID AND variant.active = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY prices.articleID) onsale_listing_price ON onsale_listing_price.product_id = variant.articleId) listing_price ON listing_price.product_id = variant.articleId WHERE (avoidCustomerGroup.articleID IS NULL) AND (variant.active = 1) GROUP BY product.id ORDER BY listing_price.cheapest_price ASC LIMIT 1 OFFSET 0' with params [13, 1, 1, "EK", 1, "EK", 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'listing_price.articleID' in 'field list' in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT listing_...', Array) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT listing_...', Array, Array) #2 engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(118): Doctrine\DBAL\Query\QueryBuilder->execute() #3 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(175): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->generatePartialFacet(Object(Shopware\Bundle\SearchBundle\Facet\PriceFacet), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #4 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(100): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #5 engine/Shopware/Bundle/SearchBundle/ProductSearch.php(65): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #6 engine/Shopware/Bundle/SearchBundle/VariantSearch.php(63): Shopware\Bundle\SearchBundle\ProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #7 engine/Shopware/Core/sArticles.php(2397): Shopware\Bundle\SearchBundle\VariantSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #8 engine/Shopware/Core/sArticles.php(460): sArticles->getListing('13', Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext), Object(Enlight_Controller_Request_RequestHttp), Object(Shopware\Bundle\SearchBundle\Criteria)) #9 engine/Shopware/Controllers/Frontend/Listing.php(551): sArticles->sGetArticlesByCategory('13', Object(Shopware\Bundle\SearchBundle\Criteria)) #10 engine/Shopware/Controllers/Frontend/Listing.php(84): Shopware_Controllers_Frontend_Listing->loadCategoryListing('13', Array) #11 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Frontend_Listing->indexAction() #12 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('indexAction') #13 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(443): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(339): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #19 engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(205): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main} ```   ---
**Author:** ![michaelg](https://avatars.discourse-cdn.com/v4/letter/m/77aa72/32.png) [@michaelg](https://forum.shopware.com/u/michaelg)\ **Post date:** [25. Juni 2018 um 08:09 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/2 "2018-06-25T08:09:24Z")
Es scheint mehrere Leute mit Problemen bei den Filtern zu geben. Ich habe vor ein paar Tagen einen Bug gemeldet, der scheinbar auch wahrgenommen wurde: > **[Shopware Issuetracker](https://issues.shopware.com/issues/SW-21972)** Ich habe auch einen Link zu diesem Eintrag gepostet, damit alle Meldungen zentral gesammelt sind. ---
**Author:** ![Danio](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Danio](https://forum.shopware.com/u/Danio)\ **Post date:** [29. August 2018 um 14:08 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/3 "2018-08-29T14:08:24Z")
Wurde das Problem bei euch gelöst mit dem 5.4.6 Update?  ---
**Author:** ![Danio](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Danio](https://forum.shopware.com/u/Danio)\ **Post date:** [29. August 2018 um 15:06 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/4 "2018-08-29T15:06:11Z")
**Bei mir besteht das Problem weiterhin - auch nach dem 5.4.6 updatet. Habe schon einiges probiert, aber leider finde ich das Problem nicht. Das Problem tritt nur auf, wenn ich nach Varianten Filtern möchte. Alle anderen Filter funktionieren ohne Probleme.**   \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Deine Sitzung ist aus Sicherheitsgründen abgelaufen, bitte logge dich erneut ein.   An exception occurred while executing ‘SELECT listing\_price.cheapest\_price FROM s\_articles product INNER JOIN s\_articles\_details variant ON variant.articleID = product.id AND variant.active = 1 AND product.active = 1 INNER JOIN s\_articles\_categories\_ro productCategory6 ON productCategory6.articleID = product.id AND productCategory6.categoryID IN (?) LEFT JOIN s\_articles\_avoid\_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (?) INNER JOIN s\_articles\_attributes productAttribute ON productAttribute.articledetailsID = variant.id INNER JOIN s\_article\_configurator\_option\_relations options\_15 ON variant.id = options\_15.article\_id AND (options\_15.option\_id = ?) LEFT JOIN (SELECT IFNULL(listing\_price.`id`, onsale\_listing\_price.`id`) `id`,IFNULL(listing\_price.`pricegroup`, onsale\_listing\_price.`pricegroup`) `pricegroup`,IFNULL(listing\_price.`from`, onsale\_listing\_price.`from`) `from`,IFNULL(listing\_price.`to`, onsale\_listing\_price.`to`) `to`,IFNULL(listing\_price.`articleID`, onsale\_listing\_price.`articleID`) `articleID`,IFNULL(listing\_price.`articledetailsID`, onsale\_listing\_price.`articledetailsID`) `articledetailsID`,IFNULL(listing\_price.`price`, onsale\_listing\_price.`price`) `price`,IFNULL(listing\_price.`pseudoprice`, onsale\_listing\_price.`pseudoprice`) `pseudoprice`,IFNULL(listing\_price.`baseprice`, onsale\_listing\_price.`baseprice`) `baseprice`,IFNULL(listing\_price.`percent`, onsale\_listing\_price.`percent`) `percent`, IFNULL(listing\_price.cheapest\_price, onsale\_listing\_price.cheapest\_price) AS cheapest\_price, IFNULL(listing\_price.variant\_id, onsale\_listing\_price.variant\_id) AS variant\_id, IFNULL(listing\_price.different\_price\_count, onsale\_listing\_price.different\_price\_count) AS different\_price\_count, IFNULL(listing\_price.product\_id, onsale\_listing\_price.product\_id) AS product\_id FROM s\_articles\_details variant LEFT JOIN (SELECT prices.\*, MIN(ROUND(prices.price \* ((100 - IFNULL(priceGroup.discount, 0)) / 100) \* (( (CASE tax.id WHEN 1 THEN 19 WHEN 2 THEN 0 END) + 100) / 100) \* 1, 2)) AS cheapest\_price, COUNT(DISTINCT price) as different\_price\_count FROM s\_articles product INNER JOIN (SELECT IFNULL(customerPrice.`id`, defaultPrice.`id`) as `id`,IFNULL(customerPrice.`pricegroup`, defaultPrice.`pricegroup`) as `pricegroup`,IFNULL(customerPrice.`from`, defaultPrice.`from`) as `from`,IFNULL(customerPrice.`to`, defaultPrice.`to`) as `to`,IFNULL(customerPrice.`articleID`, defaultPrice.`articleID`) as `articleID`,IFNULL(customerPrice.`articledetailsID`, defaultPrice.`articledetailsID`) as `articledetailsID`,IFNULL(customerPrice.`price`, defaultPrice.`price`) as `price`,IFNULL(customerPrice.`pseudoprice`, defaultPrice.`pseudoprice`) as `pseudoprice`,IFNULL(customerPrice.`baseprice`, defaultPrice.`baseprice`) as `baseprice`,IFNULL(customerPrice.`percent`, defaultPrice.`percent`) as `percent` FROM s\_articles\_prices defaultPrice LEFT JOIN s\_articles\_prices customerPrice ON customerPrice.articledetailsID = defaultPrice.articledetailsID AND customerPrice.pricegroup = ? INNER JOIN s\_articles\_details details ON details.id = defaultPrice.articledetailsID WHERE (defaultPrice.pricegroup = ?) AND ((details.laststock \* details.instock) \>= (details.laststock \* details.minpurchase))) prices ON product.id = prices.articleID INNER JOIN s\_core\_tax tax ON tax.id = product.taxID INNER JOIN s\_articles\_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s\_core\_pricegroups\_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 INNER JOIN s\_articles\_details variant ON variant.id = prices.articledetailsID AND variant.active = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY prices.articleID) listing\_price ON listing\_price.product\_id = variant.articleId LEFT JOIN (SELECT prices.\*, MAX(ROUND(prices.price \* ((100 - IFNULL(priceGroup.discount, 0)) / 100) \* (( (CASE tax.id WHEN 1 THEN 19 WHEN 2 THEN 0 END) + 100) / 100) \* 1, 2)) AS cheapest\_price, COUNT(DISTINCT price) as different\_price\_count FROM s\_articles product INNER JOIN (SELECT IFNULL(customerPrice.`id`, defaultPrice.`id`) as `id`,IFNULL(customerPrice.`pricegroup`, defaultPrice.`pricegroup`) as `pricegroup`,IFNULL(customerPrice.`from`, defaultPrice.`from`) as `from`,IFNULL(customerPrice.`to`, defaultPrice.`to`) as `to`,IFNULL(customerPrice.`articleID`, defaultPrice.`articleID`) as `articleID`,IFNULL(customerPrice.`articledetailsID`, defaultPrice.`articledetailsID`) as `articledetailsID`,IFNULL(customerPrice.`price`, defaultPrice.`price`) as `price`,IFNULL(customerPrice.`pseudoprice`, defaultPrice.`pseudoprice`) as `pseudoprice`,IFNULL(customerPrice.`baseprice`, defaultPrice.`baseprice`) as `baseprice`,IFNULL(customerPrice.`percent`, defaultPrice.`percent`) as `percent` FROM s\_articles\_prices defaultPrice LEFT JOIN s\_articles\_prices customerPrice ON customerPrice.articledetailsID = defaultPrice.articledetailsID AND customerPrice.pricegroup = ? WHERE defaultPrice.pricegroup = ?) prices ON product.id = prices.articleID INNER JOIN s\_core\_tax tax ON tax.id = product.taxID INNER JOIN s\_articles\_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s\_core\_pricegroups\_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 INNER JOIN s\_articles\_details variant ON variant.id = prices.articledetailsID AND variant.active = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY prices.articleID) onsale\_listing\_price ON onsale\_listing\_price.product\_id = variant.articleId) listing\_price ON listing\_price.product\_id = variant.articleId WHERE (avoidCustomerGroup.articleID IS NULL) AND (variant.active = 1) GROUP BY product.id ORDER BY listing\_price.cheapest\_price ASC LIMIT 1 OFFSET 0’ with params [5, 3, 15, “BK”, “EK”, 3, “BK”, “EK”, 3]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘listing\_price.variant\_id’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 ---
**Author:** ![Danio](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Danio](https://forum.shopware.com/u/Danio)\ **Post date:** [4. September 2018 um 11:02 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/5 "2018-09-04T11:02:35Z")
Huhu ,   kann niemand bei der Fehlerdiganose helfen kann? Hat nicht mal Shopware interessiert, dachte der Fehler wurde behoben? Vielleicht wird auch eine wichtige Änderung überschrieben, nur müsste ich diese irgendwie lokalesieren. Komme mit der Fehlermeldung jedoch nicht weiter . \*HELP\* ![Undecided](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/8ae622c50104e84c5003fedfcc22572813a67b41.png "Undecided") ---
**Author:** ![she4www](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@she4www](https://forum.shopware.com/u/she4www)\ **Post date:** [4. September 2018 um 11:06 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/6 "2018-09-04T11:06:42Z")
Ich hatte gestern auch den Fehler 2 bis 3x. Allerdings habe ich SW-Cache und Browser-Cache und Cookies gelöscht, danach gings wieder. Aber trotzdem hatte ich den fehler auch… ![Undecided](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/8ae622c50104e84c5003fedfcc22572813a67b41.png "Undecided") ---
**Author:** ![Danio](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Danio](https://forum.shopware.com/u/Danio)\ **Post date:** [4. September 2018 um 11:40 UTC](https://forum.shopware.com/t/error-varianten-filter/53586/7 "2018-09-04T11:40:18Z")
SW Cache lösche ich auch immer - Browser und Cookies habe ich nicht gelöscht. Habe aber dafür einen anderen Browser probiert .