swissup / module-search-mysql-legacy Goto Github PK

PHP 100.00%

magento magento2 magento2-extension magento2-module magento2-search

module-search-mysql-legacy's Introduction

Legacy Mysql Search

^{It's a magento2-module for the metapackage.}

The news sometimes isn't good, but there is always a way out. Yes, MySQL is no longer supported for search since Magento 2.4. And you must install Elasticsearch 7.6.x before upgrading to the latest Magento version.

Elastic search is a great solution. Even so, a lot of our customers still prefer using hostings that don’t have it. Let us help you to install Magento 2.4 without Elastic search enabled.

We released the Legacy MySQL Search module for Magento 2

We integrated Magento 2.3.5 MySQL Search mechanism with Magento 2.4. The Legacy MySQL Search module enables a new value in the Search Engine drop-down of Catalog Search config settings.

So you don’t need things to get complicated. You have simply to choose the "Legacy MySQL (Deprecated) value" in drop-down.

Installation

For clients

There are several ways to install extension for clients:

If you've bought the product at Magento's Marketplace - use Marketplace installation instructions
Otherwise, you have two options:
- Install the sources directly from our repository - recommended
- Download archive and use manual installation

For maintainers

cd <magento_root>
composer config repositories.swissup composer https://docs.swissuplabs.com/packages/
composer require swissup/module-search-mysql-legacy --prefer-source --ignore-platform-reqs
bin/magento module:enable Swissup_SearchMysqlLegacy Swissup_Core
bin/magento setup:upgrade --safe-mode=1
bin/magento setup:di:compile
bin/magento indexer:reindex catalogsearch_fulltext

F.A.Q

How to install Magento 2.4.0 without Elasticsearch require during installation?

Use --disable-modules option

bin/magento setup:install -h
...
--disable-modules[=DISABLE-MODULES] List of comma-separated module names, that must be avoided during installation.

php bin/magento setup:install --disable-modules=Magento_InventoryElasticsearch,Magento_Elasticsearch7,Magento_Elasticsearch6,Magento_Elasticsearch

After installing enable all elastic search module with below command.

php bin/magento module:enable Magento_Elasticsearch Magento_Elasticsearch6 Magento_Elasticsearch7 Magento_InventoryElasticsearch

How can I check current search engine?

You can check your current search engine using:

bin/magento config:show catalog/search/engine

How can I change search engine?

You can change your current search engine using:

bin/magento config:set catalog/search/engine 'lmysql'

module-search-mysql-legacy's People

Contributors

Stargazers

Watchers

module-search-mysql-legacy's Issues

Search results not showing proper in Search result page

Hi,

We facing some issues in Search result page or items not showing first as per the checked sorting by "Relevance" not working, https://prnt.sc/FpijNVEaxAX-
can you fix this to work properly?

unexpected token "match" Magento 2.4.5-p1 with PHP 8.1

I face below error during setup di compile

syntax error, unexpected token "match", expecting identifier#0 /Sites/mysite/setup/src/Magento/Setup/Module/Di/Code/Reader/ClassesScanner.php(117): Magento\Setup\Module\Di\Code\Reader\ClassesScanner->includeClass('Swissup\\SearchM...

Magento 2.4.5-p1
Php 8.1

After further investigation found that class Magento\Framework\Search\Request\Query\Filter which is used in \Swissup\SearchMysqlLegacy\SearchAdapter\Mysql\Mapper is no longer available in Magento 2.4.5-p1.

Can you provide fix for this?

trim(): Passing null to parameter #1 ($string) of type string is deprecated

php8.1

Exception #0 (Exception): Deprecated Functionality: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/vendor/swissup/module-core/Plugin/SetEmptyStringIfOutputEmpty.php on line 18

Exception #0 (Exception): Deprecated Functionality: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/vendor/swissup/module-core/Plugin/SetEmptyStringIfOutputEmpty.php on line 18
<pre>#1 trim() called at [vendor/swissup/module-core/Plugin/SetEmptyStringIfOutputEmpty.php:18]
#2 Swissup\Core\Plugin\SetEmptyStringIfOutputEmpty->afterToHtml() called at [vendor/magento/framework/Interception/Interceptor.php:146]
#3 Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#4 Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor->___callPlugins() called at [generated/code/Magento/Wishlist/Block/Catalog/Product/ProductList/Item/AddTo/Wishlist/Interceptor.php:527]
#5 Magento\Wishlist\Block\Catalog\Product\ProductList\Item\AddTo\Wishlist\Interceptor->toHtml() called at [vendor/magento/framework/View/Layout.php:578]
#6 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:555]

Indexing stopped working

I have installed the LMYSQL extension for Magento.
Unfortunately, the indexing does not work anymore.

Magento is in version 2.4.3.
I have activated Legacy MySQL and Enable EAV Indexer (Yes) under Shops -> configuration -> catalog -> catalog search -> search engine.

Exception on Advanced Search

When browsing to the advanced search there is an exception

1 exception(s):
Exception #0 (BadMethodCallException): Missing required argument $strategies of Magento\CatalogSearch\Model\Advanced\ProductCollectionPrepareStrategyProvider.

Exception #0 (BadMethodCallException): Missing required argument $strategies of Magento\CatalogSearch\Model\Advanced\ProductCollectionPrepareStrategyProvider.
<pre>#1 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgumentsInRuntime() called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:34]
#2 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->_resolveArguments() called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:59]
#3 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create() called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#4 Magento\Framework\ObjectManager\ObjectManager->get() called at [vendor/magento/module-catalog-search/Model/Advanced.php:171]
#5 Magento\CatalogSearch\Model\Advanced->__construct() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121]
#6 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject() called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:66]
#7 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create() called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#8 Magento\Framework\ObjectManager\ObjectManager->get() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:170]
#9 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgument() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:276]
#10 Magento\Framework\ObjectManager\Factory\AbstractFactory->getResolvedArgument() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:239]
#11 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgumentsInRuntime() called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:34]
#12 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->_resolveArguments() called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:59]
#13 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create() called at [vendor/magento/framework/ObjectManager/ObjectManager.php:56]
#14 Magento\Framework\ObjectManager\ObjectManager->create() called at [vendor/magento/framework/View/Element/BlockFactory.php:46]
#15 Magento\Framework\View\Element\BlockFactory->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:272]
#16 Magento\Framework\View\Layout\Generator\Block->getBlockInstance() called at [vendor/magento/framework/View/Layout/Generator/Block.php:252]
#17 Magento\Framework\View\Layout\Generator\Block->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:229]
#18 Magento\Framework\View\Layout\Generator\Block->generateBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:134]
#19 Magento\Framework\View\Layout\Generator\Block->process() called at [vendor/magento/framework/View/Layout/GeneratorPool.php:93]
#20 Magento\Framework\View\Layout\GeneratorPool->process() called at [vendor/magento/framework/View/Layout.php:365]
#21 Magento\Framework\View\Layout->generateElements() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#22 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#23 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#24 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:68]
#25 Magento\Framework\View\Layout\Interceptor->generateElements() called at [vendor/magento/framework/View/Layout/Builder.php:129]
#26 Magento\Framework\View\Layout\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Page/Builder.php:65]
#27 Magento\Framework\View\Page\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Layout/Builder.php:65]
#28 Magento\Framework\View\Layout\Builder->build() called at [vendor/magento/framework/View/Page/Config.php:224]
#29 Magento\Framework\View\Page\Config->build() called at [vendor/magento/framework/View/Page/Config.php:237]
#30 Magento\Framework\View\Page\Config->publicBuild() called at [vendor/magento/framework/View/Result/Page.php:244]
#31 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#32 Magento\Framework\View\Result\Layout->renderResult() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#33 Magento\Framework\View\Result\Page\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#34 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Magezon/Core/Plugin/View/Result/Layout.php:24]
#35 Magezon\Core\Plugin\View\Result\Layout->aroundRenderResult() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#36 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#37 Magento\Framework\View\Result\Page\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Result/Page/Interceptor.php:95]
#38 Magento\Framework\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#39 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23]
#40 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:264]
#41 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]
</pre>

It can be solved by adding to a di.xml the type definition and the custom class that can be copied from Magento\Elasticsearch\Model\Advanced\ProductCollectionPrepareStrategy

    <type name="Magento\CatalogSearch\Model\Advanced\ProductCollectionPrepareStrategyProvider">
        <arguments>
            <argument name="strategies" xsi:type="array">
                <item name="lmysql" xsi:type="object">Vendor\Module\Model\Advanced\ProductCollectionPrepareStrategy</item>
            </argument>
        </arguments>
    </type>

issue with index building and search

Hi, after instal and few tries of reindex on search. It looks like reindex can't create tables. Reindexing on 2000 products takes less than 1s ;)
I've got error like this:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTOsearch_tmp_632cc6ff9ef500_89290962SELECTmain_select.entity_id, SUM(score) AS relevanceFROM (SELECT DISTINCT eav_index.entity_id, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS scoreFROMcatalog_product_index_eavASeav_indexINNER JOINcatalogsearch_fulltext_scope1ASsearch_indexON eav_index.entity_id = search_index.entity_id INNER JOINcatalog_eav_attributeASceaON search_index.attribute_id = cea.attribute_id INNER JOINcataloginventory_stock_statusASstock_indexON stock_index.product_id = eav_index.entity_id ANDstock_index.website_id= 0 ANDstock_index.stock_status= 1 ANDstock_index.stock_id = 1 WHERE (eav_index.store_id = '1') AND (eav_index.attribute_id= 99 ANDeav_index.valuein ('3', '4') ANDeav_index.store_id= '1') AND (MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE))) ASmain_selectGROUP BYentity_idException #1 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTOsearch_tmp_632cc6ff9ef500_89290962SELECTmain_select.entity_id, SUM(score) AS relevanceFROM (SELECT DISTINCT eav_index.entity_id, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS scoreFROMcatalog_product_index_eavASeav_indexINNER JOINcatalogsearch_fulltext_scope1ASsearch_indexON eav_index.entity_id = search_index.entity_id INNER JOINcatalog_eav_attributeASceaON search_index.attribute_id = cea.attribute_id INNER JOINcataloginventory_stock_statusASstock_indexON stock_index.product_id = eav_index.entity_id ANDstock_index.website_id= 0 ANDstock_index.stock_status= 1 ANDstock_index.stock_id = 1 WHERE (eav_index.store_id = '1') AND (eav_index.attribute_id= 99 ANDeav_index.valuein ('3', '4') ANDeav_index.store_id= '1') AND (MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE))) ASmain_selectGROUP BYentity_id Exception #2 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist

Product sorting not working anymore

After i select the mysql-legacy option the category product sorting is not working anymore, when i switch to elasticsearch 7 it's working again. I don't want to use es so if there is a solution for this.

Sourece class for virtualType SwissupAjaxsearchModelLayerSearchItemCollectionProvider does not exist

Hello,

There's the following declaration in this module's di.xml file:

    <virtualType name="SwissupAjaxsearchModelLayerSearchItemCollectionProvider" type="Swissup\Ajaxsearch\Model\Layer\Search\ItemCollectionProvider">
        <arguments>
            <argument name="factories" xsi:type="array">
                <item name="lmysql" xsi:type="object">Swissup\Ajaxsearch\Model\ResourceModel\Fulltext\SearchCollectionFactory</item>
            </argument>
        </arguments>
    </virtualType>

Upon running bin/magento setup:di:compile the following is output to the debug.log:

[2023-01-01T07:22:18.829570+00:00] main.DEBUG: Source class "\Swissup\Ajaxsearch\Model\ResourceModel\Fulltext\SearchCollection" for "Swissup\Ajaxsearch\Model\ResourceModel\Fulltext\SearchCollectionFactory" generation does not exist. {"exception":"[object] (RuntimeException(code: 0): Source class \"\\Swissup\\Ajaxsearch\\Model\\ResourceModel\\Fulltext\\SearchCollection\" for \"Swissup\\Ajaxsearch\\Model\\ResourceModel\\Fulltext\\SearchCollectionFactory\" generation does not exist. at /var/www/html/vendor/magento/framework/Code/Generator.php:223)"} []

Environment Information

Magento 2 version: 2.4.5-p1
PHP version: 8.1

Using ${var} in strings is deprecated

On Magento 2.4.6 with php8.2 while setup:di:compile a lot of deprecation warnings pop out.

Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /var/www/html/vendor/swissup/module-search-mysql-legacy/SearchAdapter/Mysql/Aggregation/Interval.php on line 58

PHP Deprecated:  Using ${var} in strings is deprecated, use {$var} instead in /var/www/html/vendor/swissup/module-search-mysql-legacy/SearchAdapter/Mysql/Aggregation/Interval.php on line 61

Column not found: '_id_filter._id' (Magento 2.4.5-p1)

Hi,

I'm getting the following error after installing this extension in Magento 2.4.5-p1 when I try to hit a category or search results page:

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column '_id_filter._id' in 'where clause', query was: INSERT INTO `search_tmp_636d2888d9fe88_50721621` (`entity_id`, `score`) SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT  `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index`
 INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1
 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 99 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('10')) AND (`_id_filter`.`_id` NOT IN ('182', '183', '184'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000

Full stack trace:

#2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:564]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:634]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:95]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [app/code/Swissup/SearchMysqlLegacy/SearchAdapter/Mysql/TemporaryStorage.php:117]
#8 Swissup\SearchMysqlLegacy\SearchAdapter\Mysql\TemporaryStorage->storeDocumentsFromSelect() called at [app/code/Swissup/SearchMysqlLegacy/SearchAdapter/Mysql/Adapter.php:103]
#9 Swissup\SearchMysqlLegacy\SearchAdapter\Mysql\Adapter->query() called at [vendor/magento/module-search/Model/SearchEngine.php:42]
#10 Magento\Search\Model\SearchEngine->search() called at [vendor/magento/framework/Search/Search.php:85]
#11 Magento\Framework\Search\Search->search() called at [vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php:464]
#12 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:343]
#13 Magento\Framework\Data\Collection\AbstractDb->_renderFilters() called at [vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php:582]
#14 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFilters() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:929]
#15 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:801]
#16 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#17 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#18 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#19 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Model/ResourceModel/Fulltext/Collection/Interceptor.php:257]
#20 Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load() called at [vendor/magento/module-catalog/Block/Product/ListProduct.php:199]
#21 Magento\Catalog\Block\Product\ListProduct->_beforeToHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1094]
#22 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#23 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:660]
#24 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#25 Magento\Catalog\Block\Product\ListProduct\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#26 Magento\Catalog\Block\Product\ListProduct\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#27 Magento\Catalog\Block\Product\ListProduct\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Block/Product/ListProduct/Interceptor.php:617]
#28 Magento\Catalog\Block\Product\ListProduct\Interceptor->toHtml() called at [vendor/magento/framework/View/Layout.php:578]
#29 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:555]
#30 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#31 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#32 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#33 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Element/AbstractBlock.php:507]
#34 Magento\Framework\View\Element\AbstractBlock->getChildHtml() called at [generated/code/Magento/Catalog/Block/Category/View/Interceptor.php:302]
#35 Magento\Catalog\Block\Category\View\Interceptor->getChildHtml() called at [vendor/magento/module-catalog/Block/Category/View.php:100]
#36 Magento\Catalog\Block\Category\View->getProductListHtml() called at [generated/code/Magento/Catalog/Block/Category/View/Interceptor.php:23]
#37 Magento\Catalog\Block\Category\View\Interceptor->getProductListHtml() called at [vendor/magento/module-catalog/view/frontend/templates/category/products.phtml:15]
#38 include() called at [vendor/magento/framework/View/TemplateEngine/Php.php:71]
#39 Magento\Framework\View\TemplateEngine\Php->render() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#40 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#41 Magento\Framework\View\TemplateEngine\Php\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#42 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/TemplateEngine/Php/Interceptor.php:23]
#43 Magento\Framework\View\TemplateEngine\Php\Interceptor->render() called at [vendor/magento/framework/View/Element/Template.php:263]
#44 Magento\Framework\View\Element\Template->fetchView() called at [generated/code/Magento/Catalog/Block/Category/View/Interceptor.php:140]
#45 Magento\Catalog\Block\Category\View\Interceptor->fetchView() called at [vendor/magento/framework/View/Element/Template.php:293]
#46 Magento\Framework\View\Element\Template->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1095]
#47 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#48 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:660]
#49 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#50 Magento\Catalog\Block\Category\View\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#51 Magento\Catalog\Block\Category\View\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#52 Magento\Catalog\Block\Category\View\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Block/Category/View/Interceptor.php:365]
#53 Magento\Catalog\Block\Category\View\Interceptor->toHtml() called at [vendor/magento/framework/View/Layout.php:578]
#54 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:555]
#55 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#56 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#57 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#58 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#59 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#60 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#61 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#62 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#63 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#64 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#65 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#66 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#67 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#68 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#69 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#70 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#71 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#72 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#73 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#74 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#75 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#76 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#77 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#78 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#79 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#80 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#81 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#82 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#83 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:606]
#84 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:557]
#85 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:149]
#86 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:510]
#87 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:140]
#88 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:975]
#89 Magento\Framework\View\Layout->getOutput() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#90 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#91 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#92 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:347]
#93 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:260]
#94 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#95 Magento\Framework\View\Result\Layout->renderResult() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#96 Magento\Framework\View\Result\Page\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#97 Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#98 Magento\Framework\View\Result\Page\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Result/Page/Interceptor.php:95]
#99 Magento\Framework\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#100 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:264]
#101 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:30]```

CategoryFilter in Layered Navigation not working

Hello,

first of all, thank you for the module. That helped us very much after problems with ElasticSearch.
The only thing dont work with is the category filter. Everything else (Attribute Filtering) working fine. Switching to ES7 shows up the category filter again.
Is it possible to get this working?

Thank you very much,
Andreas

Creation of dynamic property is deprecated

Hello ✋

wanted to let you know:

Deprecated Functionality: Creation of dynamic property Swissup\SearchMysqlLegacy\Model\Adapter\Mysql\Plugin\Aggregation\Category\DataProvider::$layer is deprecated in /vendor/swissup/module-search-mysql-legacy/Model/Adapter/Mysql/Plugin/Aggregation/Category/DataProvider.php on line 63