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

Overview

You may find this error when using the Porto theme installed and working with either the parent or child theme on Magento.

When you try to search for a product, you may get the following error:

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

The 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 NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e` INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 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_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='3' WHERE (stock_status_index.stock_status = 1) ORDER BY `search_result`.`score` desc LIMIT 9

This issue was caused by the file:

Key steps and notes

public_html/app/code/Mageplaza/LayeredNavigation/Model/ResourceModel/Fulltext/Collection.php

A part of the code in that file had been commented out.

$table = $temporaryStorage->storeDocuments($this->searchResult->getItems()); $this->getSelect()->joinInner( [ 'search_result' => $table->getName(), ], 'e.entity_id = search_result.' . TemporaryStorage::FIELD_ENTITY_ID, []
);

This code creates the temporary search_result table. However, if it is commented out, the query will still try to use the following line:

ORDER BY `search_result`.`score` desc

Final notes

Since the search_result table is never joined, Magento throws the error about the missing column.

Removing the comments around this block of code resolved the issue.