2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opexim_m2.catalogsearch_fulltext_scope1' doesn't exist, query was: SELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `eav_index`.`entity_id`, (((0) + (0)) * 1 + LEAST((MATCH (data_index) AGAINST ('Duză* cu* cor*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalog_product_index_eav` AS `eav_index` INNER JOIN `catalogsearch_fulltext_scope1` AS `search_index` ON eav_index.entity_id = search_index.entity_id INNER JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = eav_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 eav_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (eav_index.store_id = '1') AND (`eav_index`.`attribute_id` = 99 AND `eav_index`.`value` in ('3', '4') AND `eav_index`.`store_id` = '1') AND (category_ids_index.category_id = 4) AND (MATCH (data_index) AGAINST ('Duză* cu* cor*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select` Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opexim_m2.catalogsearch_fulltext_scope1' doesn't exist Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opexim_m2.catalogsearch_fulltext_scope1' doesn't exist, query was: SELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `eav_index`.`entity_id`, (((0) + (0)) * 1 + LEAST((MATCH (data_index) AGAINST ('Duză* cu* cor*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalog_product_index_eav` AS `eav_index` INNER JOIN `catalogsearch_fulltext_scope1` AS `search_index` ON eav_index.entity_id = search_index.entity_id INNER JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = eav_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 eav_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (eav_index.store_id = '1') AND (`eav_index`.`attribute_id` = 99 AND `eav_index`.`value` in ('3', '4') AND `eav_index`.`store_id` = '1') AND (category_ids_index.category_id = 4) AND (MATCH (data_index) AGAINST ('Duză* cu* cor*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`
#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303] #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:542] #5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617] #6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:828] #7 Zend_Db_Adapter_Abstract->fetchOne() called at [vendor/magento/framework/Search/Adapter/Mysql/Adapter.php:143] #8 Magento\Framework\Search\Adapter\Mysql\Adapter->getSize() called at [vendor/magento/framework/Search/Adapter/Mysql/Adapter.php:100] #9 Magento\Framework\Search\Adapter\Mysql\Adapter->query() called at [vendor/magento/module-search/Model/SearchEngine.php:42] #10 Magento\Search\Model\SearchEngine->search() called at [vendor/amasty/shopby/Model/ResourceModel/Fulltext/Collection.php:385] #11 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:343] #12 Magento\Framework\Data\Collection\AbstractDb->_renderFilters() called at [vendor/amasty/shopby/Model/ResourceModel/Fulltext/Collection.php:308] #13 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection->_renderFilters() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:1149] #14 Magento\Catalog\Model\ResourceModel\Product\Collection->_getSelectCountSql() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:1137] #15 Magento\Catalog\Model\ResourceModel\Product\Collection->getSelectCountSql() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:453] #16 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getSelectCountSql() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:221] #17 Magento\Framework\Data\Collection\AbstractDb->getSize() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:1389] #18 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getSize() called at [vendor/magento/framework/Data/Collection.php:259] #19 Magento\Framework\Data\Collection->getLastPageNumber() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:1623] #20 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getLastPageNumber() called at [vendor/magento/module-theme/Block/Html/Pager.php:339] #21 Magento\Theme\Block\Html\Pager->getLastPageNum() called at [generated/code/Magento/Theme/Block/Html/Pager/Interceptor.php:245] #22 Magento\Theme\Block\Html\Pager\Interceptor->getLastPageNum() called at [vendor/amasty/shopby-seo/Observer/LayoutGenerateBlocksAfterObserver.php:64] #23 Amasty\ShopbySeo\Observer\LayoutGenerateBlocksAfterObserver->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88] #24 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74] #25 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66] #26 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95] #27 Magento\Framework\Event\Manager\Proxy->dispatch() called at [vendor/magento/framework/View/Layout/Builder.php:134] #28 Magento\Framework\View\Layout\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Page/Builder.php:55] #29 Magento\Framework\View\Page\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Layout/Builder.php:65] #30 Magento\Framework\View\Layout\Builder->build() called at [vendor/magento/framework/View/Page/Config.php:212] #31 Magento\Framework\View\Page\Config->build() called at [vendor/magento/framework/View/Page/Config.php:225] #32 Magento\Framework\View\Page\Config->publicBuild() called at [generated/code/Magento/Framework/View/Page/Config/Interceptor.php:37] #33 Magento\Framework\View\Page\Config\Interceptor->publicBuild() called at [vendor/magento/framework/App/View.php:170] #34 Magento\Framework\App\View->loadLayoutUpdates() called at [vendor/magento/framework/App/View.php:114] #35 Magento\Framework\App\View->loadLayout() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:166] #36 Magento\CatalogSearch\Controller\Result\Index->getNotCacheableResult() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:110] #37 Magento\CatalogSearch\Controller\Result\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58] #38 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #39 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/amasty/xsearch/Plugin/CatalogSearch/Controller/Result/Index.php:72] #40 Amasty\Xsearch\Plugin\CatalogSearch\Controller\Result\Index->aroundExecute() called at [vendor/magento/framework/Interception/Interceptor.php:135] #41 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #42 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:26] #43 Magento\CatalogSearch\Controller\Result\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108] #44 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #45 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #46 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #47 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:39] #48 Magento\CatalogSearch\Controller\Result\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:159] #49 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:99] #50 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #51 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #52 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:94] #53 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #54 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:73] #55 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #56 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #57 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26] #58 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:137] #59 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24] #60 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261] #61 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'opexim_m2.catalogsearch_fulltext_scope1' doesn't exist
#1 Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:107] #2 Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:92] #3 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303] #4 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480] #5 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238] #6 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:542] #7 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617] #8 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:828] #9 Zend_Db_Adapter_Abstract->fetchOne() called at [vendor/magento/framework/Search/Adapter/Mysql/Adapter.php:143] #10 Magento\Framework\Search\Adapter\Mysql\Adapter->getSize() called at [vendor/magento/framework/Search/Adapter/Mysql/Adapter.php:100] #11 Magento\Framework\Search\Adapter\Mysql\Adapter->query() called at [vendor/magento/module-search/Model/SearchEngine.php:42] #12 Magento\Search\Model\SearchEngine->search() called at [vendor/amasty/shopby/Model/ResourceModel/Fulltext/Collection.php:385] #13 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:343] #14 Magento\Framework\Data\Collection\AbstractDb->_renderFilters() called at [vendor/amasty/shopby/Model/ResourceModel/Fulltext/Collection.php:308] #15 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection->_renderFilters() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:1149] #16 Magento\Catalog\Model\ResourceModel\Product\Collection->_getSelectCountSql() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:1137] #17 Magento\Catalog\Model\ResourceModel\Product\Collection->getSelectCountSql() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:453] #18 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getSelectCountSql() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:221] #19 Magento\Framework\Data\Collection\AbstractDb->getSize() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:1389] #20 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getSize() called at [vendor/magento/framework/Data/Collection.php:259] #21 Magento\Framework\Data\Collection->getLastPageNumber() called at [generated/code/Amasty/Shopby/Model/ResourceModel/Fulltext/Collection/Interceptor.php:1623] #22 Amasty\Shopby\Model\ResourceModel\Fulltext\Collection\Interceptor->getLastPageNumber() called at [vendor/magento/module-theme/Block/Html/Pager.php:339] #23 Magento\Theme\Block\Html\Pager->getLastPageNum() called at [generated/code/Magento/Theme/Block/Html/Pager/Interceptor.php:245] #24 Magento\Theme\Block\Html\Pager\Interceptor->getLastPageNum() called at [vendor/amasty/shopby-seo/Observer/LayoutGenerateBlocksAfterObserver.php:64] #25 Amasty\ShopbySeo\Observer\LayoutGenerateBlocksAfterObserver->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88] #26 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74] #27 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66] #28 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95] #29 Magento\Framework\Event\Manager\Proxy->dispatch() called at [vendor/magento/framework/View/Layout/Builder.php:134] #30 Magento\Framework\View\Layout\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Page/Builder.php:55] #31 Magento\Framework\View\Page\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Layout/Builder.php:65] #32 Magento\Framework\View\Layout\Builder->build() called at [vendor/magento/framework/View/Page/Config.php:212] #33 Magento\Framework\View\Page\Config->build() called at [vendor/magento/framework/View/Page/Config.php:225] #34 Magento\Framework\View\Page\Config->publicBuild() called at [generated/code/Magento/Framework/View/Page/Config/Interceptor.php:37] #35 Magento\Framework\View\Page\Config\Interceptor->publicBuild() called at [vendor/magento/framework/App/View.php:170] #36 Magento\Framework\App\View->loadLayoutUpdates() called at [vendor/magento/framework/App/View.php:114] #37 Magento\Framework\App\View->loadLayout() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:166] #38 Magento\CatalogSearch\Controller\Result\Index->getNotCacheableResult() called at [vendor/magento/module-catalog-search/Controller/Result/Index.php:110] #39 Magento\CatalogSearch\Controller\Result\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58] #40 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #41 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/amasty/xsearch/Plugin/CatalogSearch/Controller/Result/Index.php:72] #42 Amasty\Xsearch\Plugin\CatalogSearch\Controller\Result\Index->aroundExecute() called at [vendor/magento/framework/Interception/Interceptor.php:135] #43 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #44 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:26] #45 Magento\CatalogSearch\Controller\Result\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108] #46 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #47 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #48 Magento\CatalogSearch\Controller\Result\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #49 Magento\CatalogSearch\Controller\Result\Index\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogSearch/Controller/Result/Index/Interceptor.php:39] #50 Magento\CatalogSearch\Controller\Result\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:159] #51 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:99] #52 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58] #53 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138] #54 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:94] #55 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #56 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:73] #57 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135] #58 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153] #59 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26] #60 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:137] #61 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24] #62 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261] #63 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]