Hallo Leute,
sobald ich die Einstellung „Filter live nachladen“ aktiviere kommt bei mir ein Fehler im Frontend.
ich habe mir den Fehler mit Hilfe der Config Anpassung angezeigen lassen, aber ich kann nichts daraus erkennen.
Kann mir jemand vielleicht erklären, was Probleme bereitet ?
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 (?) LEFT JOIN s_articles_details swkweAvailableDetail ON swkweAvailableDetail.articleID = product.id AND swkweAvailableDetail.active = 1 AND (swkweAvailableDetail.instock - ?) >= swkweAvailableDetail.minpurchase INNER JOIN s_articles_categories_ro product_categories ON product_categories.articleID = product.id INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id INNER JOIN s_article_configurator_option_relations options_17 ON variant.id = options_17.article_id AND (options_17.option_id = ?) LEFT JOIN (SELECT IFNULL(listing_price.options_17_id, onsale_listing_price.options_17_id) AS options_17_id, 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 INNER JOIN s_article_configurator_option_relations options_17 ON variant.id = options_17.article_id AND (options_17.option_id = ?) 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, prices.articledetailsID AS variant_id, COUNT(DISTINCT price) as different_price_count, prices.articleID AS product_id, options_17.option_id AS options_17_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 INNER JOIN s_article_configurator_option_relations options_17 ON options_17.article_id = prices.articledetailsID WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY options_17.option_id, prices.articleID) listing_price ON listing_price.product_id = variant.articleId AND listing_price.options_17_id = options_17.option_id 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, prices.articledetailsID AS variant_id, COUNT(DISTINCT price) as different_price_count, prices.articleID AS product_id, options_17.option_id AS options_17_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 INNER JOIN s_article_configurator_option_relations options_17 ON options_17.article_id = prices.articledetailsID WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY options_17.option_id, prices.articleID) onsale_listing_price ON onsale_listing_price.product_id = variant.articleId AND onsale_listing_price.options_17_id = options_17.option_id) listing_price ON listing_price.product_id = variant.articleId AND listing_price.options_17_id = options_17.option_id LEFT JOIN s_categories_attributes swkweAvailableCategory ON product_categories.categoryID = swkweAvailableCategory.categoryID AND swkweAvailableCategory.swkwe_show_soldout = 1 WHERE (avoidCustomerGroup.articleID IS NULL) AND ( swkweAvailableDetail.id IS NOT NULL OR swkweAvailableCategory.id IS NOT NULL OR productAttribute.swkwe_show_soldout = 1 ) AND (variant.active = 1) GROUP BY options_17.option_id, product.id ORDER BY listing_price.cheapest_price ASC LIMIT 1 OFFSET 0' with params [5, 1, 0, 17, 17, "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
