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

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:

<Site>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

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.