cancel
Showing results for 
Search instead for 
Did you mean: 

Product Category Error

Product Category Error

We are running Magento 1.9.3.0. Today we have a problem, when we click a standard product the site works fine, however product categories are throwing up the following error:

 

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1' in 'order clause', query was: SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` 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 = '25' AND cat_index.is_parent=1 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 10) + 1 ORDER BY `FLOOR((ROUND((e`.`min_price) * 1, 2)) / 10) + 1` ASC

I've cleared all cache/sessions, flushed cache and re-indexed and it still won't work.

Any help would be appreciated.

 

1 REPLY

Re: Product Category Error

Hi @eightmedia,

 

I don't know if there's a problem with the forum editor but that query has missed some ` symbols.

Can you try that query inside Mysql and check if the query is well formed?

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"