June 2, 2020 - Magento Tips & Tweaks

Column not found: 1054 Unknown column ‘search_result.score’ in ‘order clause’

[vc_row][vc_column][vc_column_text]You may find this error probably using Porto theme installed and work with the parent or child theme on magento. When you try to search for a product you get this error: Column not found: 1054 Unknown column ‘search_result.score’ in ‘order clause’. query was: SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT […]