Error Varianten Filter

maximum3012 · 19. Juni 2018 um 19:03

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}

michaelg · 25. Juni 2018 um 08:09

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:

Ich habe auch einen Link zu diesem Eintrag gepostet, damit alle Meldungen zentral gesammelt sind.

Danio · 29. August 2018 um 14:08

Wurde das Problem bei euch gelöst mit dem 5.4.6 Update?

Danio · 29. August 2018 um 15:06

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

Danio · 4. September 2018 um 11:02

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*

she4www · 4. September 2018 um 11:06

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…

Danio · 4. September 2018 um 11:40

SW Cache lösche ich auch immer - Browser und Cookies habe ich nicht gelöscht. Habe aber dafür einen anderen Browser probiert .

Thema		Antworten	Aufrufe
Filter Live nachladen erzeugt Fehler im Frontend Allgemein	2	452	28. August 2018
SQL Fehler nach Update auf 5.4.4 - Shopware oder Plugin Problem? Administration	6	1409	2. Juli 2018
Fehler beim erstellen von Varianten Shopware 3.5 installation--gettin	15	1758	27. November 2014
Fehler bei der Erstellung von Varianten Artikel Allgemein	0	244	10. September 2018
Habe das Problem, wenn ich auf Bestellungen im Backen klicke, dann kommt folgende Fehlermeldung! Allgemein	3	406	25. Oktober 2019

Error Varianten Filter

Verwandte Themen