To reproduce the issue please create module with type of content -> categories. Set all display limited to YES. Create another module witch should show products. Both modules on same page. Try to access product page and it will give 404 error.
Code:
1054 Unknown column 'a.product_quantity' in 'on clause' SQL=SELECT count(a.product_id) AS number_of_products,a.category_id FROM #__hikashop_product_category AS a INNER JOIN #__hikashop_product AS b ON a.product_id = b.product_id AND b.product_published > 0 AND a.product_quantity != 0 AND b.product_parent_id = 0 WHERE a.category_id IN (148,164,161,154,149,156,153,184,151,155,150,183,179) GROUP BY a.category_id
