I am facing a strange kind of issue, which i never came across before.
I have seen an increased number of server errors in my webmaster tool, when investigating I found this issue.
the URL which is giving this error is a simply brand filtered URL. which should be ok, but when going on this URL it gives a server error.
after investigating this in more details found out that manufacturer 4664 is simply deleted from our list as it isnt available for sale any more. you can see the error on that url. summry here:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.min_price' in 'field list', query was: SELECT FLOOR((ROUND(((e.min_price +(e.min_price*CASE e.tax_class_id WHEN 2 THEN 0.2000 ELSE 0 END))) * 1, 2)) / 1) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '36' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = 1 AND manufacturer_idx.value = '4664' GROUP BY FLOOR((ROUND(((e.min_price +(e.min_price*CASE e.tax_class_id WHEN 2 THEN 0.2000 ELSE 0 END))) * 1, 2)) / 1) + 1 ORDER BY FLOOR((ROUND(((e.min_price +(e.min_price*CASE e.tax_class_id WHEN 2 THEN 0.2000 ELSE 0 END))) * 1, 2)) / 1) + 1 ASC
I have 2 concerns,
- showing the error log on front end, doesn't that put our site security on risk?
- and if our site can not found this URL or brand, why it isn't showing simple 404 page?
rest site is working fine and 404 page is working fine as well.
any help would be appreciated